M Max Sep 30, 2004 #2 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>)
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>)
B BenjieLop Sep 30, 2004 #3 =fact(number) Hello. Is there a way to compute factorials in Excel? Thank you Click to expand...
J Jerry W. Lewis Oct 1, 2004 #4 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
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
