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