Prev: Comments
Next: how do I dropdown list
From: BigR on 12 Jan 2010 14:16
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?
From: Mike H on 12 Jan 2010 14:20
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?
 | 
Pages: 1
Prev: Comments
Next: how do I dropdown list