Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel formula decrease in denominat
Name: usamahashimi Date: December 24, 2008 at 01:19:43 Pacific OS: Windows XP/Ubuntu 8.04 CPU/Ram: Dual Core/1GB Product: Intel / 2008
Comment:
Hi I want to put a formula in Excel in such a way that the denominator automatically decreases by 1 unit in every next cell. Let me explain Consider the following cells: A1 = 8000/50 A2 = 8000/49 A3 = 8000/48 . . . A50= 8000/1 You can see that in every next cell the denominator is decreasing by 1 unit. What formula should I put in 1st cell so that when I drag the formula automatically updates for every next cell i.e it decreases denominator by 1 unit? Thanks
Name: jon_k Date: December 29, 2008 at 07:53:32 Pacific
Reply:
one way is to use ROW(), which returns the current row of the cell. Note the drawback of this is if you insert a row above, it will screw up your formulas.
So your formula in this case would be
=8000/(51-ROW())
0
Response Number 2
Name: usamahashimi Date: December 30, 2008 at 21:45:47 Pacific
Summary: I have created an Excel query in Office 2007 to return a specific set of values from within a named range in my spreadsheet (for example, the 6PM temperature from all days in March from a range contai...
Summary: I need some help with a formula in Excel 03. I have two Excel workbooks. The first WB is a financial report that I am importing data into. I am importing the store number into E4. I also need the fee ...
Summary: Hi All I need some help with a certain Excel formula. Hopefully my explanation is clear enough. Basically I have 3 columns - Days, Hours and Minutes. Currently I put in data for each column and it is ...
0 
Import Data from website ...
