LOG()

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 to 10.

See also

LN()

LOG2()

LOG10()

POWER()

SQRT()