| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Getting the difference between a "negative" number and a positive
Hi All,
I'm trying to get the difference between two cells. Example A1=500 B1=9999850. Trying to subtract A1-B1. The numbers are from a new mechanical counter that starts at 9999850 then goes up to 0 then its positive from then on. Trying to get the result of 650 not -9999350. =ABS(A1-B1) dosen't do it. It's killing me since its only a one time occurrence but its on multiple cells. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate the difference between negative and positive values | Excel Worksheet Functions | |||
| How to Show "+" for positive and "-" for negative | Excel Worksheet Functions | |||
| Delete "CR" at the end of a number and make the # negative? | Excel Discussion (Misc queries) | |||
| exel"negative and positive days for creditors :formula | Excel Discussion (Misc queries) | |||
| macro for converting number stored as "text" (or preceeded with ') to "number" formatting | Excel Programming | |||
Threaded Mode
