ExcelBanter - Subtracting an absolute value

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Subtracting an absolute value (https://www.excelbanter.com/excel-worksheet-functions/240798-subtracting-absolute-value.html)

NOAAlw

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?

JP Ronse

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?

NOAAlw

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?

All times are GMT +1. The time now is 09:41 PM.