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