Google Sheets
LN function in Google Sheets
Returns the the logarithm of a number, base e (Euler's number).
=LN(value)LN syntax and parameters
One argument, one required.
- valuenumberRequired
The value for which to calculate the logarithm, base e. value must be positive.
LN examples
Formulas you'll actually reuse.
The continuous growth rate from start value, end value, and years:
=LN(C2 / B2) / D2Result
0.0488Years to double at rate B2:
=LN(2) / LN(1 + B2)Result
14.21
LN in Excel
Same name — your formula ports as-is.
Try LN in the playground
Edit the example — nothing to install.
Preloaded with the LN formula from Example 1 — change anything and watch it respond.
Loading the editor…
LN errors
What they mean — and the fixes.
#NUM!The number is zero or negative — LN is only defined for positive values.
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