percentages
Thanks Sheeloo, That worked great.
"Sheeloo" wrote:
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)
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...
"tommy" wrote:
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.
|