I’m hitting a wall, but got at least halfway to the solution! I have two scenarios that I’d want to return a given statement.
Option A: Someone has a “Yes” in FCIHSEP and a “Fall 2021” in Cohort
Option B: Someone has a “Yes” in FCIFEB and a “Spring 2022” in Cohort
Either of those should meet the criteria to return the “ Paid” statement.
I got it to work for Option A, but I’m a bit stuck on how to build in Option B as an alternate way to satisfy the statement.
What I have so far:
IF(AND(FCIHSEP = “Yes”, Cohort = “Fall 2021”),“ Paid”)
Any help is greatly appreciated!