IIf statment expiration date not excluding NULL

[wnicole]

Can you assist?
I have this IIF statement however all empty cells are also coming up as Expired.
How do I exclude empty cells?

Status: IIf([Expiration Date]>=Date(),"CURRENT","EXPIRED")

[JoeM]

You can use the NZ function to tell it what to use in the case of a Null. If you want it to come up as "CURRENT" instead in that situation, you could do it like:

Status: IIf(NZ([Expiration Date],Date())>=Date(),"CURRENT","EXPIRED")

[wnicole]

Got it...I think I would prefer it to say "NA" if no date is supplied or just leave blank.
How would I write that?

[JoeM]

Then you will need to nest IIF statements, as IIF statements can only return up to 2 options, not 3 ("CURRENT","EXPIRED","N/A").

Status: IIf(IsNull([Expiration Date]),"N/A",IIf([Expiration Date]>=Date(),"CURRENT","EXPIRED"))

[wnicole]

Perfect! Thanks so much!