ACCRINT |
Returns accrued interest for securities that pay periodic interest. |
ACCRINTM |
Returns the accrued interest for securities that pay interest at the maturity date. |
AMORDEGRC |
Returns the depreciation for each accounting period within the formula. |
AMORLINC |
Returns the depreciation for each accounting period. |
BESSELI |
Returns the BESSEL function in modified form for imaginary arguments. |
BESSELJ |
Returns the actual BESSEL function. |
BESSELK |
Returns the BESSEL function in modified form for imaginary arguments. |
BESSELY |
Returns the BESSEL function, also known as the Weber or Neumann function. |
BIN2DEC |
Converts a binary number to decimal form. |
BIN2HEX |
Converts a binary number to a hexadecimal. |
BIN2OCT |
Converts a binary number to octal form. |
COMPLEX |
Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj. |
CONVERT |
Interprets data from one measurement system to another. |
COUPDAYBS |
Returns the number of days from the beginning of the period to the coupon-period settlement date. |
COUPDAYS |
Returns the number of days in the period that contains the coupon period settlement date. |
COUPDAYSNC |
Returns the number of days between the settlement date to the next coupon date. |
COUPNCD |
Returns the next coupon date after the settlement date. |
COUPNUM |
Returns the total number of coupons to be paid between the settlement and maturity dates, rounded up to the nearest whole coupon. |
COUPPCD |
Returns the coupon date previous to the settlement date. |
CUMIPMT |
Returns the cumulative interest on a loan between start and stop dates. |
CUMPRINC |
Returns the cumulative principal amount between start and stop dates on a loan or mortgage. |
DEC2BIN |
Converts decimal numbers to binary form. |
DEC2HEX |
Converts decimal numbers to hexadecimal. |
DEC2OCT |
Converts decimal numbers to octal. |
DELTA |
Tests whether numbers or values are equal with a number result. Returns “0” for unequal, “1” for equal. |
DISC |
Returns the security discount rate. |
DOLLARDE |
Converts a fraction dollar price into a decimal dollar price. |
DOLLARFR |
Converts a decimal dollar price into a fraction dollar price. |
DURATION |
Returns the Macauley duration for an assumed par value. |
EDATE |
Returns the value or serial number of the date which is a certain number of months before or after a user-specified date. |
EFFECT |
Returns the effective interest rate annually. This is based on the nominal annual interest rate and the number of compounding periods per year. |
EOMONTH |
Returns the date at the end of the month a specified number of months before or after a specified date. |
ERF |
Returns the integrated error function between a lower and upper limit. |
ERFC |
Returns a complementary ERF function integrated between ‘x’ and infinity. |
FACTDOUBLE |
Returns the double factorial of a number. |
FVSCHEDULE |
Returns the future value of a principal amount after applying several, or a series of compound interest rates. |
GCD |
Returns the greatest common divisor of two or more integers. |
GESTEP |
Returns the value 1 if the number is greater than or equal to a specified step value, otherwise it returns 0. |
HEX2BIN |
Converts hexadecimal numbers to binary form. |
HEX2DEC |
Converts hexadecimal numbers to decimal form. |
HEX2OCT |
Converts hexadecimal numbers to octal form. |
IMABS |
Returns the absolute value (modulus) of a complex number in x+yi or x+yj text format. |
IMAGINARY |
Returns the coefficient of a complex number in x+yi or x+yj text format. |
IMARGUMENT |
Returns the theta argument - an angle expressed in radians. |
IMCONJUGATE |
Returns the complex conjugate of a complex number in x+yi or x+yj text format. |
IMCOS |
Returns the cosine of a complex number in x+yi or x+yj text format. |
IMDIV |
Returns the quotient of complex numbers in x+yi or x+yj text format. |
IMEXP |
Returns the exponential of a complex number in x+yi or x+yj text format. |
IMLN |
Returns the natural logarithm of a complex number in x+yi or x+yj text format. |
IMLOG10 |
Returns the common logarithm (Base 10) of a complex number in x+yi or x+yj text format. |
IMLOG2 |
Returns the common logarithm (Base 2) of a complex number in x+yi or x+yj text format. |
IMPOWER |
Returns a complex number raised to a power in x+yi or x+yj text format. |
IMPRODUCT |
Returns the product from 2 to 29 complex numbers in x+yi or x+yj text format. |
IMREAL |
Returns the real coefficient of a complex number in x+yi or x+yj text format. |
IMSIN |
Returns the sine of a complex number in x+yi or x+yj text format. |
IMSQRT |
Returns the square root of a complex number in x+yi or x+yj text format. |
IMSUB |
Returns the difference of two complex numbers in x+yi or x+yj text format. |
IMSUM |
Returns the sum of 2 to 29 complex numbers in x+yi or x+yj text format. |
INTRATE |
Returns the interest rate of a security that is fully invested. |
ISEVEN |
Returns TRUE if value is an even number, FALSE if it is not. |
ISODD |
Returns TRUE if value is an odd number, FALSE if it is not. |
LCM |
Returns the least common multiple of integers. |
MDURATION |
Returns the modified duration of a security with a par value assumed to be $100. |
MROUND |
Returns a number rounded to the desired multiple. Rounds up if the remainder after dividing the number by the multiple is at least half the value of the multiple. |
MULTINOMIAL |
Returns the ratio of the factorial of the sum of the values to the product of the factorials. |
NETWORKDAYS |
Returns the number of working days between two dates. Excludes weekends and specified holidays. |
NOMINAL |
Returns the nominal annual interest rate given an effective rate and the total number of compounding periods for the year. |
OCT2BIN |
Converts an octal number to binary form. |
OCT2DEC |
Converts an octal number to decimal form. |
OCT2HEX |
Converts an octal number to hexadecimal form. |
ODDFPRICE |
Returns the value of a security based on a per $100 face value and an odd (short or long) first period. |
ODDFYIELD |
Returns the security yield with an odd first period. |
ODDLPRICE |
Returns the per $100 face value of a security having an odd last coupon period. |
ODDLYIELD |
Returns the security yield that has an odd last period. |
PRICE |
Returns the value of a security based on price per $100 face value and periodic interest payments. |
PRICEDISC |
Returns the value of a discounted security based on a price per $100 face value. |
PRICEMAT |
Returns the value of a security that pays interest at maturity and price per $100 face value. |
QUOTIENT |
Returns the integer portion of a division. |
RANDBETWEEN |
Returns a random integer between the integers you specify. A new random number is returned every time the worksheet is calculated. |
RECEIVED |
Based on a fully invested security, returns the amount received at maturity. |
SERIESSUM |
Returns the sum of a power series. |
SQRTPI |
Returns the square root of (NUMBER * Pi) |
TBILLEQ |
Returns the bond equivalent yield for a treasury bill. |
TBILLPRICE |
Returns the price per $100 face value for a treasury bill. |
TBILLYIELD |
Returns the yield of a treasury bill. |
WEEKNUM |
Returns the number where a week falls numerically within a year. |
WORKDAY |
Returns a date that is a specified number of working days before or after a given date. |
XIRR |
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. |
XNPV |
Returns the net present value for a schedule of cash flows that is not necessarily periodic. |
YEARFRAC |
Calculates the fraction of the year between two dates. |
YIELD |
Based on a yield that pays periodic interest, returns the yeild of the security. |
YIELDDISC |
Returns the annual yield for a discounted security. |
YIELDMAT |
Returns the annual yield based on a security that pays interest at a maturity. |