IMLOG10 Function
Returns the base-10 logarithm of a complex number.
Category
Engineering
Available in
All versions, Microsoft 365
Returns
Complex number text
Want to practice IMLOG10 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
IMLOG10 is IMLN divided by ln(10). For positive real numbers it matches LOG10.
The result is text, shown to 15 significant digits. Wrap it in IMREAL or IMAGINARY to get a number you can format or round.
Syntax
=IMLOG10(inumber) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| inumber | Yes | A complex number as text, like "3+4i" — or a plain number. |
Examples
Example 1 — Worked examples
Each row applies the function to the value in column A.
B2fx=IMLOG10(A2)
| A | B | |
|---|---|---|
| 1 | Complex | log₁₀(z) |
| 2 | 3+4i | 0.698970004336019+0.402719196273373i |
| 3 | 100 | 2 |
| 4 | -10 | 1+1.36437635384184i |
| 5 | 0.01 | -2 |
=IMLOG10(A2) Explain
Common mistakes
- #NUM! The text isn't a valid complex number — for example a space ("3 + 4i"), a capital I, or a letter other than i or j.
- #NUM! for zero. The logarithm of 0 is undefined.
Notes
- Related functions: IMLN, IMLOG2, LOG10.

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.