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

 

LOG10(number)

 
 Returns the logarithm of a number to the base 10.

 numberThe number you want the base-10 logarithm of.

 REMARKS
 
  • If "number" < 0, then #NUM! is returned.
     
  • If "number" is not an integer, it is truncated.
     
  • If "number" is not numeric, then #VALUE! is returned.

     EXAMPLES
     
     A
    1=LOG10(86) = 1.934
    2=LOG10(10) = 1
    3=LOG10(100000) = 5
    4=LOG10(10*10) = 2
    5=LOG10(10^5) = 5
    6=LOG10(10.9) = 1
    7=LOG10(-10) = #NUM!
    8=LOG10("some text") = #VALUE!
     

     Functions - L | Index - L | Office Online 

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