Google Sheets
LOG function in Google Sheets
Returns the the logarithm of a number given a base.
=LOG(value, [base])LOG syntax and parameters
Two arguments, one required.
- valuenumberRequired
The value for which to calculate the logarithm given base. value must be positive.
- basenumberOptional
[10 by default] The base to use for calculation of the logarithm.
LOG examples
Formulas you'll actually reuse.
How many halvings — a base-2 logarithm:
=LOG(B2, 2)Result
10Base 10 when no base is given — orders of magnitude:
=LOG(B2)Result
5
LOG in Excel
Same name — your formula ports as-is.
Try LOG in the playground
Edit the example — nothing to install.
Preloaded with the LOG formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- ABSReturns the absolute value of a number.MathExcel
- ACOSReturns the inverse cosine of a value, in radians.MathExcel
- ACOSHReturns the inverse hyperbolic cosine of a number.MathExcel
- ACOTReturns the inverse cotangent of a value, in radians. .MathExcel
- ACOTHReturns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive..MathExcel
- ASINReturns the inverse sine of a value, in radians.MathExcel