Excel Category
Name
Description
Financial ACCRINT Returns the accrued interest for a security that pays periodic interest
Financial ACCRINTM Returns the accrued interest for a security that pays interest at maturity
Financial AMORDEGRC Returns the depreciation for each accounting period (French accounting)
Financial AMORLINC Returns the depreciation for each accounting period (French accounting)
Financial COUPDAYBS Returns the number of days from the beginning of the coupon period to the settlement date
Financial COUPDAYS Returns the number of days in the coupon period that contains the settlement date
Financial COUPDAYSNC Returns the number of days from the settlement date to the next coupon date
Financial COUPNCD Returns the next coupon date after the settlement date
Financial COUPNUM Returns the number of coupons payable between the settlement date and maturity date
Financial COUPPCD Returns the previous coupon date before the settlement date
Financial CUMIPMT Returns the cumulative interest paid between two periods
Financial CUMPRINC Returns the cumulative principal paid on a loan between two periods
Financial DB Returns the depreciation of an asset for a specified period using the fixed-declining balance method
Financial DDB Returns the depreciation of an asset for a spcified period using the double-declining balance method or some other method you specify
Financial DISC Returns the discount rate for a security
Financial DOLLARDE Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
Financial DOLLARFR Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
Financial DURATION Returns the annual duration of a security with periodic interest payments
Financial EFFECT Returns the effective annual interest rate
Financial FV Returns the future value of an investment
Financial FVSCHEDULE Returns the future value of an initial principal after applying a series of compound interest rates
Financial INTRATE Returns the interest rate for a fully invested security
Financial IPMT Returns the interest payment for an investment for a given period
Financial IRR Returns the internal rate of return for a series of cash flows
Financial MDURATION Returns the Macauley modified duration for a security with an assumed par value of $100
Financial MIRR Returns the internal rate of return where positive and negative cash flows are financed at different rates
Financial NOMINAL Returns the annual nominal interest rate
Financial NPER Returns the number of periods for an investment
Financial NPV Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
Financial ODDFPRICE Returns the price per $100 face value of a security with an odd first period
Financial ODDFYIELD Returns the yield of a security with an odd first period
Financial ODDLPRICE Returns the price per $100 face value of a security with an odd last period
Financial ODDLYIELD Returns the yield of a security with an odd last period
Financial PMT Returns the periodic payment for an annuity
Financial PPMT Returns the payment on the principal for an investment for a given period
Financial PRICE Returns the price per $100 face value of a security that pays periodic interest
Financial PRICEDISC Returns the price per $100 face value of a discounted security
Financial PRICEMAT Returns the price per $100 face value of a security that pays interest at maturity
Financial PV Returns the present value of an investment
Financial RATE Returns the interest rate per period of an annuity
Financial RECEIVED Returns the amount received at maturity for a fully invested security
Financial SLN Returns the straight-line depreciation of an asset for one period
Financial SYD Returns the sum-of-years' digits depreciation of an asset for a specified period
Financial TBILLEQ Returns the bond-equivalent yield for a Treasury bill
Financial TBILLPRICE Returns the price per $100 face value for a Treasury bill
Financial TBILLYIELD Returns the yield for a Treasury bill
Financial VDB Returns the depreciation of an asset for a specified or partial period using a declining balance method
Financial XIRR Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
Financial XNPV Returns the net present value for a schedule of cash flows that is not necessarily periodic
Financial YIELD Returns the yield on a security that pays periodic interest
Financial YIELDDISC Returns the annual yield for a discounted security. For example, a treasury bill
Financial YIELDMAT Returns the annual yield of a security that pays interest at maturity
Statistical AVEDEV Returns the average of the absolute deviations of data points from their mean
Statistical AVERAGE Returns the average of its arguments
Statistical BETADIST Returns the cumulative beta probability density function
Statistical BETAINV Returns the inverse of the cumulative beta probability density function
Statistical BINOMDIST Returns the individual term binomial distribution probability
Statistical CHIDIST Returns the one-tailed probability of the chi-squared distribution
Statistical CHIINV Returns the inverse of the one-tailed probability of the chi-squared distribution
Statistical CHITEST Returns the test for independence
Statistical CONFIDENCE Returns the confidence interval for a population mean
Statistical CORREL Returns the correlation coefficient between two data sets
Statistical COUNT Counts how many numbers are in the list of arguments
Statistical COUNTA Counts how many values are in the list of arguments
Statistical COVAR Returns covariance, the average of the products of paired deviations
Statistical CRITBINOM Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
Statistical DEVSQ Returns the sum of squares of deviations
Statistical EXPONDIST Returns the exponential distribution
Statistical FDIST Returns the F probability distribution
Statistical FINV Returns the inverse of the F probability distribution
Statistical FISHER Returns the Fisher transformation
Statistical FISHERINV Returns the inverse of the Fisher transformation
Statistical FORECAST Returns a value along a linear trend
Statistical FREQUENCY Returns a frequency distribution as a vertical array
Statistical FTEST Returns the result of an F-test
Statistical GAMMADIST Returns the gamma distribution
Statistical GAMMAINV Returns the inverse of the gamma cumulative distribution
Statistical GAMMALN Returns the natural logarithm of the gamma function, G(x)
Statistical GEOMEAN Returns the geometric mean
Statistical GROWTH Returns values along an exponential trend
Statistical HARMEAN Returns the harmonic mean
Statistical HYPGEOMDIST Returns the hypergeometric distribution
Statistical INTERCEPT Returns the intercept of the linear regression line
Statistical KURT Returns the kurtosis of a data set
Statistical LARGE Returns the k-th largest value in a data set
Statistical LINEST Returns the parameters of a linear trend
Statistical LOGEST Returns the parameters of an exponential trend
Statistical LOGINV Returns the inverse of the lognormal distribution
Statistical LOGNORMDIST Returns the cumulative lognormal distribution
Statistical MAX Returns the maximum value in a list of arguments
Statistical MEDIAN Returns the median of the given numbers
Statistical MIN Returns the minimum value in a list of arguments
Statistical MODE Returns the most common value in a data set
Statistical NEGBINOMDIST Returns the negative binomial distribution
Statistical NORMDIST Returns the normal cumulative distribution
Statistical NORMINV Returns the inverse of the normal cumulative distribution
Statistical NORMSDIST Returns the standard normal cumulative distribution
Statistical NORMSINV Returns the inverse of the standard normal cumulative distribution
Statistical PEARSON Returns the Pearson product moment correlation coefficient
Statistical PERCENTILE Returns the k-th percentile of values in a range
Statistical PERCENTRANK Returns the percentage rank of a value in a data set
Statistical PERMUT Returns the number of permutations for a given number of objects
Statistical POISSON Returns the Poisson distribution
Statistical PROB Returns the probability that values in a range are between two limits
Statistical QUARTILE Returns the quartile of a data set
Statistical RANK Returns the rank of a number in a list of numbers
Statistical RSQ Returns the square of the Pearson product moment correlatin coefficient
Statistical SKEW Returns the skewness of a distribution
Statistical SLOPE Returns the slope of the linear regression line
Statistical SMALL Returns the k-th smallest value in a data set
Statistical STANDARDIZE Returns a normalized value
Statistical STDEV Estimates standard deviation based on a sample
Statistical STDEVP Calculates standard deviation based on the entire population
Statistical STEYX Returns the standard error of the predicted y-value for each x in the regression
Statistical TDIST Returns the Student's t-distribution
Statistical TINV Returns the inverse of the Student's t-distribution
Statistical TREND Returns values along a linear trend
Statistical TRIMMEAN Returns the mean of the interior of a data set
Statistical TTEST Returns the probability associated with a Student's t-Test
Statistical VAR Estimates variance based on a sample
Statistical VARP Calculates variance based on the entire population
Statistical WEIBULL Returns the Weibull distribution
Statistical ZTEST Returns the two-tailed P-value of a z-test