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, [b])

  • x - Any numeric type.
  • b - (Optional) Any numeric type that specifies the exponent base. If omitted, defaults to 10.

See also

LN()

LOG2() 

LOG10()

POWER()

SQRT()

 

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false