calculating percentages

"Louise" <Louise@discussions.microsoft.com> skrev i en meddelelse
news:004475F0-E180-40EE-B538-22E3C7878639@microsoft.com...
> 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%

--
Best regards
Leo Heuser

Followup to newsgroup only please.

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" wrote:

> "Louise" <Louise@discussions.microsoft.com> skrev i en meddelelse
> news:004475F0-E180-40EE-B538-22E3C7878639@microsoft.com...
> > 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%
>
> --
> Best regards
> Leo Heuser
>
> Followup to newsgroup only please.
>
>
>
>

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" wrote:

> "Louise" <Louise@discussions.microsoft.com> skrev i en meddelelse
> news:004475F0-E180-40EE-B538-22E3C7878639@microsoft.com...
> > 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%
>
> --
> Best regards
> Leo Heuser
>
> Followup to newsgroup only please.
>
>
>
>

"Louise" <Louise@discussions.microsoft.com> skrev i en meddelelse
news:93C06FB4-8DFF-4020-909E-5C82B0E6246C@microsoft.com...
> 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