How can 1 cell turn Yes or No if multiple cells contain a certain value

Viewed 22

I have a list of season passes for people. I need a quick way to know if someone's pass is expired. In 1 row, I have person's name, email, type of pass, the year purchased and the renewal year. EX: cell G3 = 2021, cell G4 = 2022, cell G5 (I want to populate Yes or No for expired). Current year is 2021 so if G3 or G4 = 2021, then G5 should populate Yes (for expired). I have been searching for this answer for quite some time and cannot seem to find it. I'm hoping someone may know how I can do this.

0 Answers
Related