Nested IF Statement-How can I write a Nested IF statement

Hello,

In column A I have a list of scores (0, 66, 100, etc.).

In column B I need to identify the corresponding rating (Low, Successful, Commendable, etc.), depending upon where in the score range the number is.

Score Range and Rating: 121-150: Outstanding, 91-105: Commendable, 61-90: Successful, 30-60: Developing , 0: Low

Ex. Score 66 should have a Rating of Successful, 33 Successful.

How can I write a Nested IF statement that would accommodate these different ratings options?

Thank you.

Brandy

You want to use VLOOKUP instead of Nested IF's. Create a table (e.g. Sheet2!A1:B5) with the lower limit of each catagory in A with catagory in B

Please Login or Register  to view this content.

Then in your formula, let's say you're referring to a rating in A1

Please Login or Register  to view this content.

Does that work for you?

I'd use index match, I don't see where your formula accounts for rounding down, ChemistB.

See attached.

MATCH gives you the ROW in which the closest match (in this case rounded down) is to the criteria.

So if it's between 30-60, it'd return 2, being found in the second row.

INDEX then returns the information from the 2nd row of the array given.

Hi Mewing,
I'm not sure what you mean by "rounding down". I tried the formula with 29,30,31 (Low, Dev, dev) and 120, 121,150 (Commend, OutSt. OutSt).

Was using a named range in my first worksheet, this one might be easier to learn from, since it references all arrays by range.

EDIT
ChemistB,
I didn't know that VLOOKUP looked for the lowest corresponding number, to be honest I thought it only returned exact matches.

Shows what I know ><