One way:

Assuming your existing formula is


=A1/B1

then use

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

In article ,
DLZ217 wrote:

Can I use an IF function to ignore the #DIV/0 output when making a formula
and if so how and if not what could I use?