how to calculate attendance percentage in excel

how to calculate attendance percentage in excel

how to calculate attendance percentage in excel

Hello dear friends, thank you for choosing us. In this post on the solsarin site, we will talk about “  how to calculate attendance percentage in excel “.
Stay with us.
Thank you for your choice.

Percent of students absent

Excel formula: Percent of students absent
Generic formula

To calculate the percentage of students absent in a given class, you can use simple formula that divides students absent (calculated by subtracting attending from total) by the total. In the example shown, the formula in E5, copied down, is:


The result is a decimal value that is formatted using the percentage number format.


In this example, the goal is to answer the question “What percentage of students were absent from each class”. In other words, given a class with 30 students total, 27 of which were present, we want to return 10% absent. The general formula for this calculation, where “x” is the percent absent is:


However, since we don’t have a column for the number of students absent in the table, we need to calculate this number as part of the formula:


After we convert this to an Excel formula with cell references, the formula in E5 becomes:


As the formula is copied down, the formula returns calculated “percent absent” for each class listed in the table. These results are decimal numbers formatted with the Percentage number format.

Formatting percentages in Excel

In mathematics, a percentage is a number expressed as a fraction of 100. For example, 55% is read as “Fifty-five percent” and is equivalent to 55/100 or 0.55. To display values like this with with a percent sign (%), apply Percentage number format.

Dave Bruns

read more:

Leave a Reply

Your email address will not be published. Required fields are marked *