Thread: Formula Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default Formula Help

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?