negative and positive sums

[Guest]

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

 

[Guest]

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

 

[Pete_UK]

Try this:

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

Hope this helps.

Pete

 

[Guest]

Try this:

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

 

[Guest]

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

Thanks again

 

[Guest]

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

Thanks again

 

[Guest]

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

Thanks again

 

[Pete_UK]

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

Pete

 

[Stan Brown]

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.