Problem with Factorials

Adam Cunningham

unread,

Jul 31, 2003, 5:52:32 PM7/31/03

to

I am trying to put in a formula that includes factorials. I know the
function is FACT(x), but my x is 365 and the result is a #NUM error. Is
there a way around this, or can EXCEL just not handle it?

TIA,
Adam

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 80,000 Newsgroups - 16 Different Servers! =-----

BrianB

unread,

Aug 4, 2003, 7:20:43 AM8/4/03

to

I did a trial (XL97) and Excel seems to give up above 170.

Regards
BrianB
==================================================

"Adam Cunningham" <adcunn...@zoominternet.net> wrote in message news:<3f298fbd$1...@corp.newsgroups.com>...

Jiri Cihar

unread,

Aug 7, 2003, 9:51:34 AM8/7/03

to

Brian...@tiscali.co.uk (BrianB) wrote in message news:<158ff9b7.03080...@posting.google.com>...

******************************************************************************
You can try product called xlPrecision. It is "...an Add-In for
Microsoft Excel that provides vastly more precise results from
mathematical formulas than Excel provides on its own."

Just skip to site http://precisioncalc.com

hope it helps

Jiri Cihar
www.dataspectrum.cz

Greg Lovern

unread,

Aug 8, 2003, 1:59:21 PM8/8/03

to

Hi Adam,

Excel can't calculate factorials larger than 170! because it can't
recognize a number that large. 171! is approximately 1.241E309, a
couple digits too large for Excel.

Also, even though Excel can calculate factorials up to 170!, it can
only calculate them at *full precision* up to 20!. Anything larger is
rounded. That's because anything larger than 20! has more than Excel's
maximum of 15 signficant digits. For example, 21! is
51,090,942,171,709,440,000, which has 16 signficant digits.

xlPrecision in Excel can calculate factorials up to 9,273!, all at
full precision. The free edition of xlPrecision, since it is limited
to 150 signficant digits, can only calculate factorials at full
precision up to 96!; everything larger, up to 9,273!, is rounded to
150 signficant digits.

You can download the free edition of xlPrecision for Excel at:

http://www.PrecisionCalc.com

Thanks,

Greg Lovern
http://PrecisionCalc.com
Get Your Numbers Right

jci...@dataspectrum.cz (Jiri Cihar) wrote in message news:<c85fa1d3.03080...@posting.google.com>...

Harlan Grove

unread,

Aug 8, 2003, 4:38:19 PM8/8/03

to

"Adam Cunningham" wrote...

>I am trying to put in a formula that includes factorials. I know the
>function is FACT(x), but my x is 365 and the result is a #NUM error. Is
>there a way around this, or can EXCEL just not handle it?

What are you trying to do with these numbers? If you're working in
combinatorics, there are many techniques that eliminate the need to calculate
factorials. If you're working in number theory, all spreadsheets are very poor
tools - you should be using a symbolic math package like Mathematica.

Assuming it's combinatorics or probability, you could use GAMMALN for most
intermediaet calculations, and wrap results in EXP to get final results.

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.

Robert McCurdy

unread,

Aug 12, 2003, 1:34:57 PM8/12/03

to

A little late - but the Windows Calculator can do 365.

2.5104128675558732292929443748812e+778

Mine is found here > C:\WINDOWS\system32
its called calc.exe

I tried to find its limit for factorials and stopped after 5,000
which returned this...

4.2285779266055435222010642002336e+16325

Regards Robert

"BrianB" <Brian...@tiscali.co.uk> wrote in message
news:158ff9b7.03080...@posting.google.com...