I have 2 different products with 2 different licensing methods
in my final tally sheet I want an statement to help me do this

If part number in C3 = Y,X,Z and quantity in Cell C2 is 400 turn Cell C2
RED, If part number in C3 = A,B,C and quantity in Cell C2 is 224 turn Cell
C2 Red

Can anyone help me with that syntax?

Thanks in advance

--
Neall