Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.
A complex number for which you want the common logarithm.
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:
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.