How can I show the difference (+ or -) between two cells in Excel

  • Thread starter Thread starter Revelp
  • Start date Start date
R

Revelp

I need to show the difference either plus or minus between two cells..i.e...
Col.1 is 10.00, Col.2 is 20.00, Col.3 needs to say that Col.2 is 10.00 over
what Co.1 is...Col.1 is the alloted budget number, Col.2 is the amount
actually spent, Col.3 needs to show the amount either over (+) or under (-)
Col.1's number.
thanks.
 
=IF(Count(A2:B2)=2,A2-B2,"")

you can select custom format and use

0.00 "Over";0.00 "Under"

or

+ 0.00;- 0.00


--


Regards,


Peo Sjoblom
 
If you are looking to do this with a formula (rather than Peo's suggested
cell formatting, which I think is the better approach), you could use
something like this...

=CHOOSE(SIGN(A1-B1)+2,ABS(A1-B1)&" Over","Right on budget!",ABS(A1-B1)&"
Under")

or this (depending on what you want to display if they are equal)...

=ABS(A1-B1)&CHOOSE(SIGN(A1-B1)+2," Over",""," Under")

Rick
 
Back
Top