Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need a formula that will subtract positive numbers from negative numbers
"and" negative numbers from positive, with the answer in the correct form, ie; positive or negative. All numbers refer to either a gain or loss in quantity Row 1 values are taken from one source Row 2 values are taken from another source I need a formula for row 3 to give me the total gain or loss represented in each column. Example A B 1 (20.5) 17 Row 1 2 1.5 (2) Minus Row 2 3 (19) 15 Equal Row 3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Some Positive, Some Negative | Excel Worksheet Functions | |||
How to add all positive and negative numbers? | Excel Worksheet Functions | |||
IF positive/If negative???? | Excel Worksheet Functions | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
Convert positive # to negative | Excel Discussion (Misc queries) |