IF Formula using multiple date factors

Good morning,

I'm having some trouble executing an IF formula that relies on a few different factors to determine if a project was completed by the due date or the adjusted due date, if applicable. See the attachment:

Each project is assigned a due date however the due date can be adjusted so in some cases a project may have data entered for both a due date and an adjusted due date. When the project is complete, the completion date is entered. I need the final column to result in a yes or no response if either of these due dates was met. If the project is not yet complete this would remain blank.

I attempted using an OR formula but am not yielding the results I had hoped for. In my example everything is coming back as Yes, however in my actual file I am receiving #Value errors on the cases that should be no using this same formula.

Thank you in advance!

Try

=IF(C2="","",IF(OR(C2<=A2,C2<=B2),"Yes","No"))

Thank you John - this worked great in my test file but I was trying to figure out why I wasn't yielding the same results in my real file. I examined it a bit further and tested a similar condition I was seeing on my test file. If someone enter NA for not applicable in Column B when there is NOT an adjusted due date it looks like this changes the "No" results to "Yes" - Any idea how I can adjust this formula to include that?

Try

=IF(C2="","",IF(AND(B2<>"",B2<>"NA",C2<=B2),"Yes",IF(C2<=A2,"yes","no")))

Or ...

=IF($C2="","",IF(AND(ISNUMBER($B2),$C2<=$B2),"Yes",IF($C2<=$A2,"yes","no")))

Thank you this worked great!