Statement that returns pass, fail, ""

Closed
dooley - Jan 26, 2017 at 10:07 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 26, 2017 at 10:57 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Updated by TrowaD on 26/01/17 at 11:15 AM
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.