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