LOG10 Function
Returns the base-10 logarithm of a number.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A number
Want to practice LOG10 in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
LOG10 tells you the power of 10 that gives a number: LOG10(1000) is 3.
It's a quick way to find the order of magnitude, or to count the digits in a whole number.
Syntax
=LOG10(number) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | A positive number. |
Examples
Example 1 — Digits in a number
How many digits does each order number have?
B2fx=INT(LOG10(A2))+1
| A | B | |
|---|---|---|
| 1 | Order no. | Digits |
| 2 | 7 | 1 |
| 3 | 1042 | 4 |
| 4 | 250000 | 6 |
=INT(LOG10(A2))+1 Explain
Common mistakes
- Zero or negative. Returns #NUM!.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.