functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a teacher and have all my grades on excel, I want to use my precentage to display a letter grade. I tryed =if but to many to enter all then they did not display only got A's for all??? Can anyone help?
 
Have a look in HELP index for VLOOKUP


--
Don Guillett
SalesAid Software
(e-mail address removed)
Dajani said:
I am a teacher and have all my grades on excel, I want to use my
Click to expand...
precentage to display a letter grade. I tryed =if but to many to enter all
then they did not display only got A's for all??? Can anyone help?
 
Dajani,

Fundamentally, what you need to do is build a 2-column table. The first
column will hold the base value of the grade, the second will hold the grade
letter.

So as an example, you may have a table like

A B
1 0 F
2 50 E
3 60 D
4 70 C
5 80 B
6 90 A
7 95 A*

You then use a formula like =VLOOKUP(H1,$A$1:$B$7,2) to get the grade where
H1 holds the student's score.

So], a value of 49 returns F, 50 reeturns E, etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Dajani said:
I am a teacher and have all my grades on excel, I want to use my
Click to expand...
precentage to display a letter grade. I tryed =if but to many to enter all
then they did not display only got A's for all??? Can anyone help?
 
Thanks, still not sure how to do it but I will try!!

----- Don Guillett wrote: -----

Have a look in HELP index for VLOOKUP


--
Don Guillett
SalesAid Software
(e-mail address removed)
Dajani said:
I am a teacher and have all my grades on excel, I want to use my
Click to expand...
precentage to display a letter grade. I tryed =if but to many to enter all
then they did not display only got A's for all??? Can anyone help?
 
Back
Top