Logarithm of a numeric value
Returns the computed logarithm of x with base b (or 10 if b is omitted).
Sample usage
LOG(3.14) returns 0.496929648073215 (equivalent to LOG(10, 3.14) or LOG10(3.14))
LOG(10) returns 1 (equivalent to LOG(10, 10) or LOG10(10))
LOG(100) returns 2 (equivalent to LOG(100, 10) or LOG10(100))
LOG(8, 2) returns 3 (equivalent to LOG2(8))
LOG(POWER(10, 6)) returns 6
POWER(10, LOG(7)) returns 7.00
Syntax
LOG(x, [base])
x- Any numeric type.base- (Optional) Any numeric type that specifies the exponent base. If omitted, defaults to10.
See also