Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft > How to Calculate Factorial in Excel? Along with 2 Easy Examples

How to Calculate Factorial in Excel? Along with 2 Easy Examples

(Note: This guide on how to calculate factorial in Excel is suitable for all Excel versions including Office 365)

We all might have learned about the concept of factorials in our high school math. As we grew up, we understood the concept of factorial has various uses while operating on probability, permutations, and combinations. 

We also know Excel can perform various mathematical calculations and complex functions. Likewise, if you want to find the factorial of a value you won’t need a pen and paper, Excel has a function to help you find the factorial of a number easily. 

In this article, I will show you what is factorial in Excel and how to calculate factorial in Excel. Also, I will show you examples and additional cases when calculating factorial in excel.

You’ll Learn:

  • Factorial in Mathematics
  • Factorial in Excel
  • Examples of using the FACT() function in Excel
  • Other cases of using the FACT() in Excel

Related Reads:

How to Convert Text to Numbers in Excel? 5 Easy Methods

How to Count Unique Values in Excel? 3 Easy Ways to Count Unique and Distinct Values

How to Split and Combine Data in Excel?

Factorial in Mathematics

Factorial is defined as the product of all numbers less than or equal to the given number. In mathematics, it is represented with an exclamation mark.

For example, consider a number “n”. Mathematically, it is represented in its factorial form as “n!”. And, the formula for factorial for the number n is n x (n-1)!. Replace n with any whole number to find the factorial of the said number. 

Consider an example, where you want to calculate the factorial of the number 5. By applying the formula: n x (n-1)! And replacing the value of n with 5, we get the value equal to 120. That is, the value of 5! is the product of numbers less than or equal to 5 till it reaches 1. 

5! = (5x4x3x2x1) = 120

Factorial in Excel

Factorial is an in-built function in Excel and is categorized under Math/Trig functions. The functionality of the factorial function in Excel is similar to the mathematical operation. However, you cannot express factorial function in Excel as you do in mathematical terms.

Entering the value =5! will throw an error as it is not the right syntax for the operation.

Error for Factorial in Excel
Error for Factorial in Excel

In Excel, the syntax to calculate the factorial value for a given number is =FACT(n). Where n is a whole number. This function takes only one argument. Using the function is the same as using the other Excel mathematical functions. You can either enter the function in the cell or in the formula bar.

Consider an example where you have to calculate the factorial of number 6. Enter the function =FACT(6) in the destination cell or formula bar. Press Enter. This returns the value of 720.

Enter the function in the destination cell
Enter the function in the destination cell

You can also use the function by passing the argument as variables instead of constants. Consider an example in which cell A3 has the value of 4. To find the factorial value of the number in cell A3, enter the formula =FACT(A3) in the destination cell or the formula bar. 

Enter the cell in the function
Enter the cell in the function

Also Read:

How to Fix the #REF Error in Excel? 3 Easy Methods

How to Fix the Excel Circular Reference Error?

How to Use the Excel DATEDIF Function? 3 Easy Examples

Examples of using the FACT() function in Excel

Consider an example, where you have to arrange 5 students in a linear fashion. To arrange the students there are no criteria given. Without any criteria, there are a number of ways to arrange them.

It would’ve been easy if you were asked to arrange them in alphabetical order or based on their heights. But without any criteria, the number of ways the students can be arranged is found using the factorial method.

Since there are 5 students, enter the value =FACT(5) in the formula bar or in any cell. And press Enter. This gives the value of the number of ways the students can be arranged.

Calculate Factorial in Excel Example 1
Calculate Factorial in Excel Example 1

Consider another example where you have to find the number of words that can be formed from the word “EXCEL”.

In this case, the word has two “E”s. To arrive at how many words can be formed from the word “EXCEL” divide the total number of letters by the number of occurrences of the same letter.

Therefore, the number of words that can be formed from the word “EXCEL” is given by the expression =FACT(5)/FACT(2). This function returns the value 60, denoting 60 words that can be formed from the EXCEL by rearranging the letters.

Calculate Factorial in Excel Example 2
Calculate Factorial in Excel Example 2

Other cases of using the FACT() in Excel

Factorial in Excel only accepts whole numbers as arguments. However, when the argument has other values than whole numbers or integers, Excel converts them and returns the value to any one of the following:

  • When the argument is a negative whole number or a negative decimal value, Excel returns a #NUM! error signifying the argument should not be a negative value.
Enter negative number as function
Enter negative number as function
  • When the argument is a decimal value, Excel rounds down the value to a whole number and then finds the factorial of the number. 
Enter decimal as function
Enter decimal as function
  • When the argument passed is zero. Excel returns the value 1.
Enter 0 as function
Enter 0 as function
  • When the argument passed in one. Excel returns the value 1.
Enter 1 as function
Enter 1 as function

Suggested Reads:

How to Make a Box Plot Excel Chart? 2 Easy Ways

How to Use the Excel NOW Function? 3 Examples

How to Add Error Bars in Excel? 7 Best Methods

Closing Thoughts

In this article, we saw what is factorial in Excel, how to calculate, and examples with special cases in Excel. 

The factorial function is used to calculate or count different ways to arrange or order things. And more importantly, factorials are the basis of probability, permutations, and combinations. Excel simplifies the functionality when performing complex operations. Type in the function and arrive at your answer.

Want more high-quality guides for Excel? Check out our free Excel resources centre. 

Click here to access in-depth Excel training courses and master in-demand advanced Excel skills. 

Simon Sez IT has been teaching critical IT software for over ten years. For a low, monthly fee you can get access to 130+ IT training courses by seasoned professionals.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

How to Update Your Company Information In QuickBooks 2019

How to Delete a Page in Word?

How to Use the Excel Collapse Rows Feature? — 4 Easy Steps

Bar Graph in Excel — All 4 Types Explained Easily (Excel Sheet Included)

How to Level Resources in Microsoft Project 2016

How to Change PowerPoint Slides to Portrait – 2 Easy Methods

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)