View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BigR BigR is offline
external usenet poster
 
Posts: 1
Default If sign of sum is negative change to positive

I am using a formula that may produce positive or negative results. Once it
has produced the sum the sign is immaterial. I need the result to add as a
positive.
I need something that says if the sum is less than 0 change the result to
positive. How do I do that?