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 - 07 Jan 2005 17:38 GMT
Nevermind.
I found the answer.
It was
=IIf([Divisor]=0,"",[Dividend]/[Divisor])
I found it
http://office.microsoft.com/en-us/assistance/HA010550731033.aspx
> Hello all,
> I have a text box that shows percentages from the value of two other
[quoted text clipped - 3 lines]
>
> Thanks beforehand,