Dividing by zero

[Jacques]

Hello all,
I have a text box that shows percentages from the value of two other
text boxes, but when they both say zero (0.00) I get an error. I assume its
because you can't divide by zero, so how do I make it show 0.00% instead of
#Num!. When there are values other than zero it works fine.

Thanks beforehand,

 

[Jacques]

Nevermind.
I found the answer.

It was
=IIf([Divisor]=0,"",[Dividend]/[Divisor])
I found it
http://office.microsoft.com/en-us/assistance/HA010550731033.aspx