What is the value of 2 factorials

TWO FACULTY function

This article discusses the formula syntax and usage of theTWO FACULTY described in Microsoft Excel.

description

Returns the factorial of number with step length 2.

syntax

TWO FACULTY (number)

The TWO FACT function syntax has the following arguments:

  • number Required. The value for which the factorial with step length 2 is to be calculated. If "number" is not a whole number, the decimal places are cut off.

Hints

  • If number is not a numeric value, FACTDOUBLE returns the value #VALUE! Error value.

  • If number is negative, FACTDOUBLE returns the value #NUM! Error value.

  • If number is even, the equation is:

  • If number is odd, the equation is:

example

Copy and paste the sample data in the following table into cell A1 of a new Excel worksheet. To see the results of the formulas, highlight them, press F2, and then press ENTER. If necessary, you can adjust the width of the columns so that all data is displayed.

formula

description

Result

= TWO FACULTY (6)

Faculty with step length 2 of 6. If 6, an even number, the factorial with step length 2 is 6 * 4 * 2 using the following equation:

n !! = n * (n-2) * (n-4) ... (4) (2)

48

= TWO FACULTY (7)

Faculty with stride 2 of 7. If 7, an odd number, the factorial with stride 2 equals 7 * 5 * 3 using the following equation:

n !! = n * (n-2) * (n-4) ... (3) (1)

105