Formula Result

J

JE McGimpsey

One way:

If your current formula is, for instance

=A1/B1

then use

=IF(B1=0,"",A1/B1)
 
D

David Billigmeier

Include an error check using ISERROR()

i.e.

=IF(ISERROR(A1),"There is an error","No Error")
 
J

JE McGimpsey

Note that ISERROR() will mask all other errors, not just #DIV/0 errors.
In general it's better to trap known conditions that might cause errors,
and let unexpected errors pass through.
 
J

JT

Dave:

Thanks but I'm still having trouble. Following is the formula I'm
using...can you show me how to include the ISERROR function? When I do it,
then input data in the e16..n16 range, I get the FALSE error.

=SUM(E16:N16)/O16

JT
 
J

JE McGimpsey

One way:

=IF(ISERROR(SUM(E16:N16)/O16),"",SUM(E16:N16)/O16)

Much more efficient, and won't mask other errors:

=IF(O16=0,"",SUM(E16:N16)/O16)
 
J

JT

JE:

Tried...but when data is entered in e16..n16, I get a blank cell when there
should be an numeric answer. If there is a way I could show you the
worksheet, you cpould better see what I mean.

JT
 
J

JE McGimpsey

The only way to get a blank is if O16 evaluates to 0, which would
include being empty/blank. What's in O16?
 
Top