LOG

Applies to: Calculated column Calculated table Measure Visual calculation

Returns the logarithm of a number to the base you specify.

Syntax

LOG(<number>,<base>)  

Parameters

Term Definition
number The positive number for which you want the logarithm.
base The base of the logarithm. If omitted, the base is 10.

Return value

A decimal number.

Remarks

You might receive an error if the value is too large to be displayed.

The function LOG10 is similar, but always returns the common logarithm, meaning the logarithm for the base 10.

Example

The following formulas return the same result, 2.

= LOG(100,10)  
= LOG(100)  
= LOG10(100)  

Math and Trig functions
EXP function
LOG function
LOG function