# How do I work with natural logarithms in Excel?

Mar 26, 2015

There are two functions in Excel:
LN($a$) which returns the log to base $e$ of $a$
and
EXP($b$) which returns ${e}^{b}$

For example, if you enter
=ln(exp(7))
in a cell, the contents of the cell will be displayed as
7

If you enter (in some cell other than B24)
=ln(B24)
the contents of that cell will display
the natural logarithm of whatever value was in cell B24
(assuming B24 contained a value $\ge 0$).