Nested If Statement

[matty_lou82]

I am looking for a nested IF statement that states in a cell "Expired" if the reference cell date is greater than today, AND if reference cell is either blank or contains a date prior to today, a blank value is returned.

So:

Reference Cell Date > Today - Returns "Expired"
Reference Cell Date = Blank - Returns "Blank"<strike></strike>
Reference Cell Date < Today - Returns "Blank"

I would really appreciate any help on this.

Thank you in advance,

 

[Joe4]

Welcome to the Board!

Let's say A1 is the reference cell. Then try:

=IF(A1>TODAY(),"Expired","Blank")

If you want an actual blank and not the word "BLANK", then use:

=IF(A1>TODAY(),"Expired","")

 

[matty_lou82]

Thank you so much for the warm welcome, this is very useful

Is there a way in whcih more than 2 variables can be returned? In this instance:

Reference Cell Date > Today - Returns "Not Expired"
Reference Cell Date = Blank - Returns "Blank"<strike></strike>
Reference Cell Date < Today - Returns "Expired"

Thank you

 

[Joe4]

Try a nested IF statement:

=IF(A1>TODAY(),"Not Expired",IF(A1 < TODAY(),"Expired","Blank"))

<today(),"expired","blank"))[ code]<="" html=""></today(),"expired","blank"))[>

 

[matty_lou82]

Try a nested IF statement:

=IF(A1>TODAY(),"Not Expired",IF(A1 < TODAY(),"Expired","Blank"))

<today(),"expired","blank"))[ code]<="" html=""></today(),"expired","blank"))[>

Thank you! Really useful!