How do I convert a given number into a letter?
 

Basically, I am creating a gradebook for my classes and am interseted in how
to convert a % into a letter grade

Debra Dalgleish has instructions about using =vlookup() and she uses a gradebook
as an example:

http://contextures.com/xlFunctions02.html



vortex0001 wrote:

Basically, I am creating a gradebook for my classes and am interseted in how
to convert a % into a letter grade

--

Dave Peterson

You could enter a table in descending order showing the grade ranges such as:

0 F
60 D
70 C
80 B
90 A

then use VLOOKUP to look the score up in the table and return the letter
grade.

For example, the table is in cell A1:B5 and cell A8 contains a score of 86:

=VLOOKUP(A8,$A$1:$B$5,2,TRUE) will return B




"vortex0001" wrote:

Basically, I am creating a gradebook for my classes and am interseted in how
to convert a % into a letter grade

Hi!

Create a table like the one below:

0............F
60..........D
70..........C
80..........B
90..........A

The above table is based on this grade scale:

0 to 59 = F
60 to 69 = D
70 to 79 = C
80 to 89 = B
90+ = A

Then use a formula like this:

=VLOOKUP(A1,H1:I5,2,1)

A1 = numeric grade
H1:H5 = table range

Biff

"vortex0001" wrote in message
...
Basically, I am creating a gradebook for my classes and am interseted in
how
to convert a % into a letter grade

Hi

=CHOOSE(MATCH(A1,{0;0.6;0.7;0.8;0.9};1),"F","E","D ","C","A")


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"vortex0001" wrote in message
...
Basically, I am creating a gradebook for my classes and am interseted in
how
to convert a % into a letter grade

Hi,

If you want avoid a table then try this,

=LOOKUP(C2,{0,"F";60,"D";70,"C";80,"D";90,"A"})

where C2 houses the score.

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=465803