IF statements for three different criteria including a blank

[Rebecca_Shore]

I am having a hard time with the IF statement. I have a Status category I would like to make student status change based on Anticipated graduation date, however, I don’t have that for all students. So this is the formula I am trying and failing at:

IF(
{Anticipated Graduation Date} <= TODAY(), “Graduated”,
IF({Anticipated Graduation Date} > TODAY(),
"Active Student”,
“Unknown”
)

I’ve done a couple variations and can’t seem to do it. Any thoughts out there??

Thank you,
R

[kuovonne · Accepted solution]

You have to first test if there is an {Anticipated Graduation Date} before you make the other checks. You also have to use date/time functions for comparing dates.

• Active Student: the {Anticipated Graduation Date} is after today
• Graduated: the {Anticipated Graduation Date} is today or earlier
• Unknown: any other situation

IF(
  {Anticipated Graduation Date},
  IF(
    IS_AFTER({Anticipated Graduation Date}, TODAY()),
    "Active Student",
    "Graduated"
  ),
  "Unknown"
)

---

If this answers your question, please mark this post as the solution. Otherwise, could you please give a bit more details and a screen capture?

[Rebecca_Shore]

kuovonne:

IF(
  {Anticipated Graduation Date},
  IF(
    IS_AFTER({Anticipated Graduation Date}, TODAY()),
    "Active Student",
    "Graduated"
  ),
  "Unknown"
)

Thank you so much! This definitely worked! I’m just getting used to doing this.

Best,
R