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)
Related content
Math and Trig functions EXP function LOG function LOG function