Y
YEIDIN
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 C2>0 --- Give me NEW
If B2= 0, C2>0, and D2>0 --- Give me 2NEW
If C2> 0, D2>0 and E2>0 --- Give me 3NEW
But if C2> 0, D2= 0, E2>0 --- 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
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 C2>0 --- Give me NEW
If B2= 0, C2>0, and D2>0 --- Give me 2NEW
If C2> 0, D2>0 and E2>0 --- Give me 3NEW
But if C2> 0, D2= 0, E2>0 --- 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