IF statement, using ISBLANK

[dasbear3]

I've attempted to come up with a formula for column AT that will produce "YES" in the cell if AR=AS (unless those cells are both blank) or "NO" if AR>AS

=IF(AR4=AS4, "YES","NO") works as long as those cells aren't blank. I would like cell AT4 to remain blank if there is no data in AR4 or AS4.

Thoughts? Any would be greatly appreciated!

 

[c_m_s_jr]

TRY:

=if(and(isblank(ar4),isblank(as4)),"',if(ar4=as4, "yes","no"))

 

[tony80]

Hi,

Try:

=IF(AND(NOT(ISBLANK(AR4)),AR4=AS4), "YES","NO")

 

[dasbear3]

GREAT, it worked! Thank you both so much for the immediate response!

 

[Aladin Akyurek]

Try...

=IF(COUNT(AR4:As4)=2,IF(AR4=AS4,"Yes","No"),"No")