divide by zero

[Guest]

anything that is divide by zero will get #DIV/0!. how can I show the result
ias zero insted?

 

[PY & Associates]

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