IF Formula

[kumara_faith]

Hi,

I am trying to add another criteria to the following formula to state that if J6 is blank, then return blank.

All existing criteria should remain but to add if J6 is blank, then return blank.

=IF(OR(J6>TODAY(),J6=""),"No","Yes")


Appreciate help.

 

[Andrew Poulsom]

Is it?

=IF(J6="","",IF(J6>TODAY(),"No","Yes"))

 

[kumara_faith]

Andrew,

Thank you for your time and patience. That worked.

Thank you again!