Log Function

Returns the natural logarithm of a number.

Syntax

Log(number)

Remarks

The argument number can be any valid numeric expression that results in a value greater than 0.  The natural logarithm is the logarithm to the base e.  The constant e is approximately 2.718282.

You can calculate base-n logarithms for any number x by dividing the natural logarithm of x by the natural logarithm of n as follows:

Logn(x) = Log(x) / Log(n)

The following example illustrates a Function procedure that calculates base-10 logarithms:

Static Function Log10(X)

Log10 = Log(X) / Log(10#)

End Function

Exp Function

Math Functions

Derived Math Functions

Log Function Example

The example calculates the value of e, then uses the Log function to calculate the natural logarithm of e to the first, second, and third powers.  To try this example, paste the code into the Declarations section of a form.  Then press F5 and click the form.

Sub Form_Click ()

Dim I, Msg, NL                        ' Declare variables.

NL = Chr(13) & Chr(10)                ' Define newline.

Msg = Exp(1) & NL

For I = 1 To 3                        ' Do three times.

Msg = Msg & Log(Exp(1) ^ I) & NL

Next I

MsgBox Msg                            ' Display message.

End Sub