#NUM error, what am i doing wrong?

[Montez659]

I can't seem to get this syntax correct to display 0 instead of #Num! Here is what I have:

=Nz(([txtComOverDays]+[txtIncomOverDays])/([txtComOverNum]+[txtIncomOverNum]),0)

And technically, if the left side of the equation = 0 then the right side will as well.

 

[Montez659]

Ok, I've tried again, and still can't get it.

=IIf((([txtComOverDays]+[txtIncomOverDays])/([txtComOverNum]+[txtIncomOverNum]))=0,0,(([txtComOverDays]+[txtIncomOverDays])/([txtComOverNum]+[txtIncomOverNum])))

 

[Montez659]

So, I am a moron. So what? What you got against that? Here is what finally worked!

=iif(([txtComOverDays]+[txtIncomOverDays])=0,0,([txtComOverDays]+[txtIncomOverDays])/([txtComOverNum]+[txtIncomOverNum]))

 

[SydneyGeek]

It can be frustrating.

But, quick comment: Nz converts null to zero. It doesn't handle errors like division by 0.
Another option is to use IsError. Generically:

Iif(IsError(SomeExpression),0,SomeExpression)

Denis