software

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(B28gt;=93,quot;aquot;,quot;Bquot;),if(then(B28lt;=85,quot;cquot;),if( then(b28lt;=70,quot;Dquot;),if(then(b28gt;=69,quot;fquot;))), what do i have wrong.

see answers in programming. Pls only post in ONE group

--
Don Guillett
SalesAid Software

quot;davequot; gt; wrote in message
news
gt; i'm trying to put a value of a number to print out a letter such as 93 to
gt; 100=A, and so on here is what I
gt; have,=IF(B28gt;=93,quot;aquot;,quot;Bquot;),if(then(B28lt;=85,quot;cquot;),if( then(b28lt;=70,quot;Dquot;),if(then(b28gt;=69,quot;fquot;))),
gt; what do i have wrong.
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},{quot;Equot;,quot;Dquot;,quot; C-quot;,quot;Cquot;,quot;C quot;,quot;Bquot;,quot;B quot;,quot;Aquot;})

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 gt; wrote:

gt;i'm trying to put a value of a number to print out a letter such as 93 to
gt;100=A, and so on here is what I
gt;have,=IF(B28gt;=93,quot;aquot;,quot;Bquot;),if(then(B28lt;=85,quot;cquot;),if (then(b28lt;=70,quot;Dquot;),if(then(b28gt;=69,quot;fquot;))), what do i have wrong.

Gord Dibben MS Excel MVP