I am trying to search a column for Multiple conditions using the iif function in order to determine result A or result B.
Ex. if Column "Role" is like "Mngr", or "VP", or "Head";
Print 'Manager',
`Otherwise 'Employee'
I am trying to search a column for Multiple conditions using the iif function in order to determine result A or result B.
Ex. if Column "Role" is like "Mngr", or "VP", or "Head";
Print 'Manager',
`Otherwise 'Employee'
Hi @AWill-6950,
Welcome to Microsoft Q&A forum and thanks for your query.
I believe CASE function is better suited for your requirement.

You can have a Case function expression as below to get the desired output:
case(
(upper(Title) == 'MNGR' || upper(Title)=='VP' || upper(Title) =='HEAD'), 'Manager',
'Employee'
)

Hope this helps. Do let us know if you have further query.
Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.
Hi @AWill-6950,
Just checking in to see if the above suggestion was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Hi @AWill-6950,
We still have not heard back from you. Just wanted to check if the above suggestion was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
4 people are following this question.