Help

IF 3 columns that match then

Topic Labels: Formulas
Solved
Jump to Solution
640 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Club_Agency
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
Club_Agency
4 - Data Explorer
4 - Data Explorer

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

                   ),
     "Loyal Customer"
      )

I figured it out

See Solution in Thread

1 Reply 1
Club_Agency
4 - Data Explorer
4 - Data Explorer

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

                   ),
     "Loyal Customer"
      )

I figured it out