Skip to content

Analysis Toolpak Functions

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.