| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtraction of negative numbers
I'm trying to create an equation that, on occation, will result in a
subtraction of a negative, which then results in a larger negative number than it should be. So for example: =sum(A1 - B1) A1 = -50 B1 = 40 so the results of this equation is -90, but in reality it should be -10. seems simple but it's confusing the hell out of me. thanks in advance for the help. roger |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entering dates results in subtraction of numbers | Excel Worksheet Functions | |||
| Date subtraction -How to not show negative when 2nd date not entered | New Users to Excel | |||
| I want to get negative hours if subtraction of hours is negative | Excel Worksheet Functions | |||
| Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
| subtraction in a list of numbers that resets with a label. | Excel Worksheet Functions | |||
Threaded Mode
