vlookup function

[blinkerbox]

I am doing grading using excel. For grade percentages, I would like to
have the letter grade automatically calculated rather than figuring out
each student individually. The grade percentages are broken into 10s,
each one gets the next letter and after 60 is an F. How do I enter the
formula to automatically process the letter grade. Any help you can
give me is much appreciated. Thanks.

 

[L. Howard Kittle]

Hi Blinkerbox,

I've sent you an example by private e-mail which may help. Will need some
adjustments for sure, but it may get you going.

HTH
Regards,
Howard

 

[Dale Hymel]

Set up a table as follows
and assuming the percent is D1, then in E1

A B C D E
1 0% F 55% = vlookup(d1,A1:B5,2)
2 60% D
3 70% C
4 80% B
5 90% A

 

[Earl Kiosterud]

Blinkerbox,

You'll probably be copying Dale's formula down a column in your student
grades table. You'll need absolute cell references:

= vlookup(d1,$A$1:$B$5,2)

Why do they call it VLOOKUP? It doesn't look up. It looks down.

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Set up a table as follows
and assuming the percent is D1, then in E1

A B C D E
1 0% F 55% = vlookup(d1,A1:B5,2)
2 60% D
3 70% C
4 80% B
5 90% A

 

[Fabian]

Blinkerbox,

You'll probably be copying Dale's formula down a column in your student
grades table. You'll need absolute cell references:

= vlookup(d1,$A$1:$B$5,2)

Why do they call it VLOOKUP? It doesn't look up. It looks down.

It looks on a _vertical_ axis for the index number. Might want to
contrast that with hlookup, which checks a horizontal axis.

 

[Earl Kiosterud]

Still think it oughtta be VLOOKDOWN.

 

[J.E. McGimpsey]

Still think it oughtta be VLOOKDOWN.

'Course, on a Tablet PC, a VLOOKDOWN() may well be horizontal. It
could be called LOCOTHROW() (for LOok at COlumns, THen ROWs)...
Perhaps we should just call it GEORGE().

 

[Alan Beban]

And when you go to the telephone book and peruse down the columns to
find your friend's telephone number, do you think we ought to refer to
that as "looking down his telephone number"?

Alan Beban