OK having problems with this is what I am trying to do 1=100 2=90 : 3=80 : 4=70 : 5=60 : 6 to 10=50 : 11 to 20=40 : 21 to 30=30 : 31 to 40=20 : 41 to50=10 but when I get to this point : =IF(C3=1,100,IF(C3=2,90,IF(C3=3,80,IF(C3=4,70,IF(C3=5,60,IF(AND(C3>5,C3<11),50,IF(AND(C3>10,C3<21),40,IF(AND(C3>20,C3<31),30,""))))))) I get a message coming up saying !the specified formula cannot be entered because it uses more levels of masking than are allowed in the current format"