How to remove #DIV/0!

[San Antonio Heat]

I have tried so many combinations of IFERROR, ISERROR and not having any luck. Please help.


In cell C11 contains the following formula..
=(C6/C8)/(8.91*C21)

Problem is I have a 0 in the cell C21.

Thanks kindly!

 

[philwojo]

Why not just use an IF statement, maybe this:

=If(c21=0,"",((C6/c8)/(8.91*C21)))

That will give you a blank, "", if c21 is zero, otherwise it will run your code. Feel free to replace the "" with whatever you want there.

 

[San Antonio Heat]

Perfect, thanks!

 

[San Antonio Heat]

Is it possible to do the same with the statement IF already is in the formula?

=IF(C24<0,0,C24/(2*C21*C8))

Again C21 being 0 is causing the #DIV/0! error

Would If and Then be the best formula?

 

[philwojo]

Just add in the same IF formula to the one you have I would do this:

=IF(C24<0,0,IF(C21=0,"",((C24/(2*C21*C8)))))

 

[San Antonio Heat]

Ah, I was missing the 4th )))) Thank you so much!

 

[philwojo]

No problem, glad to assist.