Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Maths and Trigonometry > LN

 

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.
     
  • 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.
     
  • This function is similar to the LOG() function although you do not have to specify the base.

     EXAMPLES
     
     A
    1=LN(86) = 4.454
    2=LN(2.7182818) = 1
    3=LN(EXP(3)) = 3
    4=EXP(LN(4)) = 4
    5=LN("some text") = #VALUE!
     

     Functions - L | Index - L | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top