=LOOKUP(B1,{0,49.65,75,84},{"NGP","C","D","HD"})


Gord Dibben MS Excel MVP

On Wed, 4 Oct 2006 15:42:02 -0700, DavidB
wrote:

Thanks Steve for your reply, I know that I didn't make myself clear so may I
try to explain in words (hope this works).
What I am trying to do is set up a scoring system for students. The scoring
system is: 85-100 =High Distinction, 75-84 =Distinction, 65-74 = Credit,
50-64 =Pass, N =NGP. So, for example If I type in whatever score into cell
B13 then I want cell W13 to output either HD, D, C, NGP. Does that make
sense??
My direct email address is
Cheers
David

"SteveW" wrote:

WHat error messages
or give us an example of the edited formula that doesn't work

Steve

On Wed, 04 Oct 2006 12:28:01 +0100, DavidB
wrote:

I want to display a range of quotes in one cell from a formula in that
cell...if you can make sense of that. The first part of the formula works
well and displays one of five messages but I cant add any more formulas
to
the existing one without getting error messages, for example:
=IF(AND(B1384,B13<101),"High Distinction"). This works well but I need
to
add more to it in order to display Distiction, Credit, NGP, Fail...I am
more
than willing to send to anyone who can help me, the Excel spreadsheet to
have
a look at.
Cheers
David