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.
* You can use the LOG function to return the logarithm of a number to any base.
* You can use the LN function to return the natural logarithm of a number (to the base e).
* There is no equivalent VBA function.
* For the Microsoft documentation refer to support.office.com

 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(POWER(10,3.7)) = 3.7
8=POWER(10,LOG10(3.7)) = 3.7
9=LOG10(-10) = #NUM!
10=LOG10("some text") = #VALUE!

7 - What is the inverse of LOG10
8 - What is the inverse of LOG10

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