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

IIF statement 1
IIf statement in Query 3
Use TODAY() function as the criteria in a SUMIF formula 1
UDF Function Not working 5
List boxes, functions and query criteria 9
Clearing a textbox after Cancelling 8
Use Textbox to Populate Find CTRL-F 0
Dir() function does not work in a textbox 1

Top