LN()
Syntax. LN(number)
Definition. This function returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904).
Argument
number (required) The positive real number for which you want the natural logarithm
Background. For the equation b = ax where a and b are known, you can calculate x by using logarithmic calculus:
x = logab
Here is another example:
2 = log3 9
As the logarithm of base a, value x is indicated with b. The logarithm system includes all logarithms with the same base. The base can be any positive number except zero and 1. The logarithm with base 2 is shortened to lb.
In natural science, Euler’s number e (2.71828182845904) is often used as a base. You can find more information on Euler’s number ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.