Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel TRANSPOSE Function
  • Find closest match in Excel
  • How to use Excel FORMULATEXT function
  • How to use Excel MMULT Function

Data Analysis Examples

  • How To Create Frequency Distribution in Excel
  • How to Create Thermometer Chart in Excel
  • Understanding Pivot Tables in Excel
  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • Excel Pie Chart

Data Validation Examples

  • Data validation must not exist in list
  • Excel Data validation require unique number
  • Excel Data validation allow weekday only
  • Excel Data validation no punctuation
  • Excel Data validation exists in list

How to calculate percent of students absent in Excel

by

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.

Worked Example:   Transpose: Switch 'Rows to Columns' or 'Columns to Rows' in Excel

Formula

=(total-attended)/total


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.

Worked Example:   Excel Two-Way Lookup Example

Explanation

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%.

Worked Example:   Find Most Frequently Occurring Word in Excel Worksheet

Post navigation

Previous Post:

How to calculate percent sold in Excel

Next Post:

How to calculate percent of goal in Excel

Leave a Reply Cancel reply

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

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to create email address from name in Excel
  • CODE function: Description, Usage, Syntax, Examples and Explanation
  • UNICHAR function: Description, Usage, Syntax, Examples and Explanation
  • Complete List of Excel Text Functions References and Examples
  • How to extract name from email address in Excel
  • Count day of week between dates in Excel
  • Get fiscal year from date in Excel
  • Add decimal minutes to time in Excel
  • Get work hours between dates and times in Excel
  • Two ways to sum time over 30 minutes in Excel
  • DB function: Description, Usage, Syntax, Examples and Explanation
  • AMORDEGRC function: Description, Usage, Syntax, Examples and Explanation
  • Calculate periods for annuity in Excel
  • RRI function: Description, Usage, Syntax, Examples and Explanation
  • ISPMT function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles