Microsoft Office Tutorials and References

In Depth Information

**Financial Functions**

Returns the exponential of complex numbers
x + yi
or
x + yj
in

text format.

IMEXP

Returns the natural logarithm of complex numbers

x + yi
or
x + yj
in text format.

IMLN

Returns the common logarithm (base 10) of complex numbers

x + yi
or
x + yj
in text format.

IMLOG10

Returns the base 2 logarithm of complex numbers

x + yi
or
x + yj
in text format.

IMLOG2

Returns a complex number raised to a power
x + yi
or
x + yj
in

text format.

IMPOWER

Returns the product from 2 to 29 complex numbers

x + yi
or
x + yj
in text format.

IMPRODUCT

Returns real coefficients of complex numbers
x + yi
or
x + yj

in text format.

IMREAL

Returns the sine of complex numbers
x + yi
or
x + yj
in text

format.

IMSIN

Returns the square root of complex numbers
x + yi
or
x + yj
in

text format.

IMSQRT

Returns the difference of two complex numbers
x + yi
or
x + yj

in text format.

IMSUB

Returns the sum of two complex numbers
x + yi
or
x + yj
in

text format.

IMSUM

Converts an octal number to binar y.

OCT2BIN

Converts an octal number to decimal.

OCT2DEC

Converts an octal number to hexadecimal.

OCT2HEX

Returns the square root of a positive number multiplied by pi.

This value cannot be less than zero. Also found under

Trigonometric functions.

SQRTPI

Financial Functions

ACCRINT

Returns the accrued interest for security that pays periodic interest.

Returns the accrued interest for security that pays interest at

maturity.

ACCRINTM

Returns appreciation for each accounting period.

AMORDEGRC

Returns depreciation for each accounting period.

AMORLINC

Returns the number of days from the start date of the coupon

period to the settlement.

COUPDAYBS