# LOG10 function in Excel

> LOG10 returns the base-10 logarithm of a number: how many times 10 is multiplied to reach it.

Source: https://spreadsheetpractice.com/functions/log10 · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** LOG10 returns the base-10 logarithm of a number: how many times 10 is multiplied to reach it.
- **Syntax:** `=LOG10(number)`
- **Most common use:** `=LOG10(B2)` returns 3 (1,000 is 10 to the 3rd: 3)
- **Available in:** Every current version
- **Category:** [Math functions](https://spreadsheetpractice.com/functions/category/math)
- **Returns:** The base-10 logarithm.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

LOG10 returns the base-10 logarithm of a number: how many times 10 is multiplied to reach it. It measures orders of magnitude, counts digits, and underlies scales such as decibels and pH.

## Syntax

`=LOG10(number)`

| Argument | Required? | What it is |
|---|---|---|
| `number` | Required | A positive number. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=LOG10(B2)` | 3 | 1,000 is 10 to the 3rd: 3 |
| D3 | `=LOG10(B3)` | -2 | Numbers below 1 give negative logs: -2 |
| D4 | `=INT(LOG10(B4))+1` | 5 | Counts the digits in a whole number: 5 |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Input | Value |  |  |
| 2 | Revenue | 1000 |  | 3 |
| 3 | Concentration | 0.01 |  | -2 |
| 4 | Customer ID | 54321 |  | 5 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| #NUM! | The number is zero or negative. Check for blanks and negative values first. |
| Needed another base | LOG10 is fixed at base 10. Use LOG(number, base) for any other base, or LN for base e. |

## Tips

- Undo LOG10 with a power of 10: =10^A2.
- Decibels from a power ratio: =10*LOG10(Output/Input).

## Related functions

- [LOG](https://spreadsheetpractice.com/functions/log): LOG returns the logarithm of a number in the base you choose: the power the base must be raised to in order to reach the number.
- [LN](https://spreadsheetpractice.com/functions/ln): LN returns the natural logarithm of a number: the power you would raise e to in order to get it.
- [POWER](https://spreadsheetpractice.com/functions/power): POWER raises a number to a power, the same as the ^ operator.

## Questions

### Is LOG10 the same as LOG in Excel?

Yes, when LOG has no base argument: =LOG(A2) and =LOG10(A2) both use base 10.

### How do I reverse LOG10?

Raise 10 to the result: =10^A2.

## Practice

A graded LOG10 exercise ("Amplifier gain in decibels") is on [the LOG10 page](https://spreadsheetpractice.com/functions/log10). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
