LOG

Returns the logarithm of a number given a base.

Sample usage

LOG(128,2)

LOG(A2,3)

Syntax

LOG(value, [base])

  • value - the value for which to calculate the logarithm given base.

    • value must be positive.
  • base - [10 by default] the base to use for calculation of the logarithm.

See also

SQRTPI: Returns the positive square root of the product of Pi and the given positive number.

SQRT: Returns the positive square root of a positive number.

POWER: Returns a number raised to a power.

LOG10: Returns the logarithm of a number, base 10.

LN: Returns the logarithm of a number, base e (Euler's number).

GAMMALN: Returns the logarithm of a specified gamma function, base e (Euler's number).

EXP: Returns Euler's number, e (~2.718) raised to a power.

Examples

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu