Formula Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
roxiemayfield said:
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!
Click to expand...

Perfect! Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel functions 0
SUMIF "value if false" not working 2
Merging cells and formats 8
formula Help 2
Baffeling IF statement 7
How to set the value to zero if it negative after the substract 5
Macro to get rid of #DIV/0! 2
Simple calculation where values change to letters? 3

Back
Top