IF statement with Yes or No

[kayskei]

(example data)

I've got the table above, I need a formula that checks columns B, C, and D, if there is a Yes in any of those columns the formula needs to return Active in column E, if there are no Yes' in any columns, it needs to return Inactive. So here, Staff 1, Staff 2 and Staff 3 should be Active since they have at least one Yes, and Staff 4 should be Inactive since there are no Yes' in any of the columns against them.

I've done a similar formula before but it worked by counting blanks, so obviously doesn't work here with the No's in the other cells.

Thank you!

 

[ranman256]

=IF(AND( B2="No", C2="No",D2="No"),"Inactive","Active")

 

[dreid1011]

Perhaps this:

=IF(COUNTIF(B2:D2,"Yes"),"Active","Inactive")