Getting excel to ignore blank cells when using IF AND function

[Rachel541]

Hi

This is my function, but I need it not to calculate anything when one of the cells is blank (either E11 or G11). How would I do this please?

=IF((AND(E11<=50, G11="Proficient")), "Yes", "No")

Thanks!

 

[Joe4]

Welcome to the Board!

Try nesting IF statements, i.e.:

=IF(OR(E11="",G11=""),"",IF(AND(E11<=50, G11="Proficient"), "Yes", "No"))

 

[jmacleary]

Try this: - it will put a blank if either is blank: =IF(OR(ISBLANK(E11),ISBLANK(G11)),"",IF((AND(E11<=50, G11="Proficient")), "Yes", "No"))

 

[Rachel541]

Thanks both! Now have a working function!

 

[Rachel541]

Sorry, could you also help with this one please? Tried adapting the ones you'd posted before and I obviously did something wrong.

=IF((OR(G4="deficient", I4="Yes")), "Yes", "No")

 

[jmacleary]

OK This should do it: =IF(OR(ISBLANK(i4),ISBLANK(G4)),"",IF((OR(G4="deficient", I4="Yes")), "Yes", "No"))

 

[soul1974]

Morning,
Please can you assist, i have a formula that cannot get it not to show information in the blank cells.
=IF($E2>$F2;$L2-$G2+5;IF($E2<F2;"Recess Front";"Correct"))

 

[jtakw]

Hi,

As this thread is over 2 & half years old, you should open a new thread/post.
With limited description of your question, I'm guessing maybe this:

=IF(OR($E2="";$F2="");"";$E2>$F2;$L2-$G2+5;IF($E2<F2;"Recess Front";"Correct")))