IF/OR/CONTAINS

chrishallo_Charter

Hello! I need some help with a formula that is currently yielding #INCORRECT ARGUMENT SET.

The current formula in B2 is to check the box if the Sprint column contains Flux Staging Area, STAGING AREA, STAR BLAZERS INTAKE, Bulk Status or Parking Lot. What I have entered now is

=IF(OR(CONTAINS("Flux Staging Area", Sprint@row, CONTAINS("STAGING AREA", Sprint@row, CONTAINS("STAR BLAZERS INTAKE", Sprint@row, CONTAINS("Bulk Status", Sprint@row, CONTAINS("Parking Lot", 1)))))))

I'm thinking my parentheses are off but not sure where...thanks for the help!

Dan W

This is a little longer without the OR but works

=IF(CONTAINS("Flux Staging", Sprint@row), 1, IF(CONTAINS("Staging Area", Sprint@row), 1, IF(CONTAINS("Star Blazers Intake", Sprint@row), 1, IF(CONTAINS("Bulk Status", Sprint@row), 1, IF(CONTAINS("Parking Lot", Sprint@row), 1, 0)))))

chrishallo_Charter

Thanks, @Dan W.

Dan W

This is a little longer without the OR but works

=IF(CONTAINS("Flux Staging", Sprint@row), 1, IF(CONTAINS("Staging Area", Sprint@row), 1, IF(CONTAINS("Star Blazers Intake", Sprint@row), 1, IF(CONTAINS("Bulk Status", Sprint@row), 1, IF(CONTAINS("Parking Lot", Sprint@row), 1, 0)))))

chrishallo_Charter

Thanks, @Dan W.