Using IFF function in textboxes

T

tsison7

I want to evaluate an equation based on (2) existing variables on a form and
to avoid a division by zero error I was hoping to use the Iff function in the
textbox.

I tried using the IFF function in a textbox as follows Iff(den<>0, num/den,
0) but I take it that function doesn't work in a textbox. Any suggestions on
how to accomplish this by other means?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IFF Function 2
Iff Function 2
IIF statement 1
re Iff function 5
IIF Statement to return multiple values for a field - JohnW 3
Why am I getting the #Name error? 2
iff function in ms access 10
How to fix formula to avoid divide/zero and aggregate issue. 5

Top