iif function

[yanliang]

I need to create a query for certified employees.
the certified field is called "certified?" and is Yes/No
If an employee is certified I need to input "Eligible for Bonus" if not "Enroll in Summer MG Class"

I inserted in a function
iif([Certified?]="Yes","Eligible for Bonus", iif([Certified?]="No", "Enroll in Summer MG Class"))
but when I run the field it keep showing up #error.
I don't know why.

 

[arnelgp]

only test for 1 condition.
Yes/No field can either be True or False (Yes or No).

iif([Certified?], "Eligible for Bonus", "Enroll in Summer MG Class") As Remarks

 

[yanliang]

thankyou so much

 

[arnelgp]

you're welcome!