View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NOAAlw NOAAlw is offline
external usenet poster
 
Posts: 2
Default 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?