Subtracting an absolute value

[NOAAlw]

=IF(J186>0,(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]

Try ...

=IF(J186>0,(J186-ABS(J198)),(J128-ABS(J198)))

ABS =absolute value.

WKR,

JP

 

[NOAAlw]

Thank you so very much! You really saved my day!