이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
FACT(number)The FACT function calculates the factorial of a given non-negative integer. The factorial of a number is the product of all positive integers less than or equal to that number.
=FACT(3)결과: 6
Calculates 3 * 2 * 1, which equals 6.
=FACT(5)결과: 120
Calculates 5 * 4 * 3 * 2 * 1, which equals 120.
The FACT function will return a #NUM! error because factorials are not defined for negative integers.
If you provide a decimal, Excel will truncate it to the next lowest integer before calculating the factorial.