EXCEL FACT FUNCTION

This function calculates a number’s factorial. A number’s factorial is equal to 12*…* number. For instance, the factorial of 4 is 1 x2x3x4 = 24.

Syntax:

=FACT (number)

Parameter list:

number – the number for which the factorial is to be calculated.

Step By Step Guide of FACT Function

For Example :


=FACT(4) Factorial of four, or 12*3*4 equals 24.

=FACT(2.9) The number 2.9 has a factorial of 2.

  • If the number is negative, you will receive an error value.
  • The number will be shortened if it is not an integer.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now