How can I prevent a #DIV/0! result from displaying in a cell?

Jack Taylor

One way:

If your current formula is, for instance

=A1/B1

then use

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

In article ,
"JT" wrote:

How can I prevent a #DIV/0! result from displaying in a cell?

Jack Taylor

Include an error check using ISERROR()

i.e.

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


--
Regards,
Dave


"JT" wrote:

How can I prevent a #DIV/0! result from displaying in a cell?

Jack Taylor

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.

In article ,
"David Billigmeier"
wrote:

Include an error check using ISERROR()

i.e.

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

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

"David Billigmeier" wrote:

Include an error check using ISERROR()

i.e.

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


--
Regards,
Dave


"JT" wrote:

How can I prevent a #DIV/0! result from displaying in a cell?

Jack Taylor

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)

In article ,
"JT" wrote:

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

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

"JE McGimpsey" wrote:

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)

In article ,
"JT" wrote:

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

Hi

Then it sounds like you have nothing entered in O16.

Regards

Roger Govier



JT wrote:

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

"JE McGimpsey" wrote:



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)

In article ,
"JT" wrote:



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

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


In article ,
"JT" wrote:

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.