If Statement Range

T

TONYC

The following if statement works fine on a single cell “AO5” -

=IF(AP5<>"","PASS","")

However, I want to be able to say that if there is any data in cell
AP5 to BL5, excluding the word 'FAIL', then enter 'PASS' in cel
“AO5”.

Ton
 
A

Alan

One Way,
=IF(COUNTA(AP5:BL5)=0,"",IF(COUNTIF(AP5:BL5,"Fail")>0,"Fail","Pass"))
Regards,
 
Top