|
Posted to microsoft.public.excel.misc
|
|
|
Show % Difference between two numbers
Yes Positive or Negative
"Bernard Liengme" wrote:
Numbers in A1 and B1
percentage difference =(B1-A1)/A1 or B1/A1 - 1
This is the change in B relative to A; for the change in A relative to B
just use (A1-B1)/B1
Percentage means different thing to different folks!
define 'overage'; do you mean the difference is positive or negative?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Jana" wrote in message
...
I am trying to show the percentage difference between two numbers and also
show the overage in red....Help!
|