percentage difference

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cimarron trucking - 07 Dec 2004 23:35 GMT

What function can I use/make to figure the difference in percentage between 2
monetary amounts?

Reply to this Message

Harald Staff - 07 Dec 2004 23:44 GMT

Hi

40 in A1. 80 in B1. In C1 formula
=A1/B1
format as percent numberformat and you may discover that 40 is 50% of 80.

HTH. Best wishes Harald

> What function can I use/make to figure the difference in percentage between 2
> monetary amounts?

Reply to this Message

Bernard Liengme - 08 Dec 2004 13:33 GMT

I think OP wants the <difference>:
=(B1-A1)/A1 or =B1/A1 - 1
format as percentage

Signature

Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address

> Hi
>
[quoted text clipped - 7 lines]
> between 2
>> monetary amounts?

Reply to this Message

John Mansfield - 08 Dec 2004 19:17 GMT

I would use the formula

=(B1-A1)/abs(A1)

where the data in B1 is new and the data in A1 is what you want to compare
to. The reference to the absolute value in the denominator insures that the
percent change signs are correct if and when a negative number were to occur.

> I think OP wants the <difference>:
> =(B1-A1)/A1 or =B1/A1 - 1
[quoted text clipped - 11 lines]
> > between 2
> >> monetary amounts?

Reply to this Message