LOG10 Function in Google Sheets: Examples, Pitfalls & Compatibility
LOG10 in Google Sheets: calculate a base-10 logarithm for positive inputs without an optional-base argument. Includes worked examples and application-specific cautions.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Google Sheets. How formula examples are checked
Quick answer: Use LOG10 in Google Sheets to calculate a base-10 logarithm for positive inputs without an optional-base argument. The official LOG10 reference is the source for the function definition and platform-specific rules described below.
Syntax and arguments
=LOG10(value)
value (required): A strictly positive real number whose base-10 exponent is required.
Examples use English function names, comma argument separators and decimal points. Adapt formula separators to your workbook settings, not punctuation inside quoted text.
When to use it
Use LOG10 for decimal orders of magnitude or a model explicitly defined with base 10. Use LN for a natural logarithm. Do not confuse a logarithm with rounding a number to a certain number of significant figures.
Three worked examples
Each example is independent. Where input cells are listed, enter those values first; otherwise the formula is self-contained. Expected outputs are independently checked calculations or documented error expectations, not captured results from Google Sheets.
Example 1: Read a power of ten
=LOG10(10000)
Expected result: 4.
Four factors of 10 produce 10000.
Example 2: Read a small positive fraction
=LOG10(0.0001)
Expected result: -4.
The result is negative because the positive input is less than one.
Example 3: Compare a ratio on a decimal scale
=LOG10(500/5)
Expected result: 2.
The ratio is 100, corresponding to two base-10 orders of magnitude. The compared quantities must have compatible units.
Put it to work safely
Keep the original value beside its logarithm and state the base in the column heading. Test powers of ten, a positive fraction and a non-power value before analysing a larger series. A ratio-based comparison can be easier to interpret than the logarithm of a dimensioned quantity; whatever model is chosen should have a clear meaning.
Common mistakes and fixes
A small positive value has a negative answer. That is correct for values strictly between zero and one. The input is still inside the positive-real domain.
A zero or negative input is present. This real-valued logarithm is not defined for those inputs. Flag them rather than silently changing the input.
A noninteger output is mistaken for a digit count. LOG10 returns an exponent. A whole-number digit-count rule needs additional conditions and is not the same operation.
Google Sheets-specific notes
Google defines LOG10 as equivalent in purpose to LOG with base 10. Statements about this real-valued function should not be generalized into a claim that Sheets lacks separate complex-number functions. See the vendor reference for the current definition.
Excel and Google Sheets comparison
The documented base and positive-real domain align. The six-decimal example is an independently calculated expectation, not evidence of identical internal precision or error coercion.
Compare the LOG10 guide for Microsoft Excel and its official documentation. Having a guide in both libraries establishes two documented references, not a certificate of identical behavior across releases, locales or file conversions.
Related guides
LOG, LN, POWER, ROUND · All Google Sheets functions.
Evidence and testing scope
Editorial verification: Official references retrieved on 2026-10-12. The three worked cases are included in this release’s reproducible Python checking suite. It checks the stated arithmetic, calendar or text model and the expected documented error classification; it is not the Google Sheets calculation engine. No native application run, UI screenshot, maximum-size benchmark or cross-version certification is claimed. Review the editorial testing standards before relying on a formula in a critical workbook.