i'm trying to put a value with a number but its not working.
 

i'm trying to put a value of a number to print out a letter such as 93 to
100=A, and so on here is what I
have,=IF(B28=93,"a","B"),if(then(B28<=85,"c"),if( then(b28<=70,"D"),if(then(b28=69,"f"))), what do i have wrong.

i'm trying to put a value with a number but its not working.
 

see answers in programming. Pls only post in ONE group

--
Don Guillett
SalesAid Software

"dave" wrote in message
...
i'm trying to put a value of a number to print out a letter such as 93 to
100=A, and so on here is what I
have,=IF(B28=93,"a","B"),if(then(B28<=85,"c"),if( then(b28<=70,"D"),if(then(b28=69,"f"))),
what do i have wrong.

i'm trying to put a value with a number but its not working.
 

Dave

To convert scores to letter grades use a Lookup table and VLOOKUP functions.

OR a Lookup formula without a table

Assuming scores are in column A starting at A1.

In B1 enter this formula then drag/copy down column B

=LOOKUP(A1,{0,31,41,51,61,71,81,91,101},{"E","D"," C-","C","C+","B","B+","A"})

Example only. Adapt for your scores and grades.

Note the curly braces internally.


Gord Dibben MS Excel MVP

On Sat, 8 Apr 2006 09:44:02 -0700, dave wrote:

i'm trying to put a value of a number to print out a letter such as 93 to
100=A, and so on here is what I
have,=IF(B28=93,"a","B"),if(then(B28<=85,"c"),if (then(b28<=70,"D"),if(then(b28=69,"f"))), what do i have wrong.

Gord Dibben MS Excel MVP