Related Function:

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

Syntax

=IMLOG10(inumber)

Arguments

Argument Description
inumber A complex number for which you want the common logarithm. The inumber argument can be supplied to the IMLOG10 function as either:

  a simple number
  a complex number encased in quotation marks, e.g. “5+3i”
  a reference to a cell containing a complex number or a numeric value
  a value returned from another function or formula

Note: Use the COMPLEX function to convert real and imaginary coefficients into a complex number.

Examples

  A B C
1 Formula Result Notes
2 =IMLOG10(“3+4i”) 0.698970004336019+0.402719196273373i Logarithm (base 10) of 3+4i
3 =IMLOG10(2) 0.301029995663981  
4 =IMLOG10(“2.5-i”) 0.349485002168009-0.201359598136687i  
5 =IMLOG10(COMPLEX(1,-1)) 0.150514997831991-0.34109408846046i  

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if the supplied inumber argument is not recognized as a complex number
#NAME? Occurs when Analysis ToolPak add-in is not enabled

The common (base 10) logarithm of a complex number is calculated by the equation: 

    \[log_{10}(x+yi)=(log_{10}\ e)ln(x+yi)\]

Further information on Complex Numbers can be found on the Wikipedia Complex Numbers Page.