Show % Difference between two numbers
in [General]
|
Prev: Excel 2003 - Freeze panes
Next: Excel and Quickbooks
From: Jana on 1 Feb 2006 11:44 I am trying to show the percentage difference between two numbers and also show the overage in red....Help!
From: DaveO on 1 Feb 2006 11:53 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!
From: Bernard Liengme on 1 Feb 2006 11:53 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" <Jana(a)discussions.microsoft.com> wrote in message news:D3BFF4CE-1449-4B40-9FB9-A74F32C9D71C(a)microsoft.com... >I am trying to show the percentage difference between two numbers and also > show the overage in red....Help!
From: Gary''s Student on 1 Feb 2006 12:00 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!
From: Jana on 1 Feb 2006 15:15
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! |