Author: Oscar Cronquist Article last updated on November 10, 2022

How to use the IMLOG10 function 1

The IMLOG10 function calculates the base 10 logarithm of a complex number in x + yi or x + yj text format.

The letter j is used in electrical engineering to distinguish between the imaginary value and the electric current.

The base 10 logarithm of a complex number is calculated like this:

C = x + yi

IMLOG10(C) =log10(x+yi)=(log10e)ln(x+yi)

1. IMLOG10 Function Syntax

IMLOG10(inumber)

Back to top

2. IMLOG10 Function Arguments

inumber Required. A complex number in x+yi or x+yj text format.

Back to top

3. IMLOG10 function example

How to use the IMLOG10 function 1

The image above demonstrates a formula in cell D3 that calculates the base 10 logarithm of a complex number specified in cell C3.

Formula in cell C3:

=IMLOG10(B3)

3.1 Explaining formula

Step 1 - Populate arguments

IMLOG10(inumber)

becomes

IMLOG10(B3)

Step 2 - Evaluate the IMLOG10 function

IMLOG10(B3)

becomes

IMLOG10("1+2i")

and returns

0.349485002168009+0.480828578784234i

Back to top