Microsoft KB Archive/46508

Excel: Factorial of 171 or Greater Returns #NUM! Error PSS ID Number: Q46508 Article last modified on 02-03-1993 PSS database name: M_eXceL

1.x 2.20 3.00 4.00

MACINTOSH

Summary:

When the FACT function is used to calculate factorials of more than 170 in Microsoft Excel, the #NUM! error message is displayed.

Values greater than FACT(170) are higher than the greatest number that the Macintosh can calculate. The #NUM! error is returned to indicate that the number produced is too large to be calculated on the Macintosh.

Additional reference words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.2 2.20 3.0 3.00 4.0 4.00

Copyright Microsoft Corporation 1993.