Skip to main content
Solved

IF Formula with two options for returning a given value

  • April 27, 2022
  • 2 replies
  • 25 views
G
Forum|alt.badge.img+2

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 “ :white_check_mark: 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”),“ :white_check_mark: Paid”)

Any help is greatly appreciated!

Best answer by Vivid-Squid

Hi @gretchen
I think I understand what you are asking for. Can you try this formula?

IF(
  OR(AND(FCIHSEP="Yes",Cohort="Fall 2021"),
  AND(FCIFEB="Yes",Cohort="Spring 2022")),"✅ Paid")

2 replies

V
Forum|alt.badge.img+16
  • Vivid-Squid
  • Inspiring
  • Answer
  • April 27, 2022

Hi @gretchen
I think I understand what you are asking for. Can you try this formula?

IF(
  OR(AND(FCIHSEP="Yes",Cohort="Fall 2021"),
  AND(FCIFEB="Yes",Cohort="Spring 2022")),"✅ Paid")

Kamille_Parks11
G
Forum|alt.badge.img+2
  • gretchen11
  • Author
  • New Participant
  • April 27, 2022

Hi @gretchen
I think I understand what you are asking for. Can you try this formula?

IF(
  OR(AND(FCIHSEP="Yes",Cohort="Fall 2021"),
  AND(FCIFEB="Yes",Cohort="Spring 2022")),"✅ Paid")


THANK YOU. I wish you could have seen my face when that actually worked. I know it was probably the simplest fix, but I was struggling. Thank you for your help!

Terms & ConditionsAccessibility statement