Exceljet

Quick, clean, and to the point

Percent of students absent

Excel formula: Percent of students absent
Generic formula 
=(total-attended)/total
Explanation 

To calculate percent of students attending a class, given a total class size and the number of students attending, you can use a simple formula that divides students absent (calculated by subtracting attending from total) by the total. The result must be formatted using the percentage number format.

In the example shown, we have a total class size in column C, total attended in column D, the calculated percent attending in Column E, and the calculated percent absent in column F.

In cell F6, the formula is:

=(C6-D6)/C6

How this formula works

The formula in F5 first calculates the number of students absent using (C6-D6), then divides the result by the total students. So the formula reduces like this:

=(C6-D6)/C6
=(100-92)/100
=8/100
=.08

When formatted using the Percentage number format .08 = 8%.

Note: when working manually, percentage results are calculated by dividing one number by another (for example, a part by a whole) to get a decimal value, then multiplying by 100 to express as a percentage. However, because Excel can display decimal or fractional values automatically as a percentage by applying the Percentage number format, there is no need to multiply by 100.

Author 
Dave Bruns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.