Microsoft Excel is a most used spreadsheet application used for a number of calculation purposes. As it has a large number of built-in formulas for making accurate calculations, it is always the first choice of the users to perform such calculation easily and efficiently. In this article, I have explained the procedure how you can create a result card for your school college or any tuition academy.
To create result in Excel, you don’t need to be master of excel. You just need to know some basic formulas. You can create a result system where you can add your student’s names and their obtained marks in the given cells and excel will automatically calculate the result and will save it.
In a result card, we need some basic things i.e. Pass or Fail Grade and sometime you may also need to know the percentage of the obtained marks out of the total marks.
How to create result card in Excel
Create a new excel worksheet and create the columns as required. In this article, I have explained a sample result that can be different from your requirement, so you can use your own subject’s names or you can add more subjects if needed.
In the above sheet, we have created a simple result which has 5 major subjects. The cell “Total Marks” shows the total obtained marks in these 5 subjects. Grade show the grade of the obtained result in the form of predefined criteria as Grade-A, B, C, D, or E. you can change the marks for every grade in the formula.
Setting up the Formulas
Now, your sheet is ready to apply all formulas and get the calculated result. First of all, we will set the simple SUM formula to get the total obtained marks. Click on the blank cell just under the “Total Marks”. And enter the following formula in the formula bar.
=SUM(B3: F3)(The cells numbers can be different in your case, just inter =sum( and select the cell range to apply the formula and the type ).
This will calculate the marks entered in each subject cell and will show a sum of all marks in the Total Marks cell. Drag the formula on other cells in the column to apply to all cells.
To calculate the grade of the result, we have to decide the obtained marks as per grade and enter those values in the grade calculation formula. Select a blank cell under the “Grade” and enter the following formula in the formula bar.
(The cells numbers can be different in your case, select the cell for each logic.)
This will calculate the grade as per your defined formula and will show in the selected cell.
The next is to get the percentage of the obtained marks out of the total marks. It’s a very simple and easy task that can be always done with the universal method of following.
Percentage = Obtained Marks/ Total Marks x 100
Select a blank cell under the “%age” and enter the following formula in the formula bar.
=G3/500*100(The cell number G3 may be different in your case)
Finally, we have set the formulas to calculate the total marks, grade and get the percentage. Now we are adding a cell that will show the result status Pass or Fail as per the calculated result.
Select a blank cell below “Result” and enter the following formula.
=IF(G3>=300, “Pass “, “Fail”)
(The cell number may be different in your case, so select the cell where you have saved the total obtained marks)
Now, the result is ready and we can add our students’ names and enter their obtained marks and get the result.