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:
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.
- This is the basic syntax of the Excel FACT Function.
- number – The input number to which you want to find factorial.
- 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.
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.
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.
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, and What is Factorial?.
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.
The following video will show you how to use the Excel FACT function in the spreadsheet with proper examples.
- 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?