IMLOG10 function

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

Syntax

IMLOG10(inumber)

Argument

Description

Remarks

inumber

A complex number for which you want the common logarithm.

  • If inumber is not in the form x + yi or x + yj, this function returns the #NUM! error value.

General remarks

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

  • The common logarithm of a complex number can be calculated from the natural logarithm as follows:

    IMLOG10 Equation

Example

To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

1
2
AB
FormulaDescription (Result)
=IMLOG10("3+4i")Logarithm (base 10) of 3+4i (0.69897 + 0.402719i)
Rate this content:
Not helpfulSomewhat helpfulHelpfulVery helpfulSolved my problem 
 
Share your feedback about this topic