calculating percentages

[Guest]

Hi all

I'm sure this will be an easy calculation for most of you...........

If I have two numbers, ie. 390 and 217, how can I calculate the difference
between the two figures as a percentage? (These two figures represent sales
in two months and I need to know the difference in percentage terms).

Thank you.
Louise

 

[Franz Verga]

Hi all

I'm sure this will be an easy calculation for most of you...........

If I have two numbers, ie. 390 and 217, how can I calculate the
difference between the two figures as a percentage? (These two
figures represent sales in two months and I need to know the
difference in percentage terms).

Thank you.
Louise

Hi Louise,

say you have 390 in A1 and 217 in B1, in C1 type:

=(B1-A1)/A1

press Enter, then format as percentage.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[Gary]

If i understood right...

A1 = 390
A2 = 217

to get the difference, enter the following formula.

==(A1-A2)/A1

Format cell as percentage.

this means that the sales this month are 46.36% less than last month.

Is this what you need?

 

[Leo Heuser]

Hi all

I'm sure this will be an easy calculation for most of you...........

If I have two numbers, ie. 390 and 217, how can I calculate the difference
between the two figures as a percentage? (These two figures represent
sales
in two months and I need to know the difference in percentage terms).

Thank you.
Louise

Hi Louise

It depends on, what you compare the difference to,
the first month or the second month.

Month A: 390
Month B: 217

Always first find the difference: 390-217=173

Now, If A is 173 larger than B, then B is 173 smaller
then A, because the figure is an absolute value,
but the same is not true for fractions (and % is
hundredths). If C for instance is 20% larger than
F, then it doesn't follow that F is 20% smaller than C.

Here the difference is compared to B.
How many % is A larger than B: (173/217)*100 = 79.7%

and here the difference is compared to A.
How many % is B smaller than A: (173/390)*100 = 44.4%

 

[Guest]

that's exactly what i need, thank you.

Louise

If i understood right...

A1 = 390
A2 = 217

to get the difference, enter the following formula.

==(A1-A2)/A1

Format cell as percentage.

this means that the sales this month are 46.36% less than last month.

Is this what you need?

 

[Guest]

Thank you for your reply, wow, this way sounds pretty complicated.....

It will be easier for me to use the answer in the previous posts.

Thanks again.
Louise

 

[Leo Heuser]

Thank you for your reply, wow, this way sounds pretty complicated.....

It will be easier for me to use the answer in the previous posts.

Thanks again.
Louise

You're welcome.
I tried to explain the mechanics of how to get a number
in percent of another number so you didn't have to
ask the next time you had a similar problem. Obviously
I didn't succeed ;-)

Leo Heuser

 

[Gary]

ur welcome

that's exactly what i need, thank you.

Louise

 

[Glenn Rathke \(Soft Design Consulting\)]

Since we're talking differences, why not use?

==ABS(A1-A2)/A1

Of course A1 shouldn't be 0

HTH
Glenn Rathke