| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Negative value to positive
This formula,
=SUMIF('Cost Plus Invoice'!O8:O1500,"p",'(Cost Plus Invoice'!T8:U1500) copys (to the cell it is written to) the sum of negative dollar amounts from another sheet. I need to add to this formula, a formula that changes the negative dollar amount total to a positive. I know that the abs function converts, but i'm not sure how to incorporate it into this formula. Please help. Thanks, Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtracting positive amts from negative and positive from positive | Excel Worksheet Functions | |||
| Positive and negative graph | Charts and Charting in Excel | |||
| Some Positive, Some Negative | Excel Worksheet Functions | |||
| IF positive/If negative???? | Excel Worksheet Functions | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
Threaded Mode
