Need formula for: if A6=100 thru 125, then "A", etc thru "S"

L

Lynn Marie

Since nesting doesn't exceed 7 ... for scoring purposes, I need a formula
that will allow results through "S" for "IF A6 = 100 through 125, then "A";
IF A6 = 126 through 150, then "B"; etc through the letter "S"
 
P

Peo Sjoblom

One way

=IF(A6<100,"No
Score",VLOOKUP(A6,{100,"S";126,"A";151,"B";176,"C";201,"D";226,"E";251,"F";276,"G";301,"H";326,"I";351,"J";376,"K";401,"L";426,"M";451,"N";476,"O";501,"P";526,"Q";551,"R"},2))

Beware of line wrapping
 
L

Lynn Marie

Thank you so much! It worked perfectly!

Peo Sjoblom said:
One way

=IF(A6<100,"No
Score",VLOOKUP(A6,{100,"S";126,"A";151,"B";176,"C";201,"D";226,"E";251,"F";276,"G";301,"H";326,"I";351,"J";376,"K";401,"L";426,"M";451,"N";476,"O";501,"P";526,"Q";551,"R"},2))

Beware of line wrapping
Click to expand...
 
Top