Returns the factorial of a number.
פונקציה זו פועלת ב-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.