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?