MS Excel Grade FormulaIn Excel, the Grade formula is mainly nested IF that checks various conditions and returns a specific Grade if the conditions are met. The formula we used for grade calculation is created in such a manner such that all the conditions for checking the Grade slab are verified and then returns the Grade that belongs to the condition.
How to Use Excel Formula for Grade Calculation?Here are some examples of Excel formulas for calculating grades: Example1: Calculate the Grade of Students Using Excel FormulaIn this example, we have data related to marks obtained by students in their final exams, and we have to calculate grades for marks obtained. In this example, it is necessary to define the criteria for the grade so that we can calculate the Grades. The "A" grade is considered for the highest mark, and the "D" Grade is considered for the lowest mark. We need the following steps to calculate the Grade of students using Excel formula: 1. First, we need to define the criteria that will be utilized to return a Grade for the marks that the student scores. 2. After that, we have to specify the criteria; we will need to figure out how to determine the students' total marks and percentage. 3. hen we need to use the nested IF formula that is: =IF(H2>80%,"A",IF(H2>70%,"B",IF(H2>60%,"C","D"))) The logic that we used in the formula is:
=IF(H2>80%,"A",IF(H2>70%,"B",IF(H2>60%,"C","D")))
=IF(H2>80%,"A",IF(H2>70%,"B",IF(H2>60%,"C","D")))
=IF(H2>80%,"A",IF(H2>70%,"B",IF(H2>60%,"C","D")))
=IF(H2>80%,"A",IF(H2>70%,"B",IF(H2>60%,"C","D"))) 4. Finally, we must drag the formula down to other cells to calculate the grade for the remaining students or cells. 2. Calculate the Product Quality Grade Using Excel Formula for Grade.In this Grade formula example, we have to calculate the grade of quality for vegetables based on the quality score of the specific vegetables received. Grade "A" will be considered for the best quality vegetables, and Grade "D" will be considered for a poor-quality vegetable. The following are the steps that must be followed to determine the product quality grade: 1. First, we have to set the criteria in order to calculate the grade. 2. ext, we will use the nested IF else formula just like we used in the above example to calculate the Grade for the quality of the product. The following formula we need to use in this example =IF(B2>80%,"A",IF(B2>70%,"B",IF(BS>60%,"C","D"))) In this case, we have defined the logic as follows:
=IF(B2>80%,"A",IF(B2>70%,"B",IF(BS>60%,"C","D")))
=IF(B2>80%,"A",IF(B2>70%,"B",IF(BS>60%,"C","D")))
=IF(B2>80%,"A",IF(B2>70%,"B",IF(BS>60%,"C","D")))
=IF(B2>80%,"A",IF(B2>70%,"B",IF(BS>60%,"C","D"))) 3. At last, we have to drag the formula down to other cells to determine the Grade for the remaining product. 3. Calculating the Grade of Quality Offered by Service CentersNow, unlike the previous two examples of Excel Grade Formula, the formula we will use in this case will be different because the criteria will be the number of complaints registered against the customer care center. This indicates that the fewer the complaints, the higher the service quality. The following are the steps that we have to follow to define the criteria for the Grade of service. 1. First, we must define the service Grade criteria. 2. Then we have to use the following formula in order to calculate the Grade; in this example, we use the Logic of "<" (less than) instead of ">." (Greater than). The nested IF formula which we have to use in this example is: =IF(B2<10,"A",IF(B2<20,"B",IF(B2<30,"C",))) The logic which we used in this example is as below:
=IF(B2<10,"A",IF(B2<20,"B",IF(B2<30,"C",)))
=IF(B2<10,"A",IF(B2<20,"B",IF(B2<30,"C",)))
=IF(B2<10,"A",IF(B2<20,"B",IF(B2<30,"C",)))
=IF(B2<10,"A",IF(B2<20,"B",IF(B2<30,"C",))) 3. At last, we have to drag the formula down to the remaining cells. Some Important Points that We need to Keep in Mind When Using Excel Formulas for GradesThe following are some important points that we have to keep in mind when using Excel formulas for Grades:
Next Topic10 Disadvantages of Microsoft Excel
|