Microsoft Office Tutorials and References
In Depth Information
IMSUB
Where the square root of a complex number is as follows:
where
and
See the COMPLEX function earlier in this chapter for obtaining the complex number of real and
imaginar y coefficients.
Figure 5.33
Returns the square root
of complex numbers
x+yi or x+yj in text
format.
IMSUB
Returns the difference of two complex numbers in x+yi or x+yj text format with IMSUB .
=IMSUB(inumber1,inumber2)
The IMSUB 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.34 shows the difference when
two complex numbers are subtracted.
Search JabSto ::




Custom Search