View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default negative and positive sums

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