Microsoft Office Tutorials and References
In Depth Information
FACTDOUBLE
Figure 10.14
Calculate the sum of a
series of factorials with
this array.
FACTDOUBLE
The FACTDOUBLE function returns the double factorial of a number.
=FACTDOUBLE(number)
This function is available from the Analysis ToolPak add-in and can be accessed using the
Tools, Add-Ins command. Check the box for that add-in. If it is not on the add-in list, run
Setup to install it. The NUMBER argument is the value for which to return the double factorial.
If number is not an integer, it is truncated. If the number is even, this function returns the
product of values from 1 to number that are even. If the number is odd, this function returns
the product of values from 1 to number that are odd. The FACTDOUBLE function returns an
error value if the NUMBER argument is not a positive number.
NUMBER The value you want the double factorial for. The number is
truncated if not an integer.
For example: FACTDOUBLE(11) equals 10395 .
FLOOR
The FLOOR function returns a number rounded down, toward zero, to the nearest multiple of
significance.
=FLOOR(number,significance)
The NUMBER argument is the value you want to round, and the SIGNIFICANCE argument is the
multiple to which you want to round. For NUMBER arguments that are negative, use a NEGATIVE
SIGNIFICANCE argument. Other wise, FLOOR returns an error value. If a nonnumeric entr y is
made for either argument, FLOOR returns an error value. The FLOOR function can be used to
Search JabSto ::

Custom Search