ExcelFunctions.net Logo

The Excel FACTDOUBLE Function

Home » Excel-Built-In-Functions » Excel-Math-Functions » Excel-Factdouble-Function

Search this site:
Custom Search
Related Function :
Factorial

The Double Factorial of a number, N, is given by the following :

If N is even :

N * (N-2) * (N-4) * ... * 4 * 2

If N is odd :

N * (N-2) * (N-4) * ... * 3 * 1

More information can be found on the Wikipedia Factorial page

Basic Description

The Excel FACTDOUBLE function returns the double factorial of a supplied number

The format of the function is :

FACTDOUBLE( number )

where the number argument is the positive integer that you want to calculate the double factorial of.


Examples

Cells A1-A3 of the following spreadsheet shows examples of the Excel Factdouble function being used to calculate the double factorial of different integers. The format of the functions is shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

 Formulas:
Examples of use of the Excel Factdouble Function
 Results:
Excel Factdouble Function Results

Further examples of the Excel Factdouble function can be found on the Microsoft Office website.


Trouble Shooting

If you get an error from the Excel Factdouble function this is likely to be one of the following :

Common Errors
#NUM! - Occurs if the supplied number argument is < 0
#VALUE! - Occurs if the supplied number argument is not recognised as a numeric value





Valid XHTML 1.0 Transitional

Disclaimer Privacy Policy

Copyright © 2008-2011 ExcelFunctions.net