Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to do some calculate differences between results in columns
containing a mix of negative or postive numbers. I can't seem to write the formula to display the results that are expected. So far....I get the correct answer but all are postive results, and I can add the minus sign, but then get only negative results. When summing the answer columns results...then the difference is inflated. For example: (0.33)-(0.37)=0.04 and 12.28-9.72=(2.56) I would like the formula to take a negative number subtract another negative number and display the result as a positive AND the same formula to take a positive number and subtract another postive number and display the result as negative. Thanks for your help. -- Linda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formulas stop calculating | Excel Discussion (Misc queries) | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
Copying options: contents, results, formulas, etc. | New Users to Excel | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
displaying results and not formulas | Excel Worksheet Functions |