How do you take the factorial of a number: k!

Philosophaie · Jul 11th 2016

How do you take the factorial of a number in VBA: k!.

**mikerickson** · Jul 11th 2016

Re: How do you take the factorial of a number: k!

You could use WorksheetFunction.Fact

Or you could write a UDF

Code

Function Factorial(N as Long) as Double
    If N<=1 Then
        Factorial = 1
    Else
        Factorial = N * Factorial(N-1)
    End If
End Function

The worksheet function is faster.

How do you take the factorial of a number: k!

Participate now!

Share