negative and positive sums
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 -
|