| 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. |
| 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) | |||
Threaded Mode
