If then statement covering multiple rows and columns

[davidhrrsn]

Good morning!

I am trying to write a If/Then formula which returns one of two statements based upon the input in an series of cells.

Example:

=IF(H29:K38="X","Fail","Pass")

If an "X" appears in H29 - K38, I was "Fail" to appear in a cell, if "X" does not appear I want "Pass" to appear.

Any thoughts?

Thanks!
Dave

 

[AlanY]

try

=IF(COUNTIF(H29:K38,"X")>0,"Pass","Fail")

 

[davidhrrsn]

Thank you VERY much, works perfectly!

 

[AlanY]

you're welcome