View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
JasonP CCTM LV[_2_] JasonP CCTM LV[_2_] is offline
external usenet poster
 
Posts: 36
Default 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.