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?