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

LOG(number [,base])

 
 Returns the logarithm of a number to the base you specify.

 numberThe number you want the logarithm of.
 baseThe base of the logarithm.

 REMARKS
 
  		• If "number" < 0, then #NUM! is returned.
     
  		• If "number" is not an integer, it is truncated.
     
  		• If "base" is left blank, then 10 is used.
     
  		• If any of the arguments are not numeric, then #VALUE! is returned.

     EXAMPLES
     
     A
    1=LOG(12) = 1.079
    2=LOG(10) = 1
    3=LOG(10.9) = 1
    4=LOG(8,2) = 3
    5=LOG(16,2) = 4
    6=LOG(86,2.7182818) = 4.454
    7=LOG(-16,2) = #NUM!
    8=LOG("some text") = #VALUE!
    9=LOG(12,"some text") = #VALUE!
    		 
     Functions - L | Index - L | Office Online 

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