IF_NESTED_3

In the Name box name this Bit1

=IF(A1="bmw",1,IF(A1="bmww",2,IF(A1="bMw",3,IF(A1="fiat",4,IF(A1="rolls",5,IF(A1="saab",4,IF(A1="ford",5,IF(A1="daf",6,FALSE))))))))

In the Name box name this Bit2

=IF(A1="red",1,IF(A1="yellow",2,IF(A1="pink",3,IF(A1="green",4,IF(A1="orange",5,IF(A1="purple",4,IF(A1="black",5,IF(A1="white",6,FALSE))))))))

This is the Master

=IF(Bit1,Bit1,Bit2)