LN

LN(number)

Returns the natural logarithm of a number.

number

The number you want the natural logarithm of.

REMARKS

* The natural logarithm of a number is the inverse of the EXP function.
* Natural logarithms are based on the constant e (2.71828182845904).
* If "number" is not numeric, then #VALUE! is returned.
* A logarithm is an exponent used in calculations to show the perceived levels of variable quantities.
* This function can be used in problems that calculate exponential growth.
* This function can be used to estimate population growth over a period of time.
* You can use the LOG function to return the logarithm of a number to any base.
* You can use the LOG10 function to return the logarithm of a number to the base 10.
* You can use the IMLN function to return the natural logarithm of a complex number.
* The equivalent VBA function is VBA.LOG (which is very confusing).
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=LN(0.36788) = -1
2	=LN(1) = 0.00
3	=LN(2) = 0.69
4	=LN(2.7182818) = 1
5	=LN(3) = 1.10
6	=LN(4) = 1.39
7	=LN(7.3891) = 2
8	=LN(EXP(3)) = 3
9	=EXP(LN(4)) = 4
10	=LN(1) = LOG(1,EXP(1))
11	=LN(2) = LOG(2,EXP(2))
12	=LN(3) = LOG(3,EXP(3))
13	=LN(-4) = #NUM!
14	=LN("some text") = #VALUE!