| 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) | |||
Linear Mode
