Help on formule

I have a formula that works great, but I want to add an other thing. The actual formula is:

=IF(OR(C20="",K20=""),"",IF(AND(K20<>"",N20=""),IF(K20>=TODAY(),"CAPA IN TIME","CAPA OVERDUE"),IF(N20<=K20,"YES","NO")))

What I want is when I have the value N.A. in I20 that it returns me "Yes" if someting else is in I20 then ""

Thanks for ur help

Try

=IF(I20<>"N.A",IF(OR(C20="",K20=""),"",IF(AND(K20<>"",N20=""),IF(K20>=TODAY(),"CAPA IN TIME","CAPA OVERDUE"),IF(N20<=K20,"YES","NO"))),"Yes")

on assumption that IF i20 contains N.A then no other checking is done: if it is blank execute other IF statements.


You cannot have "Yes" or blank answer in the above formula as an IF only has two conditions so you cannot check C , K or N.

=IF(I20="N.A","Yes","")