LOG10 function
LOG10 returns the base-10 logarithm of a number, meaning the power of 10 that equals it. It is handy for orders of magnitude, and zero or negative input returns #NUM!.
Example
Read it as a sentence: find the base 10 log of 1000, which gives 3.
A
B
C
D
1
3
2
3
Syntax
LOG10(number)
-
number(required) - A positive number.
Returns: The base-10 logarithm.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=LOG10(0.5) | -0.301029996 | Positive |
=LOG10(2) | 0.301029996 | Larger value |
=LOG10("0.5") | -0.301029996 | Text number "0.5" |
=LOG10(TRUE) | 0 | TRUE |
=LOG10({0.1,0.2}) | -1 | Array constant spills |
=LOG10(100) | 2 | 100 |
=LOG10(0) | #NUM! | Zero |
=LOG10(-0.5) | #NUM! | Negative |
Watch out for
- Zero or negative input returns #NUM!.
Where it works
- Excel
- LOG10 is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .