Hi Guys,
Im trying to create a formula that would give different outcomes to
determine if a product was new or not. Im new to Excel, so Im not sure how
to go about it. Can anyone help me please?

This is what Im trying to figure out.
If A2= 0, B2=0, but C20 --- Give me NEW
If B2= 0, C20, and D20 --- Give me 2NEW
If C2 0, D20 and E20 --- Give me 3NEW
But if C2 0, D2= 0, E20 --- Give me 3NEW still

And if anything was sold OR not after those 3 years (C2,D2,E2)€¦ Give me BASE.

If you can solve this€¦ THANK YOU! In advance€¦lol..

Yeidin