Returns the factorial of a number.
Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.
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)Risultato: 6
Calculates 3 * 2 * 1, which equals 6.
=FACT(5)Risultato: 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.