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" <vortex0001@discussions.microsoft.com> wrote in message
news:1F5A3827-2048-411C-BF3A-D456217DEB75@microsoft.com...
> 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<at>tarkon.ee )



"vortex0001" <vortex0001@discussions.microsoft.com> wrote in message
news:1F5A3827-2048-411C-BF3A-D456217DEB75@microsoft.com...
> Basically, I am creating a gradebook for my classes and am interseted in
> how
> to convert a % into a letter grade