I dont understand the last condition in which you want BASE.

for first 4...

=IF(AND(A2=0,B2=0,C20),"NEW",IF(AND(B2=0,C20,D2 0),"2NEW",IF(OR(AND(C20,D20,E20),AND(C20,D2=0, E20)),"3NEW","")))


"YEIDIN" wrote in message
...
Hi Guys,
I'm trying to create a formula that would give different outcomes to
determine if a product was new or not. I'm new to Excel, so I'm not sure
how
to go about it. Can anyone help me please?

This is what I'm 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