Signature (Visual Basic / VBA)
Public Function Factorial( _
ByVal vX As Variant _
) As Variant
Code Example
IsNull(Factorial(-1)) = True
Factorial(0) = 1
Factorial(1) = 1
Factorial(2) = 2
Factorial(3) = 6
Factorial(4) = 24
Factorial(5) = 120
Factorial(67) = 3.64711109181887E+94
Factorial(170) = 7.257415615308E+306
IsNull(Factorial(171)) = True
Parameters
| Parameter | Description |
|---|---|
| vX | The number whose factorial will be returned as a Double (precision floating-point) numeric value. Function returns Null if vX is Null, cannot be interpreted as a number, or is not between 0 (zero) and 170 (the result would be greater than MaxDouble ). vX is rounded down to the nearest integer. |
Notes & Version History
| Note | This function will not generate the factorial of a floating point number; it will ignore the fractional part of any floating point numbers by applying the Visual Basic Fix function to the number. |
| v1.5 Pro Note | The argument names and the implementation of this function has changed. |