IMLOG10 function
IMLOG10 returns the base-10 logarithm of a complex number as text in complex number form. To get a plain number, wrap the result in IMREAL or IMAGINARY.
Example
Read it as a sentence: find the base 10 log of the complex number 1+i, then keep only its real part, which gives 0.150514997831991.
A
B
C
D
1
0.150514997831991
2
3
Syntax
IMLOG10(inumber)
-
inumber(required) - A complex number as text, like "3+4i".
Returns: The result as a complex number in text form.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=IMLOG10("3+4i") | 0.698970004336019+0.402719196273373i | "3+4i" |
=IMLOG10("3+4j") | 0.698970004336019+0.402719196273373j | Suffix j |
=IMLOG10(5) | 0.698970004336019 | Pure real number 5 |
=IMLOG10("5") | 0.698970004336019 | Pure real text "5" |
=IMLOG10("i") | 0.682188176920921i | Pure imaginary "i" |
=IMLOG10("-2i") | 0.301029995663981-0.682188176920921i | "-2i" |
=IMLOG10(0) | #NUM! | Zero |
=IMLOG10("3+4I") | #NUM! | Uppercase I |
Watch out for
- Result is text; wrap in IMREAL or IMAGINARY to get a number.
Where it works
- Excel
- IMLOG10 is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Engineering functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .