=FACT(number)One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single FACT formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
number:
A non-negative integer for which you want to calculate the factorial. This value must be greater than or equal to 0.
The FACT function in Excel is a mathematical tool that calculates the factorial of a given non-negative integer. The factorial of a number ( n ) is the product of all positive integers from 1 to ( n ). This function is particularly useful in statistics, probability, and combinatorial calculations.
In simpler terms, the FACT function helps you quickly compute the factorial of a number, which can be essential for various mathematical analyses.
Imagine you are working on a statistics project where you need to calculate the number of ways to arrange a set of items. For instance, if you have 5 different books and want to find out how many different ways you can arrange them on a shelf.
| Book Number |
|---|
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
You want to find the total number of arrangements for these 5 books.
To calculate the total arrangements for the 5 books, you would use the FACT formula as follows:
=FACT(5)When you apply the formula, it calculates the factorial of 5, which is ( 5! = 5 \times 4 \times 3 \times 2 \times 1 = 120 ). The output would be:
| Total Arrangements for 5 Books |
|---|
| 120 |
Here, the total number of arrangements for the 5 books is calculated as 120.
The FACT function is particularly useful when you need to perform calculations involving permutations and combinations, which are common in statistics and probability. It allows you to quickly derive factorial values without manual calculations.
Understanding how to use the FACT function can significantly enhance your mathematical capabilities in Excel, enabling you to perform complex calculations with ease.
Happy calculating!
You have a table where Column A contains the number of items produced by different machines in a factory, and you want to determine the total number of ways to arrange those items. You can use the FACT function to calculate the factorial of the number of items produced by each machine. This allows for efficient analysis of production possibilities and helps in optimizing the arrangement of items for packaging or display without needing to delve into more complex combinatorial calculations.
Beyond the FACT function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.