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
Bookmarks