get #DIV/0!:divide by zero

[chiuinggum]

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)

"chiuinggum" <chiuinggum@discussions.microsoft.com> wrote in message
news:5243FC71-1DE0-4970-A389-23C770146E52@microsoft.com...
> anything that is divide by zero will get #DIV/0!. how can I show the
result
> ias zero insted?
>