Assign a grade to a result
This example shows how to calculate a grade based on a mark, using an Excel VLOOKUP function
Example: Assign a grade to a result
|
=VLOOKUP(C5,$B$13:$D$17,3,TRUE)
|
This formula uses an Excel VLOOKUP function combined with a mapping table to calculate the a grade that is associated with the selected result. The mapping table, that is located in range (B11:D17), captures the results scale with a specific grade assigned to it.
Given we are using the Excel VLOOKUP function, please ensure that the mapping table stores the scores on the left side, with the grades to the right. The mapping table must also be sorted in an ascending order, given the Excel VLOOKUP is using the approximate match. This formula is to be applied to cell (D5) and then dragged down to cell (D9) to calculate the grade associated with each of the students in the table. |
EXPLANATION
This example shows how to calculate a grade based on a mark. The formula uses the an Excel VLOOKUP function combined with a mapping table to calculate the a grade that is associated with the selected result. The mapping table captures the results scale with a specific grade assigned to it.
You can change the results scale and the relevant grade that is assigned to the specific results scale, by changing this information in the mapping table.
This example shows how to calculate a grade based on a mark. The formula uses the an Excel VLOOKUP function combined with a mapping table to calculate the a grade that is associated with the selected result. The mapping table captures the results scale with a specific grade assigned to it.
You can change the results scale and the relevant grade that is assigned to the specific results scale, by changing this information in the mapping table.
FORMULA
=VLOOKUP(lookup_value,mapping_table, column_index_number,TRUE)
=VLOOKUP(lookup_value,mapping_table, column_index_number,TRUE)
ARGUMENTS
lookup_value: The result that you want to assign an associated grade to.
mapping_table: The mapping table that captures the results scale and the associated grade for each of the result scale.
column_index_number: A column number in the mapping table from which to source the associated grade.
lookup_value: The result that you want to assign an associated grade to.
mapping_table: The mapping table that captures the results scale and the associated grade for each of the result scale.
column_index_number: A column number in the mapping table from which to source the associated grade.
APPLICATION
The calculation to source a grade that is associated with a specific result that is shown in this example can be applied to an educational environment that has more than one student. Educational institutions such as Universities, Colleges, High Schools and others can apply this example if they want to assign a grade that is associated with a students mark.
The calculation to source a grade that is associated with a specific result that is shown in this example can be applied to an educational environment that has more than one student. Educational institutions such as Universities, Colleges, High Schools and others can apply this example if they want to assign a grade that is associated with a students mark.