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
Generic formula
=(total-attended)/total
Summary
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:
=(C5-D5)/C5
The result is a decimal value that is formatted using the percentage number format.
Explanation
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:
x=absent/total
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:
=(C5-D5)/C5
=(30-27)/30=3/30=0.10
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.
Author
Dave Bruns
Related formulas
Get percentage of total
In this example, the goal is to work out the “percent of total” for each expense shown in the worksheet. In other words, given that we know the total is $1945, and we know Rent is $700, we want to determine that Rent is 36% of the total. The total…
Percent of goal
In this example, the objective is to calculate a percentage for each goal shown in column C of the table using the actual values in column D. In other words, given a goal of 100000, and an actual amount of 112000, we want to return 112% as the…
Get amount with percentage
In this example, the goal is to convert the percentages shown in column C to amounts, where the total of all amounts is given as $1945. In other words, if we know Rent is 36.0%, and the total of all expenses is $1945, we want to calculate that Rent…
Get percent of year complete
The goal in this example is to return the amount of time completed in a year as a percentage value, based on any given date. In other words, when given the date July 1, 2021, the formula should return 50% since we are halfway* through the year. *By…