Just need correct formula according to given below instructions.

Ranking Worksheet (Nested IF One)

1. Write a Nested IF function (you can combine it with AND function) in Ranking worksheet, Ranking column to create the following conditions (2 conditions: Cust_Cat_ value and Shift_ value) and outputs (4 outputs).

Table 1. Nested IF and AND
	Condition 1	Condition 2	Output
Scenario	Cust_Cat_	Shift_	Ranking
1	Guest	Morning	1
2	Guest	Afternoon	2
3	Employee	Any category	3
4	Else (False statement)		4

1. Start from the first scenario IF(AND(condition 1, condition 2),1,IF(),,,,
2. For each scenario, to get the output (1 to 4) from Ranking column, both conditions should be met (AND).
3. N outputs needs N-1 IF functions.
4. Write the formula for cell K2 and then expand it for the rest of the cells.
5. You check equality for each condition. For instance, condition 1 Cust_Cat_=
6. Any category: It means category type does not matter (Any value is acceptable).

Trans_ID SKU Pay_TypeTrans_Qt Emp_ID Cust_Cat SKU_Cat Shift_ Coupon_Am Retail Ranking 1000234 X349R39 Cash 3 38 Employee Coffee Morning 25% $ 1.75 1000235 R483P24 Cash 2 38 Guest Coffee Morning 0% $ 4.50 1000236 F833K19 Ccard 2 38 Guest Food Morning 20% $ 3.25 1000237 R483P24 CCard 3 24 Guest Coffee Morning 0% $ 4.50 1000238 X349R39 CCard 4 24 Employee Coffee Morning 25% $ 1.75 1000239 F833K19 Cash 1 24 Guest Food Morning 0% $ 3.25 1000240 C584T23 CCard 2 24 Guest Coffee Morning 0% $ 5.00 1000241 C584123 Cash 3 24 Guest Coffee Morning 0% $ 5.00 1000242 F833K19 CCard 4 24 Employee Food Morning 25% $ 3.25 1000243 C483T89 CCard 2 38 Guest Food Morning 0% $ 4.25 1000244 F375P67 CCard 3 38 Guest Food Morning 0% $ 3.25 1000245 X487P48 Cash 3 38 Employee Coffee Morning 25% $ 2.25 1000246 C584T23 CCard 4 38 Guest Coffee Morning 0% $ 5.00 1000247 C584T23 CCard 2 38 Guest Coffee Morning 0% $ 5.00 1000248 C584T23 CCard 3 38 Guest Coffee Morning 0% $ 5.00 1000249 R483P24 CCard 4 38 Guest Coffee Morning 0% $ 4.50 1000250 R483P24 Ccard 4 38 Guest Coffee Morning 20% $ 4.50 1000251 F375P67| Cash 2 38 Guest Food Morning 0% $ 3.25 Trans_ID SKU Pay_TypeTrans_Qt Emp_ID Cust_Cat SKU_Cat Shift_ Coupon_Am Retail Ranking 1000234 X349R39 Cash 3 38 Employee Coffee Morning 25% $ 1.75 1000235 R483P24 Cash 2 38 Guest Coffee Morning 0% $ 4.50 1000236 F833K19 Ccard 2 38 Guest Food Morning 20% $ 3.25 1000237 R483P24 CCard 3 24 Guest Coffee Morning 0% $ 4.50 1000238 X349R39 CCard 4 24 Employee Coffee Morning 25% $ 1.75 1000239 F833K19 Cash 1 24 Guest Food Morning 0% $ 3.25 1000240 C584T23 CCard 2 24 Guest Coffee Morning 0% $ 5.00 1000241 C584123 Cash 3 24 Guest Coffee Morning 0% $ 5.00 1000242 F833K19 CCard 4 24 Employee Food Morning 25% $ 3.25 1000243 C483T89 CCard 2 38 Guest Food Morning 0% $ 4.25 1000244 F375P67 CCard 3 38 Guest Food Morning 0% $ 3.25 1000245 X487P48 Cash 3 38 Employee Coffee Morning 25% $ 2.25 1000246 C584T23 CCard 4 38 Guest Coffee Morning 0% $ 5.00 1000247 C584T23 CCard 2 38 Guest Coffee Morning 0% $ 5.00 1000248 C584T23 CCard 3 38 Guest Coffee Morning 0% $ 5.00 1000249 R483P24 CCard 4 38 Guest Coffee Morning 0% $ 4.50 1000250 R483P24 Ccard 4 38 Guest Coffee Morning 20% $ 4.50 1000251 F375P67| Cash 2 38 Guest Food Morning 0% $ 3.25