Good afternoon,
Here is an easy on for you...I think. I have been trying to lose the #num! error I recieve when something is divided by a 0. I just can't seem to get it right, I have an excel formula that works beautifully and I tried it in there but that didn't work either.
Below is what I have now and I still get the #NUM! error. Basically if it isn't divisible then I want to show a "0", there or leave it blank.
=IIf(([EyeDeferredpay]/[EyeDeferred])<1,"",([EyeDeferredpay]/[EyeDeferred]))
Can any one help?
Larry
Here is an easy on for you...I think. I have been trying to lose the #num! error I recieve when something is divided by a 0. I just can't seem to get it right, I have an excel formula that works beautifully and I tried it in there but that didn't work either.
Below is what I have now and I still get the #NUM! error. Basically if it isn't divisible then I want to show a "0", there or leave it blank.
=IIf(([EyeDeferredpay]/[EyeDeferred])<1,"",([EyeDeferredpay]/[EyeDeferred]))
Can any one help?
Larry