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?

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

"Trying Hard" <Trying wrote in message
...
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?

Hi

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

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

Mike

"Trying Hard" wrote:

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?

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

"Peo Sjoblom" wrote in message
...
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

"Trying Hard" <Trying wrote in message
...
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?