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.

Statement that returns pass, fail, ""
Fenix internet on bank statement - Guide
Xbox game pass - Guide
Pass fail formula in excel - Guide
An if statement nested within another if statement will produce how many possible results? - Guide
Excel if statement - Guide

1 response

Answer 1 / 1

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.

Similar discussions

Condition formatting on changing cell color based on another cel

Removing " false" value in "IF"

Similar discussions

Subscribe To Our Newsletter!