I have to give grades to the students marks with about 12 different grades like 95 marks -- A++, 90 marks -- A+, 80 marks -- A, 70 marks -- B+, so on. But the nested IF function allows only 7 IF's. How to overcome this problem ? Is there any other way to do it with another function ? Please help me. Thanks. Ramu

---

Answer from Richard Rost:

This is a job for the VLOOKUP function. In fact, this is the exact same example I give in my tutorials:

You can use the VLOOKUP or HLOOKUP function.

VLOOKUP is a powerful function in Microsoft Excel that allows you to look up a value from another spreadsheet - or a smaller subtable (lookup table).

See this FREE tutorial for help with VLOOKUP:

http://599cd.com/tips/excel/vlookup/?key=BlFAlEx