Function Math Reals Class

LogNReal

"Log Base N Of Real Number" Return the base Y logarithm of X, where both arguments are real numbers.

Signature (Visual Basic / VBA)

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

Code Examples

    LogNReal(0, 10) = 0
    LogNReal(10, 10) = 1
    LogNReal(12, 10) = 1.07918124604762
    LogNReal(16, 10) = 1.20411998265592
    LogNReal(167, 10) = 2.22271647114758
    Log(X) / Log(Y)

Parameters

Parameter Description
vX The number whose base vY logarithm is to be returned. Function returns Null if vX is Null or cannot be fixed up to a number.
vY The logarithm base. Function returns Null if vY is Null or cannot be fixed up to a number.

Notes & Version History

v1.5 BugFix Corrected the LogNReal(0, 10) example above to show the correct result.
Note The LogBaseN function supports both real AND complex numbers.
Note Function generates an "Invalid Procedure Call" error if either argument is < 0 (less than zero).