IF 3 columns that match then

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

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

                   ),
     "Loyal Customer"
      )

I figured it out

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.