Formula Help

[Trying Hard]

I have a row of #'s, in the row below I want to increase each cell's numer by
3.5%, the next row by 4%, the next row by 4.5%, etc. - what is the formula?

 

[Peo Sjoblom]

Probably an easier way

=$A$1+$A$1*(3.5%+ROWS($A$1:A1)/200-0.005)

with the original value in A1, put the above in A2 and copy down

--


Regards,


Peo Sjoblom

 

[Mike H]

Hi

Assuming your data are in A1, B1 etc put this in A2 and drag right

=A1*(COLUMN(G1)%/2)+A1

Mike

 

[Peo Sjoblom]

Of course you have a row so you can change the formula to columns

and copy to the right instead


=$A$1+$A$1*(3.5%+COLUMNS($A$1:A1)/200-0.005)


--


Regards,


Peo Sjoblom