If & Or Formula?

[Dmichaud61]

Greetings! I need a formula in column D, that reports Yes, if the Vehicle Year is older than 12 years, or KMs are greater than 333,333. And if Vehicle Year is "" then "". Thank you in advance.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Name[/TD]
[TD]Vehicle Year[/TD]
[TD]KMs[/TD]
[TD]Meets Washout Criteria[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Sue[/TD]
[TD]2015[/TD]
[TD]52,000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Bill[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Mike[/TD]
[TD]2007[/TD]
[TD]340,000[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Kim[/TD]
[TD]2005[/TD]
[TD]123,000[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Tom[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[njimack]

<year(today()),c2>=IF(IF(B2,OR(B2+12 < YEAR(TODAY()),C2 > 333333)),"Yes","")</year(today()),c2>

 

[jamescooper]

In cell D2:

=IF(AND(B2="",C2=""),"",IF(OR((YEAR(TODAY()))-B2>12,C2>333333),"Yes","No"))

 

[Dmichaud61]

Thank you njimack - formula worked perfectly!

 

[Dmichaud61]

Thank you jamescooper- formula worked perfectly!