Wauvel

Excel like a finance pro.

← The library

Engineering function

IMLOG10

Returns the base-10 logarithm of a complex number.

Rarely usedDifficulty 1500 · AdvancedUsage rank #496 of 520
Practice · 2 questions →

When to use it

The base-10 logarithm of a complex number.

The shape of it

Syntax
=IMLOG10(inumber)

Worked examples

  • Typical

    =IMLOG10("3+4i") → 0.698970004336019+0.402719196273373i

    IMLN divided by LN(10).

  • Ten

    =IMLOG10("10") → 1

    Real ten.

  • Negative real

    =IMLOG10("-1") → 1.36437635384184i

    The log of a negative number is imaginary.

Worth knowing

  • Same as IMLN(z)/LN(10).
  • Decibels of a complex gain use the modulus instead.
  • Result is text.

Where it goes wrong

  • #NUM! for "0".
  • #VALUE! for invalid text.

Related

CONVERTBIN2DECDEC2BINHEX2DECDEC2HEXDELTA

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.