How To Calculate Marks Percentage & Division In Excel 2016 – Excel Tutorial

No votes yet.
Please wait...

Microsoft Excel is a member of Microsoft Office family which is a powerful tool that has been developed for accounting, Calculating as well as you can use it for other purposes such as, Saving any company’s data, details, and other info.

In this short Article, today we’re going to learn how to calculate marks percentage & division in excel using a simple formula & trick.

calculate-marks-percentage-division-excel

If you have not Microsoft excel installed on your PC then simply download it from the Microsoft official site.

If you have already then first of all, Open excel & follow these steps.

#1 Make a table in Excel by writing student Id, Name etc. You can see in the table below.

Marks Percentage & Division Calculation Table

Student IDStudent NameFather NameMarks ObtainedTotal MarksPercentageDivision
1Iftikhar****9801100
3Jack****7341100
4Maryam****7071100
2Sultan****9641100

#2 Below the Percentage Cell, use this formula: =Marks Obtained/Total Marks*100

#3 Below the Division Cell, use this formula: =if(perc>=80,”1st Division”,if(perc>=60,”2nd Division”,if(perc>=40,”3rd Division”,if(perc<40,”Fail”))))

Remove perc from the formula & use the percentage cell instead of perc.

For more details, watch this video tutorial.

Hope you’ll be enjoying it, if you have any question feel free to ask me in the comment section below.

Related: How To Change Wifi Password & SSID Name

Thanks 🙂