Increasing by different percentages, formula that can be copied

[gingertumi]

Hello! I'm in search of a formula that can be copied and pasted (or pasted special) for increasing a number by different percentages (10%, 20%, 30%, etc). I know how to do it if I type out the formula in each cell, but I need a shortcut. Here's an example:

Suppose the number 10 is in A1. I want A2 to be A1+10%, A3 to be A1+20%, A4 to be A1+30%, but like I said, I want to be able to easily paste the formula instead of retyping in each cell.

Thanks!

 

[mrshl9898]

How's this?

=$A1+$A1*(COLUMN()-1)/10

 

[gingertumi]

Thanks! Is there a way to make it work if the source number is in C1 instead of A1?

 

[mrshl9898]

Sure =$C1+$C1*(COLUMN()-3)/10