View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default If sign of sum is negative change to positive

Hi,

=ABS(yoursum)

Mike

"BigR" wrote:

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?