LN function
LN returns the natural logarithm of a number, the power e must be raised to in order to get it. It is used in growth rates and log-transformed data.
Example
Read it as a sentence: find the natural log of 10, which gives 2.30258509299405.
A
B
C
D
1
2.30258509299405
2
3
Syntax
LN(number)
-
number(required) - A positive number.
Returns: The natural logarithm (base e).
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=LN(0.5) | -0.693147181 | Positive |
=LN(2) | 0.693147181 | Larger value |
=LN("0.5") | -0.693147181 | Text number "0.5" |
=LN(TRUE) | 0 | TRUE |
=LN({0.1,0.2}) | -2.302585093 | Array constant spills |
=LN(1) | 0 | 1 |
=LN(0) | #NUM! | Zero |
=LN(-0.5) | #NUM! | Negative |
Watch out for
- Zero or negative input returns #NUM!.
- The inverse is EXP.
Where it works
- Excel
- LN is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .