How to How to Use FACT Function in Excel in Excel - Practical Guide

Learn how to use the FACT function to calculate factorials in Excel. This tutorial covers the syntax, practical applications, and common use cases for computing factorials of numbers. Factorials are essential in statistics, probability, and combinatorics, making this function valuable for data analysts and researchers.

Why This Matters

The FACT function is critical for statistical analysis, probability calculations, and combinatorial problems in professional data analysis. Mastering it streamlines complex mathematical computations and improves spreadsheet efficiency.

Prerequisites

•Basic understanding of Excel formulas and cell references
•Knowledge of mathematical factorials (n!)

Step-by-Step Instructions

Open Excel and select a cell

Launch Microsoft Excel and click on any empty cell where you want to enter the FACT formula.

Type the FACT formula

Enter =FACT(number) where 'number' is the integer you want to calculate the factorial for, such as =FACT(5).

Press Enter to execute

Press Enter to execute the formula and view the factorial result displayed in the cell.

Use cell references for dynamic calculation

Reference a cell containing a number using =FACT(A1) to calculate factorials dynamically based on cell values.

Copy the formula down for multiple calculations

Click the cell with the formula, then drag the fill handle (small square at bottom-right) down to copy the formula to adjacent cells.

Alternative Methods

Using FACT with other functions

Combine FACT with PRODUCT or other mathematical functions to create more complex probability and combinatorial calculations within a single formula.

Creating a factorial lookup table

Build a reference table listing numbers and their corresponding factorials using FACT for quick manual lookups without recalculating.

Tips & Tricks

✓FACT only accepts non-negative integers (0 through 170); decimal values will return a #NUM! error.
✓Remember that 0! equals 1 in mathematics, and Excel correctly returns this result.
✓Use absolute references ($A$1) when copying formulas to prevent cell reference changes.
✓Combine with IF statements to validate input: =IF(A1>=0, FACT(A1), "Invalid input").

Pro Tips

★FACT is limited to 170; for larger factorials, use GAMMA(n+1) which calculates factorials for extended ranges.
★Pair FACT with COMBIN and PERMUT functions to calculate combinations and permutations efficiently.
★Use Data Validation (Data > Validity > Whole number) to restrict inputs to valid factorial ranges.
★Create array formulas with FACT to process multiple values simultaneously using Ctrl+Shift+Enter.

Troubleshooting

Getting #NUM! error when using FACT

Check that your input is a non-negative integer between 0-170. Verify there are no decimal places or negative values; if needed, use INT() to round first: =FACT(INT(A1)).

Formula not recognizing FACT function

Ensure the formula starts with = and uses correct syntax =FACT(number). Check that 'FACT' is spelled correctly and not enclosed in quotes.

FACT result appears as very large numbers in scientific notation

This is normal for large factorials; increase cell width or format as Number with 0 decimal places via Format Cells (Ctrl+1) > Number tab.

Related Excel Formulas

COMBIN PERMUT GAMMA PRODUCT MULTINOMIAL

Frequently Asked Questions

What does the FACT function do in Excel?

The FACT function calculates the factorial of a number, which is the product of all positive integers up to that number. For example, FACT(5) returns 120 because 5×4×3×2×1=120.

What is the maximum number FACT can calculate?

FACT can calculate factorials up to 170. For numbers larger than 170, use the GAMMA function with the formula =GAMMA(n+1) to obtain factorial values for extended ranges.

Can FACT work with decimal or negative numbers?

No, FACT only accepts non-negative integers (0-170). Decimal or negative inputs will return a #NUM! error. Use INT() to round decimals if needed.

What does FACT(0) return?

FACT(0) returns 1, which is mathematically correct because the factorial of zero is defined as 1 by convention.

How do I use FACT with cell references?

Use the syntax =FACT(A1) where A1 contains your number. This creates a dynamic formula that recalculates whenever the value in A1 changes.