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
5789080158599518079
true
Search Help Center
true
true
true
false
false
false
false
Create a Mobile Website
View Site in Mobile | Classic
Share by: