Statement that returns pass, fail, "" [Closed]

Report
-
Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
-
Hello,

Wanting to test row of numbers to a certain number and return pass, fail, or blank.

=IF(AND(X7<=AH4,Y7<=AH4,Z7<=AH4,AA7<=AH4,AB7<=AH4,AC7<=AH4,AD7<=AH4,AE7<=AH4,AF7<=AH4),"pass","fail")

I want the row to return blank if any of the cells in the row are blank.

1 reply

Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
448
Hi Dooley,

Try this formula:
=IF(COUNTIF(X7:AF7,"")=9,"",IF(COUNTIF(X7:AF7,"<="&AH4)=9,"pass","fail"))


Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!