Problem with multiple IF statements

I have 2 columns: one is the responsible party for the row and one is a checkbox that needs to be checked depending on the value in the responsible party column.

I have this and it works:

=IF(HAS([Responsible Party]@row, "Analyst"), 1, 0)


But I need to check for 2 values, so I tried this, and it doesn't work:

=IF(HAS([Responsible Party]@row, "Analyst"), 1, 0, IF(HAS([Responsible Party]@row, "Lead Analyst"), 1, 0))

I get: #incorrect argument set


Does anyone see the problem? Thanks!

Best Answer

Answers