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

Lookup and Reference Examples

  • How to get address of named range in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • How to use Excel TRANSPOSE Function
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation

Data Analysis Examples

  • Example of COUNTIFS with variable table column in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • How To Remove Duplicates In Excel Column Or Row?
  • Managing Conditional Formatting Rules in Excel
  • How to conditionally sum numeric data in an Excel table using SUMIFS

Data Validation Examples

  • Excel Data validation allow uppercase only
  • Excel Data validation require unique number
  • Excel Data validation specific characters only
  • Excel Data validation must not contain
  • Excel Data validation with conditional 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:   Find, Trace and Correct Errors in Excel Formulas using 'Formula Auditing'

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:   How to get number of days, weeks, months or years between two dates in Excel

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:   How To Create Budget in Excel

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
  • SUBSTITUTE function: Description, Usage, Syntax, Examples and Explanation
  • SEARCH, SEARCHB functions: Description, Usage, Syntax, Examples and Explanation
  • CONCAT function: Description, Usage, Syntax, Examples and Explanation
  • Convert Text to Numbers in Excel
  • How to calculate Number of Instances in Excel
  • MONTH function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate percent of year complete in Excel
  • How to calculate nth day of week in month in Excel
  • Display the current date in Excel
  • Get days between dates ignoring years in Excel
  • EFFECT function: Description, Usage, Syntax, Examples and Explanation
  • COUPDAYS function: Description, Usage, Syntax, Examples and Explanation
  • FV function: Description, Usage, Syntax, Examples and Explanation
  • ODDFPRICE function: Description, Usage, Syntax, Examples and Explanation
  • FVSCHEDULE function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles