# Thread: Issue with zero in a formula

1. ## Issue with zero in a formula

I have a formula listed below that occasionally comes up with a zero number in b333 cell:

=SUM(((D282*B332)*B333*B334)-B307)

When it does come up I want to have the formula ignore it and move to the next calculation. How can I do this ?

Ta Polly  Reply With Quote

2. Hi,
Try below formula:

=IF(B333=0,"",SUM(((D282*B332)*B333*B334)-B307))  Reply With Quote

3. Originally Posted by sambit Hi,
Try below formula:

=IF(B333=0,"",SUM(((D282*B332)*B333*B334)-B307))
Thanks for that but now I don't get an answer when there is a zero in b333. What I need is for that calculation *b333 to be ignored if it has a zero in it and move to the next calculation *b334.

Example:

(d282) * (b332) * b333 * b334 - b307
100 * 0.71 * 0 IGNORE * 0.26 - 4 = 12.46 SHOULD BE THE ANSWER

Ta Darren  Reply With Quote

4. Try:
=IF(B333=0,SUM(((D282*B332)*B334)-B307),SUM(((D282*B332)*B333*B334)-B307))  Reply With Quote

5. Works beautifully thank you for that.

Ta Polly  Reply With Quote

6. FYI the SUM function is unnecessary in your formula =IF(B333=0,((D282*B332*B334)-B307),((D282*B332*B333*B334)-B307))  Reply With Quote

7. It's what I was looking for  Originally Posted by Pecoflyer FYI the SUM function is unnecessary in your formula =IF(B333=0,((D282*B332*B334)-B307),((D282*B332*B333*B334)-B307))  Reply With Quote

excel 2010, formulas, spreadsheet 