Excel Conditions on cell 1

[tyutghf]

Hi

I'm trying to update a column based on the info in another column of the same row.

Cell L contains lots of job titles

Cell M needs to be set based on the job titles

If L = “Contractor” set M to “Main Contractor”
If L = “Consultancy” OR “Agent” set M to “Consultancy”
If L = any other value set M to “Subcontractor”

Can someone help with the condition for col M please?

Thanks

 

[strongm]

=IF(L1="Contractor","Contractor",IF(OR(L1="Consultancy",L1="Agent"),"Consultancy","Subcontractor"))

 

[tyutghf]

Thank you so much, my brain wasn't working on the sub condition