| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Subtracting Negative Numbers
I've looked at other similar questions and responses (# VALUE), etc, and
tried the suggestions (N(C2)-N(D2), ABS, Text to columns, =C2-D2, and still get the #VALUE. Some of the numbers in C2 are negative, but even two positive numbers in C2 and D2 result in the # VALUE response. The cells are formatted as numbers. Any ideas? Carole O |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating growth with negative numbers | Excel Worksheet Functions | |||
| Why cant you show negative numbers in parentheses? | Excel Discussion (Misc queries) | |||
| Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) | |||
| Negative Numbers | Excel Discussion (Misc queries) | |||
| Formula to calculate only the negative numbers | Excel Worksheet Functions | |||
Threaded Mode
