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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array with Sum and multiply 12
I need a different formula that can be copied down 2
With F1 value, look at A, if match or partial match return B 5
multiple variables in sumproduct or if/then formulas 4
if then formula 4
Looking for the correct excel formula 2
If then request 1
Multiple conditions in formula 13

Back
Top