| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep the divisor constant in calculating percentage remai
I have a spreadsheet where B9 is Funds Appropriated, C9 is Funds Used, D9 is
Balance, and E9 is % Remaining. The formula I have used in E9 is =SUM(D9/B9). When I copy that formula to the next cell down, E10, I get =SUM(D10/B10) . What I want is to have the B9 stay constant, =SUM (D10/B9). How can I do this? I have been manually changing the divisor to B9 all the way down, but I know there has to be an easier way. Is there a better formula that will do this? Thanks from a non-technical user. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating a percentage | Excel Discussion (Misc queries) | |||
| Change divisor if column is 0 | Excel Discussion (Misc queries) | |||
| Calculating Percentage | Excel Worksheet Functions | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
Threaded Mode
