Free Lessons Courses Seminars TechHelp Fast Tips Templates Topic Index Forum ABCD

 Home   Courses   Seminars   Templates   TechHelp   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

 Glossary New Entries Added Almost Daily! Click here to get on our Mailing List
 Access    Excel    Word    Windows    HTML

# IIF

## Using the IIF Function

In this tutorial you will learn how to use the IIF Function.

The IIF function returns one of two parts depending on the outcome of an expression.

=IIF( Expression, TruePart, FalsePart )

Expression to evaluate
TruePart is the value to return if the expression is TRUE
FalsePart is the value to return if the expression is FALSE

In this example we will use Grades and if a particular score is achieved you will pass or fail.

If the Grade was "75" and the Expression checked for ">65" the result is TRUE.

FORM

In a Form you could set the Default Value of a Textbox to

```	=IIF(75>=65, True, False)
```
VBA

In a Form add a TEXTBOX control and rename it "txtIIF", then you could add the following in the Load Event.

```	Private Sub Form_Load()
txtIIF = IIF(75>=65, True, False)
End Sub
```

Courses Tips

See this FREE Tip on IIF and many others.

Search

You can find more about this by searching the website.

 Check out these other pages that may be of interest to you:
 5/31/2023 Calculator 7 5/30/2023 DoEvents 5/26/2023 Hide With Macro 5/25/2023 Calculator 6 5/24/2023 Object Size Analyzer 5/24/2023 Calculator 5 5/23/2023 Plural 5/22/2023 Calculator 4 5/19/2023 Calculator 3 5/18/2023 Calculator 2