LOG

Calculates the logarithm of a number using a specified base to support mathematical and analytical computations.

The LOG function returns the logarithm of a number using a specified base. It calculates the exponent to which the base must be raised to produce the given number. This function is commonly used in mathematical, financial, and scientific calculations involving exponential relationships or scale transformations.

Syntax

LOG(value, base)

Arguments

value - The positive real number for which you want the logarithm (Required).

base - The base of the logarithm (Required).

Example

LOG(COLUMN1, 10)

In the example below, the Log Values measure is created using the LOG function, which returns the logarithm of the values in MEASURE 3 to the base 10.

Applying LOG Function

Excel equivalent

LOG