Function Math Trig Complex Class

LogBaseN

" Logarithm Base N" Log base Y of X for a real or complex number.

Signature (Visual Basic / VBA)

Public Function LogBaseN( _
      ByVal vX As Variant _
    , ByVal vY As Variant _
    ) As Variant

Code Examples

    LogBaseN(3, 10) = 0.477121254719662
    LogBaseN(3, e) = 1.09861228866811
    LogBaseN("2.3|-4.5", 30) = "0.476338989920794|-0.322915511225372"
    LogBaseN("2.3|-4.5", "2|3") = "0.382423731894415|-1.1494519611595"
    Logarithm(X) / Logarithm(Y)

Parameters

Parameter Description
vX Number whose logarithm is 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.
vY The base of the logarithm. Function returns Null if vY is Null or cannot be fixed up to a real or complex number.