Thank you! You save me sooooo much time.

When I say A2 and B2=0 but C20, I just mean that C2 had sales that year but
in the previous years it didnt. So I'm looking at it from a sales point of
view.

Now, for any sales after C2,D2,and E2.... Meaning... F2:Z2... I'm looking to
see if it that product had any other sales during that year so I can call it
BASE. Does that help?




"Sandy Mann" wrote:

When you say:

If A2= 0, B2=0, but C20

do you mean that A2 would have an actual zero in it or that A2 would be
empty? And does:

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

mean that C2, D2 & E2 are dates?


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"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