View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roxiemayfield roxiemayfield is offline
external usenet poster
 
Posts: 21
Default Formula Question

I have the following formula:

=--(SUM(A1-B1+C1)=IF(A1<=0,))

I want the sum to be the first part of the formula if A1 is not zero. If A1
is zero I want D1 to be zero.

Thank you!