Multiple conditional formulas using multiple columns

[mlim0806]

Hi Community, 

I am trying to create a new column labeled "Class" using multiple formulas from different columns. There are 4 levels of Class (0,1,2,& 3). Depending on the value in the position, criticality and staff ID field, this will populate the level. Level 2 is the only formula that will include IS NOT EQUAL. I am getting an error and I think it may be the "else" expression or possibly the order?

Logic on Levels:

IF [Position]="Chairman" or "Deputy Chairman" and [Criticality]= "Critical" then "Level 0"

IF [Position]="Vice Chair" or "National Partner" and [Criticality]= "Critical" then "Level 1

IF [Staff ID]= "24098" or "16000" then "Level 1"

IF [Position]!="Vice Chair" or "National Partner" or "Chairman" or "Deputy Chairman" and [Criticality]= "Critical" then "Level 2"

IF [Criticality]="Other" then "Level 3"

[binuacs · Accepted solution]

@mlim0806 The IF Else statement was not correct

[mlim0806]

Thank you for the quick response! It worked! I had another formula further in the workflow that needed Staff ID to be a string, but I was able to use the select tool to just change it back.