Can the iif statment have more than 2 outputs?

[jgomez]

I have the IIF statement you see below & it works fine but I'd like to go an extra step for those that are marked "EOM HIT". If it contains those two words I'd like for it to check the MATURITY_DATE field & if the maturity date is less than the last day of the previous month I would like for it to mark "EOM Matured"... I would like to have it done in the same field...

EOM FLAG: IIf([Past_due_date]<=DateSerial(Year(Date()),Month(Date()),0),"EOM HIT","")

[jgomez]

Got it... kept running test until BOOM!

Here is what I did...

EOM FLAG: IIf([Past_due_date]<=DateSerial(Year(Date()),Month(Date()),0),"" & (IIf([Maturity_date]<=DateSerial(Year(Date()),Month(Date()),0),"EOM Matured","EOM ACTIVE")))