# 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.* 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 VBA.LOG (which is very confusing).* For the Microsoft documentation refer to support.microsoft.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!