How to use the Excel FACT function

Excel Fact function is used to returns the factorial of given positive number. The Fact function in Excel is located in the Math & Trig category. The factorial of a positive number is equal to 1*2*3*…. number. If you need to quickly calculate factorial of any large number then you can use Excel Fact function in active worksheet. In this article we have to describe the formula and how to use Excel Fact function.

The Microsoft Excel Fact function allows you to quickly returns the factorial of any positive number. Fact is an important built-in function which is located in the Math & Trig category. This function can be used just like a worksheet (WS) function. You can use Fact function to get the factorial either directly fill the number or use cell address in active worksheet.

Syntax: =FACT(number)

The FACT function syntax has the following arguments:

  • Number (Required): The nonnegative number for which you want the factorial. If number is not an integer, it is truncated.

Example: Let’s look at some Excel FACT function examples and explore how to use the FACT function as a worksheet function in Microsoft Excel:

Excel FACT function - How to use the Excel FACT function

Syntax:  =FACT(H116)

Result:

Excel FACT function 1 - How to use the Excel FACT function

Based on the Excel spreadsheet above, the following FACT examples would return:

Syntax: =FACT(H117)
Result: 2

Syntax: =FACT(H118)
Result: 6

Syntax: =FACT(H119)
Result: 24

Syntax: =FACT(H120)
Result: 120

Syntax: =FACT(H121)
Result: 720

Syntax: =FACT(H122)
Result: 5040

Note:

  • The number cannot be negative or FACT will return the #NUM error.
  • If the number is not an integer it will be truncated to an integer, then solved.

Add a Comment

Your email address will not be published. Required fields are marked *