percentages
 

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.

percentages
 

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.

percentages
 

Why the multiplication by 100?

--


Regards,


Peo Sjoblom

"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
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.

percentages
 

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...

--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Peo Sjoblom" wrote:

Why the multiplication by 100?

--


Regards,


Peo Sjoblom

"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
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.

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.