negative and positive sums

Chad · Jul 25, 2007

How do I create a formula that subracts A1 from A2 if A2 is a negative
number, but adds A1 and A2 if A2 is a positive number?

Thanks for your help

bj · Jul 25, 2007

try
=if(A2<0,A2-A1,A2+A1)
or
=A2+if(A2<0,-A1,A1)
or
=A2+Sign(A2)*A1

Pete_UK · Jul 25, 2007

Try this:

=IF(A2<0,A2-A1,A2+A1)

Hope this helps.

Pete

Teethless mama · Jul 25, 2007

Try this:

=(ABS(A2)+A1)*SIGN(A2)

Chad · Jul 26, 2007

Thanks. This was a BIG help! my report wil lbe done on time.

Thanks again

Chad · Jul 26, 2007

Thanks. This was a BIG help! my report wil lbe done on time.

Thanks again

Chad · Jul 26, 2007

Thanks. This was a BIG help! my report wil lbe done on time.

Thanks again

Pete_UK · Jul 26, 2007

You're welcome - thanks for taking the trouble to feed back to us
individually.

Pete

Stan Brown · Jul 28, 2007

Wed, 25 Jul 2007 09:00:03 -0700 from Chad

How do I create a formula that subracts A1 from A2 if A2 is a negative
number, but adds A1 and A2 if A2 is a positive number?

If you mean what you said, it's
=A2+SIGN(A2)*A1

But I suspect you meant something different.