# How to Calculate Attendance Percentage in Excel (with Steps)

### Step 1 – Creating a Dataset with Proper Parameters

• Our sample dataset includes 7 students, the number of lectures delivered and the number of lectures they attended. We will calculate the percentage of delivered lectures attended by each student.

### Step 2 – Applying the Percentage Formula

Numerator/Denominator is the Excel formula for percentages, with the result multiplied by 100. In our example, for each student, the denominator is the number of lectures delivered, and the numerator is the number of those lectures attended.

• Select the E5 cell.
• Enter the following formula:
=D5/C5*100
• Press ENTER.

• Use the Fill Handle tool andÂ drag it down from cell E5 to cell E11 to copy the formula across the range.

### Step 3 – Showing Final Result

• All the studentsâ€™ attendance percentages are returned:

<< Go Back to Attendance | Formula List | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Bishawajit Chakraborty

Bishawajit Chakraborty, a Rajshahi University of Engineering & Technology graduate with a B.Sc. in Mechanical Engineering, has been associated with ExcelDemy since 2022. Presently, he is a content developer, specializing in Excel Power Query, Data Analysis and VBA. It is worth mentioning that he has authored more than 90 articles on VBA content development. His profound interest lies in the fields of data analytics and data science. He possesses expertise in VBA, Power BI, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF