Function Math Complex Class

FibonacciComplex

"Nth Fibonacci Number" Returns the Nth Fibonacci number where N can be a floating-point or complex number.

Signature (Visual Basic / VBA)

Public Function FibonacciComplex( _
    ByVal vN As Variant _
    ) As Variant

Code Example

    FibonacciComplex(-3.4) = 0.796755929818655
    FibonacciComplex(0) = 0
    FibonacciComplex(1) = 1
    FibonacciComplex(1.1) = 1.00979470693411
    FibonacciComplex(2) = 1
    FibonacciComplex(5) = 5
    FibonacciComplex(5.5) = 6.30880376931698
    FibonacciComplex(6) = 8
    FibonacciComplex(7) = 13
    FibonacciComplex("1.2|-3.4") = "-3493.97051990013|4201.2619580333"

Notes & Version History

vX The number whose Nth Fibonacci number is to be returned. Function returns Null if vX is Null or cannot be fixed up to a real or complex number (as defined by the ComplexStringToReals function). Complex numbers are represented within strings as "R|I" where R is the real part and I is the imaginary part.