more consice

=IF(COUNTIF(D7:D18,"fail"),"fail","pass")