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
Search JabSto ::




Custom Search