Percentage formula in Excel! 💥✔️
In This Video,
To calculate the percentage of a student's marks in Excel, you can use the following formula:
(Student's marks / Total marks) * 100
For example, if a student scored 80 out of 100 on a test, their percentage would be calculated as follows:
(80 / 100) * 100 = 80
This formula can be entered into an Excel cell, and then copied and pasted into other cells to calculate the percentages for other students.
Alternatively, you can use the excel formula =(cell number of student marks / cell number of total marks)*100 and press enter.
You can also use the excel formula =SUM(cell number of student marks:cell number of student marks)/SUM(cell number of total marks:cell number of total marks)*100 and press enter.
#viral
#excel
#shorts
#exceltutorial
#exceltips