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

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

"Chad" wrote:

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

Try this:

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

Hope this helps.

Pete

On Jul 25, 5:00 pm, Chad wrote:
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

Try this:

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


"Chad" wrote:

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

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

Thanks again

"Teethless mama" wrote:

Try this:

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


"Chad" wrote:

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

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

Thanks again

"Pete_UK" wrote:

Try this:

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

Hope this helps.

Pete

On Jul 25, 5:00 pm, Chad wrote:
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

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

Thanks again

"bj" wrote:

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

"Chad" wrote:

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

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

Pete

On Jul 26, 9:18 am, Chad wrote:
Thanks. This was a BIG help! my report wil lbe done on time.

Thanks again



"Pete_UK" wrote:
Try this:

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

Hope this helps.

Pete

On Jul 25, 5:00 pm, Chad wrote:
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- Hide quoted text -

- Show quoted text -

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.

--
"The internet is famously powered by the twin engines of
bitterness and contempt." -- Nathan Rabin, /The Onion/
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/