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.

	A	B	C	D
1	Name	Vehicle Year	KMs	Meets Washout Criteria
3	Sue	2015	52,000
4	Bill
5	Mike	2007	340,000	Yes
6	Kim	2005	123,000	Yes
7	Tom

<tbody>
</tbody>

 

[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!