Microsoft Excel offers plenty of formulas and functions for performing various mathematical calculations. The Excel Fact function returns the **factorial of a given input number**. Factorial is nothing but the product of all the positive integers less than or equal to a given positive integer. It is one of the **built-in functions** in Excel.

This tutorial will guide you to learn how to use **Excel FACT Function** with its syntax, explanation, and examples. Get an official version of** MS Excel** from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Jump To

## What is the FACT Function?

As we said earlier, the FACT function will find out the factorial of the given number. This function is categorized as “**Math**” in Excel.

### 1) Syntax

- This is the basic syntax of the Excel FACT Function.

**=FACT(number)**

### 2) Arguments

**number –**The input number to which you want to find factorial.

### 3) Motive

- This function will find the factorial of a given number.

### 4) Return Value

- It
**returns**the**factorial of a given number**.

## What Will FACT Function Do?

Whenever you want to **find the factorial of the given numbers** on your spreadsheet, we suggest you use the Excel FACT function. Let’s see an example scenario to make you understand it easily.

Step 1: For instance, we have listed a **set of odd and even numbers** in the **range B3:B10**. And we want to find out the factorial of each value in the list using the FACT function.

Step 2: To get the factorial value, we need to **apply **the **following formula** in any cell where we want to get the result.

**=FACT(B3)**

Step 3: Now, **click **on the **Enter **button to get the result.

Step 4: To fill down the remaining cells, you just drag down the first cell. It will **auto-fill the remaining cells** as shown in the below screenshot.

We hope that the given scenario helped you to understand the FACT function. Move to the below section if you have any confusion regarding using this function on your spreadsheet. You will find out simpler examples.

## Use FACT Function with Different Inputs

Let’s see how to use the FACT function in the worksheet with different inputs. In the above section, we have seen how to use it with integers. Here we will use **find out the factorial of decimal numbers**.

**1)** In the following screenshot, we have given a **set of** **decimal values and also the value zero**. We will need to get the factorial value of those values using the FACT function.

2) In order to get the corresponding results, we need to **apply the following formula**.

**=FACT(B3)**

**3)** **Hit **the **Enter **button to get the result, as shown in the below image.

**4)** To fill down the remaining cells, you just need to **drag down the first cell**. Excel will autofill the remaining cells with the FACT function.

By doing so, you can quickly get the factorial values on your spreadsheet.

## Inputs that cause Error

- If you give a negative number, this function will return the
**#NUM!**Error value. - The following image has shown the
**#NUM!**Error because of its negative input integer value.

## Citations

To understand the usage of the FACT function, we have referred to the following articles. They helped us to know the purpose of this function. You can also check them out using the links: FACT function** ^{[1]}**, and What is Factorial?

**.**

^{[2]}## Verdict

With the help of the given scenarios and examples, you can easily understand the **purpose of the FACT function** **in Excel** and how to apply it in the spreadsheet. The screenshots help to learn it even easier. Drop your **feedback **in the below comment section. Thanks for visiting **AawExcel**. Keep Learning!!

If you want to know what people think about this FACT Function of Excel, then we suggest you look for it on the Quora interaction webpage. From there you can get to know more about the Excel FACT function. Here, we have provided the link to Quora’s official website.

## Video Tutorial

The following video will show you how to use the Excel FACT function in the spreadsheet with proper examples.

**Read Ahead:**

- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?