jsk_lge
New Member
Hi all,
I have a database, screen shot is below-
I want the result in D colum, conditions are as below:-
For aging 1 Year - All Products In Wty
For aging 2 Year-3 Year - MNT and REF Nimbus In Wty, all other Out Wty
For Aging 4 Year - 5 Year - All Products Out Wty
if aging is greater than 1 Year and product is Ref but without Nimbus (N in Nimbus Field) than it will be Out Wty.
which formual should i use so that I found desired result (In Wty, Out Wty).
I have a database, screen shot is below-
A
B
C
D
1
Aging PDT Nimbus Wty Status2
1 Year Audio N 3
2 Year REF N 4
1 Year MNT N 5
2 Year REF Y 6
1 Year RAC N 7
3 Year LTV N 8
4 Year PTV N 9
5 Year
WM
N
I want the result in D colum, conditions are as below:-
For aging 1 Year - All Products In Wty
For aging 2 Year-3 Year - MNT and REF Nimbus In Wty, all other Out Wty
For Aging 4 Year - 5 Year - All Products Out Wty
if aging is greater than 1 Year and product is Ref but without Nimbus (N in Nimbus Field) than it will be Out Wty.
which formual should i use so that I found desired result (In Wty, Out Wty).