factorial

[oshiroty]

Hello. Is there a way to compute factorials in Excel? Thank you

 

[Max]

Think there's a function FACT() which will calculate this

Check it up in Excel's Help

Example: FACT(5) = 120 (1*2*3*4*5)

(there's even a FACTDOUBLE function .. <g>)

 

[BenjieLop]

=fact(number)

Hello. Is there a way to compute factorials in Excel? Thank you

 

[Jerry W. Lewis]

As others have noted, Excel has a FACT() function. 171! is larger than
the largest floating point number that can be represented in IEEE double
precsion (used by Excel).
GAMMALN(n+1) = LN(FACT(n))
which can be used for n larger than 170.

Jerry