Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting an absolute value
=IF(J1860,(J186-J198),(J128-J198))
How can I change this formula to make J198 an absolute value. Because if J198 is negative, it adds the number and I want it to always subtract. Can someone please advise me on how to make that happen? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Absolute cell reference will not remain absolute. | Excel Worksheet Functions | |||
Subtracting A from B | Excel Discussion (Misc queries) | |||
Subtracting | Excel Discussion (Misc queries) | |||
Subtracting | Charts and Charting in Excel | |||
Subtracting | Excel Discussion (Misc queries) |