LN(number)

Returns the natural logarithm of a number.

numberThe 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.
* 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.
* 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.
* The equivalent VBA function is LOG (which is very confusing).
* For the Microsoft documentation refer to support.office.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!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top