Thread: negative and positive sums
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default negative and positive sums
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
Reply With QuoteReply With Quote