MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by MARTHA on September 26, 2001 11:41 AM

Remember I asked about giving a letter grade to a value. I found a formula. Here it is to those of you who can pass it on:

Thanx guys for your help,


Posted by IML on September 26, 2001 11:57 AM

The other option...

with your data would be

this would be better if you had a grade like 69.5 that isn't covered in your if statement.

Posted by T on September 26, 2001 11:57 AM

This can be simplified to

Posted by Aladin Akyurek on September 26, 2001 12:04 PM

Why not VLOOKUP?

Martha --

I'd rather propose to use:



Posted by martha on September 26, 2001 1:43 PM

Re: The other option...

Both of you are right about using a lookup rather than the ifstatement. I guess I was a little ignorant to how far a lookup can go. Thanx again.