FACT takes just one argument, number, which should be a positive integer. If number is not an integer, the decimal portion of number will be removed before the factorial is calculated.
Examples
If number is not an integer it will be truncated to an integer: When number is zero, FACT returns 1: If number is negative, FACT returns the #NUM! error:
Notes
Number cannot be negative or FACT will return the #NUM error. If number is not an integer it will be truncated to an integer, then solved.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
