IF THEN with math

[soglejr]

After completing a calculation it is possible that the answer will be a negative. I need some method of essentially flipping the sign and I was thinking of multiplication by -1.

The first thing that came to mind was IF THEN ELSE, but I do not know how to basically do "IF Value <0 THEN (Cell Value *-1) ELSE Leave it alone"

Is this possible or do I need to bark up another tree?

Thanks for the assist.

[Dennis7849]

It sounds like you want the absolute value. The worksheet function is =ABS(A1) where cell A1 has either a positive or negative value.

[soglejr]

I completely forgot about ABS()

Here is the Formula is it stands currently =IF(G36=0,0,IF((G36-H36)+K36<0,0,(G36-H36)+K36)) and it resides in I36.

Can the ABS used here in place of the first 0 after the <0

[Paul]

Hi Soglejr, you should be able to use:

=IF(G36=0,0,IF(G36-H36+K36<0,0,ABS(G36-H36+K36)))

You shouldn't need to specify (G36-H36)+K36, since by order of operations they will be calculated from left-to-right anyway.