Increase by % Formula
What I would do is:
1. Move everything over to Column B so the first value is in B1
2. In A2, put 3.5%
3. In B2, put =B1+(B1*$A$2)
4. Use the copy right function to copy that formula accross Row 2
5. In A3, put 4%
6. In B3, use the same formula except change $A$2 to $A$3
7. Use the copy right function to copy that formula accross Row 3
8. Continue that for as many rows down that you are going.
"Trying Hard" wrote:
Hello,
I have a row of #'s, in the row below I would like to increase each cell's
number by 3.5%, in the next row 4%, etc. What is the formula?
Example of what I'm doing:
In Cell A1 is 60,000
In Cell B1 I put the following formula: =A1*3.5%
(Answer comes out to 2,100, which is correct, but then I want ithe answer to
be 62,100 - it's not adding the 2,100 to the 6,000 for the answer). Please
help!
Thank you.
|