IF 3 columns that match then

[Club_Agency]

Hey All

I am stumped and have not been able to find a solution. Any help would be much appreciated.

Problem:

• I have 3 columns that match “Champion”

• I have a 4th column I want to print “Champion” but only if all three columns match Champion

I have tried

SWITCH({R segement} & {F segement} & {M segement copy}, “Champion”, “Champion”)

but is not working

Thanks

[Club_Agency · Accepted solution]

IF(
AND(
R > 1,
F > 2,
M > 2

                   ),
     "Loyal Customer"
      )

I figured it out