Question

How do I work with natural logarithms in Excel?

Answer 1

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 `>= 0`).