LOG

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 to calculate the logarithm.
• base: The base of the logarithm.

Return value

Returns the logarithm of the specified value for the given base.

Example

LOG(Sales, 10)

In this example, the LOG function is used to create the Log_Sales measure, which returns the logarithm of the values in the Sales measure using base 10.

Excel equivalent

LOG