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()

 

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
11005370947477195163
true
Search Help Center
true
true
true
false
false