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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting an absolute value
Try ...
=IF(J1860,(J186-ABS(J198)),(J128-ABS(J198))) ABS =absolute value. WKR, JP "NOAAlw" wrote in message ... =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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting an absolute value
Thank you so very much! You really saved my day!
"JP Ronse" wrote: Try ... =IF(J1860,(J186-ABS(J198)),(J128-ABS(J198))) ABS =absolute value. WKR, JP "NOAAlw" wrote in message ... =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? |
Reply |
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) |