These results are decimal numbers formatted with thePercentage number format.
For example, 55% is read as “Fifty-five percent” and is equivalent to 55/100 or 0.55.
To display values with a percent sign (%), applyPercentage number format.
Percent of students absent
To calculate the percentage of students absent in a given class, you can use a formula that calculates the number of students absent and then divides this number by the total number of students. In the example shown, the formula in E5, copied down, is: =(C5-D5)/C5 The result is a decimal value formatted with the percentage number format.
