| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I show the difference (+ or -) between two cells in Excel
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I show the difference (+ or -) between two cells in Excel
=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 "Revelp" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I show the difference (+ or -) between two cells in Excel
=A2-B2
"Revelp" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I show the difference (+ or -) between two cells in Excel
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 "Revelp" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show time difference | New Users to Excel | |||
| Show % Difference between two numbers | Excel Discussion (Misc queries) | |||
| how do i format cells in excel to show difference in payment amt | Excel Discussion (Misc queries) | |||
| calculating difference, but if condition not met show value given | Excel Worksheet Functions | |||
| what is the formula to show the difference between two dates | Excel Discussion (Misc queries) | |||
Linear Mode
