electronic gradebook

[shug]

how do i put in the formula to get a letter grade by using percentage. for
instace 100 - 90 = A
89 - 70 = B and so on using Excel.

[SteveG]

shug,

Try this,

=IF(A2>=90,"A",IF(A2>70,"B",IF(A2>69,"C",IF(A2>50,"D","F"))))


HTH

Steve

[tim m]

=IF(A1>89,"A",IF(A1>69,"B",IF(A1>59,"C",IF(A1>49,"D",IF(A1<50,"F",0)))))

You will of course have to change the numbers in the formula for your D and
F etc.

"shug" wrote:

> how do i put in the formula to get a letter grade by using percentage. for
> instace 100 - 90 = A
> 89 - 70 = B and so on using Excel.

[Franz Verga]

Nel post news:[email protected]
*shug* ha scritto:

> how do i put in the formula to get a letter grade by using
> percentage. for instace 100 - 90 = A
> 89 - 70 = B and so on using Excel.

You can use VLOOKUP with last parameter set to TRUE. You have to build a
table, in ascending order of values, and then use the VLOOKUP function.
--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

[Gord Dibben]

shug

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 Fri, 23 Jun 2006 09:57:02 -0700, shug <[email protected]> wrote:

>how do i put in the formula to get a letter grade by using percentage. for
>instace 100 - 90 = A
>89 - 70 = B and so on using Excel.

Gord Dibben MS Excel MVP