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

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"

use VBA
select case

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";3 51,"J";376,"K";401,"L";426,"M";451,"N";476,"O";501 ,"P";526,"Q";551,"R"},2))

Beware of line wrapping

--
Regards,

Peo Sjoblom


"Lynn Marie" <Lynn wrote in message
...
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"

Thank you so much! It worked perfectly!

"Peo Sjoblom" wrote:

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";3 51,"J";376,"K";401,"L";426,"M";451,"N";476,"O";501 ,"P";526,"Q";551,"R"},2))

Beware of line wrapping

--
Regards,

Peo Sjoblom


"Lynn Marie" <Lynn wrote in message
...
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"