Problem with multiple IF statements

Donna Anderson

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!

Lindsay AR

@Donna Anderson Are you looking for something like this?

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

If not, are you looking for it to validate both with an AND?

Lindsay AR

@Donna Anderson Are you looking for something like this?

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

If not, are you looking for it to validate both with an AND?

Donna Anderson

That's exactly what I am looking for. Tried it and it worked. Thank you!