Help with formula and mutiple conditions

Hi All,


Need help with a formula for a cell that meets multiple condition.


B2 = Fail, if any cells between C4:C70 = fail and C2 = Vacant else B2 = C2


Thanks

Madison

Thank you Richard, that's working great.

Madison

Turns out I forgot one more criteria.

B2 = Fail, if any cells between C4:C70 = fail and C2 = Vacant else B2 = C2

and

B2 = PASS, if all cells between C4:C70 = PASS and C2 = Vacant else B2 = C2

Thanks,

Madison

anyone, much appreciated.

Assuming that C4:C70 is either "PASS" or "fail", try this:

=IF(C2="Vacant",IF(COUNTIF(C4:C70,"fail"),"Fail","PASS"),C2)

The others are Empty as in nothing there, No Access and Occupied. So if not Pass or Fail then occupied or no access.

I'm trying 63falcondude's formula now.

63falcondude's formula is working. Thanks to the both of you guys. Much appreciated. Madison.

Glad we could help.