Microsoft Office Tutorials and References
In Depth Information
Syntax
Note
It is difficult to find real-world uses for FACTDOUBLE.
MathWorld.com notes some interesting uses for FACTDOUBLE (N)
where N is between 1 and 2, but Excel does not calculate
FACTDOUBLE for negative numbers. Fans of the poker game Texas
Hold Em will be delighted to know that FACTDOUBLE is useful
in calculating Texas Hold Em probabilities. For complete details,
look up Poker Probabilities (Texas Hold Em) in Wikipedia. Round-
robin sporting tournaments can also use FACTDOUBLE.
By definition, FACT(0) is 1. To figure out how many different ways you can
arrange five people in a line, use =FACT(5).
There is a similar function called FACTDOUBLE. A double factorial mul-
tiplies every other number. For even numbers, this is a calculation such
as FACTDOUBLE(8) = 8*6*4*2. For odd numbers, the calculation is
FACTDOUBLE(9) = 9*7*5*3*1.
Various factorials are shown in Figure 11.27 .
Figure 11.27.
Figure 11.27. Excel calculates the
Excel calculates the FACT
FACT and
and FACTDOUBLE
FACTDOUBLE of various num-
of various num-
bers.     Search JabSto ::

Custom Search