To compute letter grade using VLOOKUP( ) function in Excel-2007
23) In a Worksheet Name and Percentage of marks are entered in cells A2:A1002 and B2:B1002,Explain the steps to fill cells C2:C1002 with letter grade using VLOOKUP().
The Policy is Grading is as follows:
Marks | <=40 | >40 and <=60 | >60 and <=80 | >80 |
Grade | D | C | B | A |
To compute letter grade using VLOOKUP()
Enter the policy of grading as follows:
Enter 0,41,61,81 in cells D2,D3,D4 and D5
Enter D,C,B,A in cells E2,E3,E4 and E5.
Enter the formula
=VLOOKUP(B2,$D$2:$E$5,2) in cell C2 and press enter key.
And then press enter key, using the fill handle of cell C2, copy the formula to cells C3:C1002 , by dragging the fill handle up to cell C1002.
0 comments:
Post a Comment