Percent increase formula

[Guest]

I need to come up with a formula. I have a starting number, say in cell A1. I
need to then increase that number by 10% in B1, 20% in C1, 30% in D1, etc. Is
there a way to do this without entering a separate formula in each cell?

 

[Arvi Laanemets]

Hi

B1=$A1(1+COLUMN()-1)*0.1)
and copy to right

 

[Govind]

Hi,

You can use this formula in cell A2,A3 etc.

=$A$1*(100+(ROW()-1)*10)/100

Regards

Govind.

 

[Govind]

Hi,

Sorry.Use this,

=$A$1*(100+(COLUMN()-1)*10)/100

and copy it to B1,C1, D1 etc.

Regards

Govind.

 

[Arvi Laanemets]

Sorry!

B1=$A1(1+(COLUMN()-1)*0.1)