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