Returns the factorial of a number. The factorial of a number is equal to 1*2*3*…* the number.
Syntax
FACT(number)
Number The non-negative number whose factorial is to be calculated. If the input Number is not an integer, it is truncated.
The main function of the FACT function is to calculate the factorial of a number.
The factorial of a positive integer n = the product of positive integers less than and equal to the number. That is, the factorial of n is equal to 1*2*3*...n.
It should be noted that the factorial of 0 is 1.
Next, I will show you the specific steps of using this function in this table.
![表.png 表.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/f55e5ca9c70885685eaeb83b871b0ddb.png)
![图文对齐图.png 图文对齐图.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/e1ea7da86ff61befb1c583b6784f105d.png)
■ Select cell B2 and click Insert Function.
Find and select the FACT function in the search box and click OK.
A dialog box will pop up with one parameter.
Number: The non-negative number whose factorial is to be calculated. If it is not an integer, it is truncated.
Select A2 to fill in and click OK to calculate the result.
Position the cursor to the lower right corner of cell B2 and pull down to fill the cell when it is in the shape of + to perform batch calculations.
You can see that the factorial result of 4.8 is the same as 4. This is because the decimal factorial calculation will be truncated, and the factorial of 0 is by definition 1.
![GIF1.gif GIF1.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/dcf82067257deda3da454387e330b8b2.gif)
评论列表(196条)
测试