I am trying to show the percentage difference between two numbers and also
show the overage in red....Help!

Assuming cell A1 has your 1st value and B1 your 2nd.

Cell C1 should be =A1/B1

Then format that cell to be a % and it'll work.

For the average of the 2 number cell D1 should be =(A1+B1)/2

Then fomat font to br red.

HTH.

"Jana" wrote:

I am trying to show the percentage difference between two numbers and also
show the overage in red....Help!

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!

If the first value is in A1 and the second is in B1 then =(B1-A1)/A1
(formatted as a %) is the percent difference.

A positive value will mean a percent increase and a negative value will be a
percent decrease
--
Gary''s Student


"Jana" wrote:

I am trying to show the percentage difference between two numbers and also
show the overage in red....Help!

Thank you soooo much.

One more question though, the formula works unless 1 of the numbers is 0,
then I get a "#DIV/0!" in the cell.

"Gary''s Student" wrote:

If the first value is in A1 and the second is in B1 then =(B1-A1)/A1
(formatted as a %) is the percent difference.

A positive value will mean a percent increase and a negative value will be a
percent decrease
--
Gary''s Student


"Jana" wrote:

I am trying to show the percentage difference between two numbers and also
show the overage in red....Help!

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!

=IF(A1<0,(B1-A1)/A1,NA())


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jana" wrote in message
...
Thank you soooo much.

One more question though, the formula works unless 1 of the numbers is 0,
then I get a "#DIV/0!" in the cell.

"Gary''s Student" wrote:

If the first value is in A1 and the second is in B1 then =(B1-A1)/A1
(formatted as a %) is the percent difference.

A positive value will mean a percent increase and a negative value will
be a
percent decrease
--
Gary''s Student


"Jana" wrote:

I am trying to show the percentage difference between two numbers and
also
show the overage in red....Help!

Jana

I have to do this also...here's what I do....

I usually hilight one cell, then on the tool bar select Format, Conditional
Formatting, for Condition 1 select "Cell Value is" from the dropdown list,
select "less than", enter 1. Click on Format, in the color selection, select
red.

Then I copy the cell, hilight all cells that applies and paste format.

Hope this helps.


"Jana" wrote:

I am trying to show the percentage difference between two numbers and also
show the overage in red....Help!

ur msg is true. however, using that formula, which i am, shows negative
percents as positives and vice versa. i need to know how to get them to show
properly and cannot find anything.

"DaveO" wrote:

Assuming cell A1 has your 1st value and B1 your 2nd.

Cell C1 should be =A1/B1

Then format that cell to be a % and it'll work.

For the average of the 2 number cell D1 should be =(A1+B1)/2

Then fomat font to br red.

HTH.

"Jana" wrote:

I am trying to show the percentage difference between two numbers and also
show the overage in red....Help!

On Apr 29, 5:08 am, mellaur wrote:
ur msg is true. however, using that formula, which i am, shows negative
percents as positives and vice versa. i need to know how to get them to show
properly and cannot find anything.

If the two numbers are in A1 and B1, and you are currently computing
A1/B1 - 1 and you feel the results are wrong, try B1/A1 - 1.

Note: You might be computing (A1-B1)/B1 instead of A1/B1 - 1. They
are equivalent. Likewise, (B1-A1)/A1 is equivalent to B1/A1 - 1.

Both formulas are equally "proper". It all depends on your point of
view. The first formula (A1/B1 - 1) tells you the percentage change
from B1 to A1. The second formula (B1/A1 - 1) tells you the
percentage change from A1 to B1.