Re: How do I keep the divisor constant in calculating percentage remai

Tech-Archive recommends: Fix windows errors by optimizing your registry

You don't need the =sum() function.

Try:

=d9/b$9
or
=d9/$b$9

The $ sign tells excel not to adjust that part of the address when the formula
is copied.



clpayne wrote:

I have a spread*** 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.

--

Dave Peterson

-----------------------------------------------------------------------------
Less Spam Better enjoyable experience
Visit : news://spacesst.com
.

Quantcast