Excel FACT Function

What is FACT Function in Excel?

The FACT function is one of the math functions of Excel.

It Returns the factorial of a number, equal to 1*2*3*…* Number.

We can find this function in Math & trig category of insert function Tab.

How to use FACT function in excel

  1. Click on an empty cell (like F5 )
empty cell in excel

2. Click on fx icon (or press shift+F3)

 fx icon in excel

3. In the insert function tab you will see all functions

insert function tab in excel

4. Select math and trig category

5. Select FACT function

6. Then select ok

excel FACT function

7. In the function arguments Tab you will see FACT function

8. Number is the nonnegative number you want the factorial of

9. You will see results in the formula result section

How to use FACT function in excel

Examples of FACT function in Excel

Example 1:

How to use FACT function in excel

You can see examples of FACT function below:

Examples of FACT function in Excel
fact(5) ----->>>>answer is  120

fact(4) ----->>>>answer is  24

fact(3) ----->>>>answer is  6

fact(2) ----->>>>answer is  2

fact(1) ----->>>>answer is  1

What is the purpose of FACT function?

It Returns the factorial of a number, equal to 1*2*3*…* Number.

What is the Return value of FACT function?

It returns a number.

How many arguments does FACT function have?

This function has just 1 Argument.

The argument of FACT function is number.

Number is the nonnegative number you want the factorial of.

The argument of FACT function is required and not optional.

FACT(number) = number

Which version of excel supports FACT function?

This function is available for all excel versions (2003-2019)

Errors in FACT function

FACT related functions :

Leave a Reply

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