Asked for the percent difference. If someone says, give me the percentage
difference from 8 to 10, I'll say 25%. Conversely, if someone says give me
the percentage difference from 10 to 8, I'll say 20%, not negative 20%.
Just my 2 cents.
--
John C
"Bernard Liengme" wrote:
Why have you used ABS?
Surely one needs to know if the change is an increase or a decrease?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"John C" <johnc@stateofdenial wrote in message
...
Percentage of what?
i.e.:
Suppose your two values are in A1, and A2
A3: =ABS(A1-A2)/A2
or
A3: =ABS(A1-A2)/A1
percent difference between two of 33658.60 ~ 33.25%
percent difference between two of 44850.00 ~ 24.95%
--
John C
"Dphel" wrote:
I have 2 dollar amounts, for example $44,850.00 and $33,658.60, I need
a
formula that will tell me what the precentage is for the difference
between
both amounts