Formula and Syntax FACT Formula: FACT (number) Syntax: Number: the non-negative number for which you want the factorial. If the number is not an integer, it is truncated. It is required. FACTDOUBLE Formula: FACTDOUBLE (number) Syntax: The value for which to return the double factorial. If the number is not an integer, it is truncated. It is required.
Follow the steps below on how to use the FACT or FACTDOUBLE in Microsoft Excel.
How to use the FACT function in Excel
Launch Microsoft Excel.Enter your data or use existing data.Type into the cell where you want to place the result = FACT(A2)Press Enter to see the result. The result was 120.Now drag the fill handle down to see the other results.In the results, you will see that the value of a negative number will give the error #NUM.
There are two other methods to use the FACT function. Method one is to click the fx button on the top left of the Excel worksheet. An Insert Function dialog box will appear.
Inside the dialog box, in the section Select a Category, select Math and Trigonometry from the list box. In the section Select a Function, choose the FACT function from the list. Then click OK.
A Function Arguments dialog box will open. Type into the entry box the cell that you want to convert. Then click OK.
Method two is to click the Formulas tab and click the Math and Trigonometry button in the Function Library group. Then select FACT from the drop-down menu. A Function Arguments dialog box will open. Follow the same method in Method 1. Then click OK.
How to use the FACTDOUBLE function in Excel
Launch Microsoft Excel.Enter your data or use existing data.Type into the cell where you want to place the result = FACTDOUBLE(A2)Press Enter to see the result. The result was 105.For 7, an odd number, the double factorial number is equivalent to 753.For 6, an even number, the double factorial number is equivalent to 642.
Like the Fact function, there are two other methods to use the FACTDOUBLE function. Method one is to click the fx button on the top left of the Excel worksheet. An Insert Function dialog box will appear.
Inside the dialog box, in the section Select a Category, select Math and Trigonometry from the list box. In the section Select a Function, choose the FACTDOUBLE function from the list. Then click OK. A Function Arguments dialog box will open. Type into the entry box the cell that you want to convert. Then click OK.
Method two is to click the Formulas tab and click the Math and Trigonometry button in the Function Library group. Then select FACTDOUBLE from the drop-down menu. A Function Arguments dialog box will open. Follow the same method in Method 1. Then click OK. We hope you understand how to use the FACT or FACTDOUBLE function in Excel.
What are the types of information that Excel uses?
In Microsoft Excel, there are 4 types of data. These are: READ: How to use the MINVERSE and MMULT functions in Excel
How do I check if a cell contains a formula in Excel?
Follow the steps below to find cells that contain formulas: READ: How to use the TEXTSPLIT function in Excel.
