Issue with zero in a formula

Polly

New member
Joined
Apr 22, 2015
Messages
3
Reaction score
0
Points
0
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
 
Hi,
Try below formula:

=IF(B333=0,"",SUM(((D282*B332)*B333*B334)-B307))
 
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
 
Try:
=IF(B333=0,SUM(((D282*B332)*B334)-B307),SUM(((D282*B332)*B333*B334)-B307))
 
Works beautifully thank you for that.

Ta Polly
 
FYI the SUM function is unnecessary in your formula =IF(B333=0,((D282*B332*B334)-B307),((D282*B332*B333*B334)-B307))
 
Back
Top