Multiple IIf statement needs

[Nomi123]

I need and IIf statement for this:

If [major] is CS and [minimum gpa] is >3.999 and [citizen] is Yes and [Permanent Resident] is yes and [F1 Visa] is yes and [Graduate Students] is Yes then Monsanto.

Can you help me?

 

[pr2-eugin]

Nomi123, is this the only condition you will check? Or is there some more conditions? If that is the case, I would suggest you create tblCodeOutcome with CODES and their Outcomes.. Then based on their Ticks you can 'generate' the Outcome..

Because as the need increases your code will get bigger and bigger.. So will the complexity of debugging if any error occurs..

 

[bob fitz]

Bit of a guess but you could try:
Iif([major] = "CS" AND [minimum gpa] >3.999 AND [citizen] = True AND [Permanent Resident] = True AND [F1 Visa] = True AND [Graduate Students] = True,"Monsanto","")