Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
LOG10
LOG10 computes the base-10 logarithm of a positive number, equivalent to LOG(number, 10). It is a shorthand convenience function used in scientific, engineering, and financial calculations where powers of 10 are natural units.
Excel
=LOG10(A2)Google Sheets
=LOG10(A2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Measurement | Log10 |
| 1 | |
| 10 | |
| 100 | |
| 1000 |
=LOG10(A2)→0
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1A2 must be a positive number (e.g. 1000).
- 2LOG10(1000) returns 3 because 10^3 = 1000.
- 3LOG10(1) always returns 0; values between 0 and 1 return negative results.
Need a version for your data?
Try: “Get the base-10 log of my measurement values for a log scale chart”