| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative numbers
This is my second post. I hope to explain myself better, so I can find a solution. A B 10 Declining difference 4 6 =A1-A2 8 -2 =(B2-A3) I want to know the remaining positive number which is 4, not -2 If I begin with 10 and keep subtracting numbers, I want to end up with a non-negative number. Subtracting 10-4=6 Subtracting 6-8=-2, bit what I want is the number 4, the "remaining" amount. Thanks! -- krismtx ------------------------------------------------------------------------ krismtx's Profile: http://www.excelforum.com/member.php...o&userid=33462 View this thread: http://www.excelforum.com/showthread...hreadid=542334 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "find and replace" negative numbers | Excel Worksheet Functions | |||
| How do I replace negative numbers with zero in Excel. | Excel Worksheet Functions | |||
| convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
| Add sequences of positive then negative numbers | Excel Discussion (Misc queries) | |||
| How to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
Threaded Mode
