#Num! Error

[tim johnson]

I have a calculated textbox where I an getting #Num!
because the denominator is zero.

The equation in the textbox is ([Leads]/[Calls])*100.

If Calls is zero I get the #Num! displayed in the textbox.

I an trying to use an IIF statement but cannot get it to
work.


IIF(ISERR(([Leads]/[Calls])*100),"",([Leads]/[Calls])*100)

Can someone help

 

[Ken Snell]

Try this:

=IIf([Calls]=0, "", [Leads]/[Calls]*100)