calculating percentages

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

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

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?

"Louise" <Louise@discussions.microsoft.com> wrote in message
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

that's exactly what i need, thank you.

Louise

"Gary" wrote:

> 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?
>
> "Louise" <Louise@discussions.microsoft.com> wrote in message
> 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
>
>
>

that's exactly what i need, thank you.

Louise

"Gary" wrote:

> 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?
>
> "Louise" <Louise@discussions.microsoft.com> wrote in message
> 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
>
>
>

ur welcome

"Louise" <Louise@discussions.microsoft.com> wrote in message
news:B84546F0-8B1A-4254-ACAA-59B2CF4B24CE@microsoft.com...
> that's exactly what i need, thank you.
>
> Louise
>
> "Gary" wrote:
>
>> 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?
>>
>> "Louise" <Louise@discussions.microsoft.com> wrote in message
>> 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
>>
>>
>>

Since we're talking differences, why not use?

==ABS(A1-A2)/A1

Of course A1 shouldn't be 0

HTH
Glenn Rathke


"Louise" <Louise@discussions.microsoft.com> wrote in message
news:B84546F0-8B1A-4254-ACAA-59B2CF4B24CE@microsoft.com...
> that's exactly what i need, thank you.
>
> Louise
>
> "Gary" wrote:
>
>> 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?
>>
>> "Louise" <Louise@discussions.microsoft.com> wrote in message
>> 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
>>
>>
>>

"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