percentages

[tommy]

Hi, can any one help what I Would like to do is, in column A1 to A10 I put in
a series of numbers each bigger than the next, in column B2-B10 I need a
calculation that tells me what percentage A2 is greater than A1 and then What
percentage A3 is greater than A1 and so on, the in C1 I would put in a number
and in C2 a number that is greater than C1 by the percentage in B2 and so on.
I hope this makes sense.

Thanks in advance. Tommy.

 

[Sheeloo]

Enter this in B2 and copy down till B10
=(B2-B$1)/B$1*100

Enter this in C2 and copy down
=C1*(1+B2/100)

 

[Peo Sjoblom]

Why the multiplication by 100?

--


Regards,


Peo Sjoblom

 

[Sheeloo]

To convert into percentage. One can do that by clicking on % too...

Increase from 1 to 1.5 is 0.5 or 50%...
I hope I am making sense...

 

[tommy]

Thanks Sheeloo, That worked great.

Enter this in B2 and copy down till B10
=(B2-B$1)/B$1*100

Enter this in C2 and copy down
=C1*(1+B2/100)