| 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. |