What is FACT function in Excel?
FACT function is one of the Math and Trig functions in Microsoft Excel that returns the factorial of a number. The factorial of a number is equal to 1*2*3*…* number.
Syntax of FACT function
FACT(number)
The FACT function syntax has the following arguments:
- Number: The nonnegative number for which you want the factorial. If number is not an integer, it is truncated.
Example of FACT function
Steps to follow:
1. Open a new Excel worksheet.
2. Copy data in the following table below and paste it in cell A1
Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.
You can adjust the column widths to see all the data, if need be.
| Formula | Description | Result |
| =FACT(5) | Factorial of 5, or 1*2*3*4*5 | 120 |
| =FACT(1.9) | Factorial of the integer of 1.9 | 1 |
| =FACT(0) | Factorial of 0 | 1 |
| =FACT(-1) | Factorial of a negative number returns an error value | #NUM! |
| =FACT(1) | Factorial of 1 | 1 |