How to add ISBLANK argument to an existing IF(AND) formula

[Clouded]

Hi Guys
Have tried numerous suggestions online and YouTube to get this to work but no joy trying to use IF(ISBLANK etc.

I have a worksheet where cell I17 ( down to cell I47) contains an IF(AND(..... formula that returns Pass or Fail depending on the values that are entered into cells C17, E17 And G17:

=IF(AND(C17>=$E$13,C17<=$H$13,E17>=$E$14,E17<=$H$14,G17="no"),"Pass","Fail")

This works fine and returns Pass or Fail as I want. As per the formula though, cell I17 - I47 display Fail when the three reference sells it refers to are empty. I would like to amend the formula so cells I17 to I47 remain empty until values are actually entered into their corresponding three reference cells.

Thank you in advance for any help you can provide.

Cheers

 

[Michael M]

Maybe this way

=IF(OR(C17="",E17="",G17=""),"",IF(AND(C17>=$E$13,C17<=$H$13,E17>=$E$14,E17<=$H$14,G17="no"),"Pass","Fail"))

 

[Clouded]

Maybe this way

=IF(OR(C17="",E17="",G17=""),"",IF(AND(C17>=$E$13,C17<=$H$13,E17>=$E$14,E17<=$H$14,G17="no"),"Pass","Fail"))

Hi Michael
Fantastic thank you very much works a treat.

Cheers
Brett

 

[Michael M]

Glad to help