I have a particular circumstance where I need an "IF" formula that would give the following results:

Cell I164 would display "Outstanding" if the value of H164 was greater than or equal to 95%, "Excellent" for 90 to 94.99%, "Satisfactory" for 80 to 89.99%, "Marginal" for 70 to 79.99%, and "Unsatisfactory" for 0 to 69.99%.

Is this possible or is this too complex a function for excel at this time?

v/r
James Spence

---

Answer from Richard Rost:

You could do it with IF, although I'd probably use VLOOKUP for something like this.

See this tutorial for help:

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