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). |