abc MICROSOFT EXCEL 2010 - VLOOKUP - HLOOKUP
VLOOKUP - student grades, description grade
Grade sutdent by using table for grading
Učenik |
Bodovi |
Učenik 1 |
64 |
Učenik 2 |
59 |
Učenik 3 |
72 |
Učenik 4 |
84 |
Učenik 5 |
88 |
Učenik 6 |
58 |
Učenik 7 |
98 |
Učenik 8 |
75 |
Učenik 9 |
68 |
|
|
Picture 1.Student score |
Picture 2. Grade scheme |
|
|
|
|
Picture 3. document after counting
|
Picture 4. student scorei ocjene |
|
|
|
|
Picture 5. Formula u ćeliji C2
|
|
cell content C2 is=VLOOKUP(B2;$E$2:$F$6;2)
Index |
|