Microsoft Office Tutorials and References

In Depth Information

**IMLN**

IML
Return the natural logarithm of a complex number in
x+yi
or
x+yj
text format with the
IMLN

function.

=IMLN(inumber)

The
IMLN
function is found only if the Analysis Toolpak is installed. In addition it must be

turned on in the Add-Ins from the Tools menu. The example in Figure 5.26 shows the Natural

Logarithm of the complex numbers.

INUMBER
The complex number you want the logarithm for.

The natural logarithm for the complex number is

where

See the
COMPLEX
function earlier in this chapter for obtaining the complex number of real and

imaginar y coefficients.

Figure 5.26

Returns the natural

logarithm of complex

numbers
x+yi
or
x+yj

in text format.

IMLOG10

IMLOG10
returns the common logarithm (Base 10) of a complex number in
x+yi
or
x+yj
text

format.

=IMLOG10(inumber)