Excel函数大全（Excel Function List）-Part 2

Excel Statistical Functions	Deviation & Variance	DEVSQ	Returns the sum of the squares of the deviations of a set of data points from their sample mean
Excel Statistical Functions	Deviation & Variance	STDEV	Returns the standard deviation of a supplied set of values (which represent a sample of a population) (Replaced by Stdev.S function in Excel 2010)
Excel Statistical Functions	Deviation & Variance	STDEV.S	Returns the standard deviation of a supplied set of values (which represent a sample of a population) (New in Excel 2010 - replaces the Stdev function)
Excel Statistical Functions	Deviation & Variance	STDEVA	Returns the standard deviation of a supplied set of values (which represent a sample of a population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1
Excel Statistical Functions	Deviation & Variance	STDEVP	Returns the standard deviation of a supplied set of values (which represent an entire population) (Replaced by Stdev.P function in Excel 2010)
Excel Statistical Functions	Deviation & Variance	STDEV.P	Returns the standard deviation of a supplied set of values (which represent an entire population) (New in Excel 2010 - replaces the Stdevp function)
Excel Statistical Functions	Deviation & Variance	STDEVPA	Returns the standard deviation of a supplied set of values (which represent an entire population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1
Excel Statistical Functions	Deviation & Variance	VAR	Returns the variance of a supplied set of values (which represent a sample of a population) (Replaced by Var.S function in Excel 2010)
Excel Statistical Functions	Deviation & Variance	VAR.S	Returns the variance of a supplied set of values (which represent a sample of a population) (New in Excel 2010 - replaces the Var function)
Excel Statistical Functions	Deviation & Variance	VARA	Returns the variance of a supplied set of values (which represent a sample of a population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1
Excel Statistical Functions	Deviation & Variance	VARP	Returns the variance of a supplied set of values (which represent an entire population) (Replaced by Var.P function in Excel 2010)
Excel Statistical Functions	Deviation & Variance	VAR.P	Returns the variance of a supplied set of values (which represent an entire population) (New in Excel 2010 - replaces the Varp function)
Excel Statistical Functions	Deviation & Variance	VARPA	Returns the variance of a supplied set of values (which represent an entire population), counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1
Excel Statistical Functions	Deviation & Variance	COVAR	Returns population covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (Replaced by Covariance.P function in Excel 2010)
Excel Statistical Functions	Deviation & Variance	COVARIANCE.P	Returns population covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (New in Excel 2010 - replaces the Covar function)
Excel Statistical Functions	Deviation & Variance	COVARIANCE.S	Returns sample covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (New in Excel 2010)
Excel Statistical Functions	Trend Line Functions	FORECAST	Predicts a future point on a linear trend line fitted to a supplied set of x- and y- values (Replaced by Forecast.Linear function in Excel 2016)
Excel Statistical Functions	Trend Line Functions	FORECAST.ETS	Uses an exponential smoothing algorithm to predict a future value on a timeline, based on a series of existing values (New in Excel 2016 - not available in Excel 2016 for Mac)
Excel Statistical Functions	Trend Line Functions	FORECAST.ETS.CONFINT	Returns a confidence interval for a forecast value at a specified target date (New in Excel 2016 - not available in Excel 2016 for Mac)
Excel Statistical Functions	Trend Line Functions	FORECAST.ETS.SEASONALITY	Returns the length of the repetitive pattern Excel detects for a specified time series (New in Excel 2016 - not available in Excel 2016 for Mac)
Excel Statistical Functions	Trend Line Functions	FORECAST.ETS.STAT	Returns a statistical value relating to a time series forecasting (New in Excel 2016 - not available in Excel 2016 for Mac)
Excel Statistical Functions	Trend Line Functions	FORECAST.LINEAR	Predicts a future point on a linear trend line fitted to a supplied set of x- and y- values (New in Excel 2016 (not Excel 2016 for Mac) - replaces the Forecast function)
Excel Statistical Functions	Trend Line Functions	INTERCEPT	Calculates the best fit regression line, through a supplied series of x- and y- values and returns the value at which this line intercepts the y-axis
Excel Statistical Functions	Trend Line Functions	LINEST	Returns statistical information describing the trend of the line of best fit, through a supplied series of x- and y- values
Excel Statistical Functions	Trend Line Functions	SLOPE	Returns the slope of the linear regression line through a supplied series of x- and y- values
Excel Statistical Functions	Trend Line Functions	TREND	Calculates the trend line through a given set of y-values and returns additional y-values for a supplied set of new x-values
Excel Statistical Functions	Trend Line Functions	GROWTH	Returns numbers in a exponential growth trend, based on a set of supplied x- and y- values
Excel Statistical Functions	Trend Line Functions	LOGEST	Returns the parameters of an exponential trend for a supplied set of x- and y- values
Excel Statistical Functions	Trend Line Functions	STEYX	Returns the standard error of the predicted y-value for each x in the regression line for a set of supplied x- and y- values
Excel Statistical Functions	Finding the Largest & Smallest Values	MAX	Returns the largest value from a list of supplied numbers
Excel Statistical Functions	Finding the Largest & Smallest Values	MAXA	Returns the largest value from a list of supplied values, counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1
Excel Statistical Functions	Finding the Largest & Smallest Values	MAXIFS	Returns the largest value from a subset of values in a list that are specified according to one or more criteria. (New in Excel 2016 - not available in Excel 2016 for Mac)
Excel Statistical Functions	Finding the Largest & Smallest Values	MIN	Returns the smallest value from a list of supplied numbers
Excel Statistical Functions	Finding the Largest & Smallest Values	MINA	Returns the smallest value from a list of supplied values, counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1
Excel Statistical Functions	Finding the Largest & Smallest Values	MINIFS	Returns the smallest value from a subset of values in a list that are specified according to one or more criteria. (New in Excel 2016 - not available in Excel 2016 for Mac)
Excel Statistical Functions	Finding the Largest & Smallest Values	LARGE	Returns the Kth LARGEST value from a list of supplied numbers, for a given value K
Excel Statistical Functions	Finding the Largest & Smallest Values	SMALL	Returns the Kth SMALLEST value from a list of supplied numbers, for a given value K
Excel Statistical Functions	Confidence Intervals	CONFIDENCE	Returns the confidence interval for a population mean, using a normal distribution (Replaced by Confidence.Norm function in Excel 2010)
Excel Statistical Functions	Confidence Intervals	CONFIDENCE.NORM	Returns the confidence interval for a population mean, using a normal distribution (New in Excel 2010 - replaces the Confidence function)
Excel Statistical Functions	Confidence Intervals	CONFIDENCE.T	Returns the confidence interval for a population mean, using a Student's t distribution (New in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	BETADIST	Returns the cumulative beta probability density function (Replaced by Beta.Dist function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	BETA.DIST	Returns the cumulative beta distribution function or the beta probability density function (New in Excel 2010 - replaces the Betadist function)
Excel Statistical Functions	Distribution & Tests of Probability	BETAINV	Returns the inverse of the cumulative beta probability density function (Replaced by Beta.Inv function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	BETA.INV	Returns the inverse of the cumulative beta probability density function (New in Excel 2010 - replaces the Betainv function)
Excel Statistical Functions	Distribution & Tests of Probability	BINOMDIST	Returns the individual term binomial distribution probability (Replaced by Binom.Dist function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	BINOM.DIST	Returns the individual term binomial distribution probability (New in Excel 2010 - replaces the Binomdist function)
Excel Statistical Functions	Distribution & Tests of Probability	BINOM.DIST.RANGE	Returns the probability of a trial result using a binomial distribution (New in Excel 2013)
Excel Statistical Functions	Distribution & Tests of Probability	NEGBINOMDIST	Returns the negative binomial distribution (Replaced by Negbinom.Dist function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	NEGBINOM.DIST	Returns the negative binomial distribution (New in Excel 2010 - replaces the Negbinomdist function)
Excel Statistical Functions	Distribution & Tests of Probability	CRITBINOM	Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value (Replaced by Binom.Inv function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	BINOM.INV	Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value (New in Excel 2010 - replaces the Critbinom function)
Excel Statistical Functions	Distribution & Tests of Probability	CHIDIST	Returns the right-tailed probability of the chi-squared distribution (Replaced by Chisq.Dist.Rt function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	CHISQ.DIST.RT	Returns the right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces the Chidist function)
Excel Statistical Functions	Distribution & Tests of Probability	CHISQ.DIST	Returns the chi-squared distribution (probability density or cumulative distribution function) (New in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	CHIINV	Returns the inverse of the right-tailed probability of the chi-squared distribution (Replaced by Chisq.Inv.Rt function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	CHISQ.INV.RT	Returns the inverse of the right-tailed probability of the chi-squared distribution (New in Excel 2010 - replaces the Chiinv function)
Excel Statistical Functions	Distribution & Tests of Probability	CHISQ.INV	Returns the inverse of the left-tailed probability of the chi-squared distribution (New in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	CHITEST	Returns the chi-squared statistical test for independence (Replaced by Chisq.Test function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	CHISQ.TEST	Returns the chi-squared statistical test for independence (New in Excel 2010 - replaces the Chitest function)
Excel Statistical Functions	Distribution & Tests of Probability	CORREL	Returns the correlation coefficient between two sets of values
Excel Statistical Functions	Distribution & Tests of Probability	EXPONDIST	Returns the exponential distribution (Replaced by Expon.Dist function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	EXPON.DIST	Returns the exponential distribution (New in Excel 2010 - replaces the Expondist function)
Excel Statistical Functions	Distribution & Tests of Probability	FDIST	Returns the right-tailed F probability distribution for two data sets (Replaced by F.Dist.Rt function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	F.DIST.RT	Returns the right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces the Fdist function)
Excel Statistical Functions	Distribution & Tests of Probability	F.DIST	Returns the F probability distribution (probability density or cumulative distribution function) (New in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	FINV	Returns the inverse of the right-tailed F probability distribution for two data sets (Replaced by F.Inv.Rt function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	F.INV.RT	Returns the inverse of the right-tailed F probability distribution for two data sets (New in Excel 2010 - replaces the Finv function)
Excel Statistical Functions	Distribution & Tests of Probability	F.INV	Returns the inverse of the Cumulative F distribution (New in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	FISHER	Returns the Fisher transformation
Excel Statistical Functions	Distribution & Tests of Probability	FISHERINV	Returns the inverse of the Fisher transformation
Excel Statistical Functions	Distribution & Tests of Probability	FTEST	Returns the result of an F-Test for 2 supplied data sets (Replaced by F.Test function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	F.TEST	Returns the result of an F-Test for 2 supplied data sets (New in Excel 2010 - replaces the Ftest function)
Excel Statistical Functions	Distribution & Tests of Probability	GAMMADIST	Returns the gamma distribution (Replaced by Gamma.Dist function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	GAMMA.DIST	Returns the gamma distribution (New in Excel 2010 - replaces the Gammadist function)
Excel Statistical Functions	Distribution & Tests of Probability	GAMMAINV	Returns the inverse gamma cumulative distribution (Replaced by Gamma.Inv function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	GAMMA.INV	Returns the inverse gamma cumulative distribution (New in Excel 2010 - replaces the Gammainv function)
Excel Statistical Functions	Distribution & Tests of Probability	GAMMA	Return the gamma function value for a supplied number (New in Excel 2013)
Excel Statistical Functions	Distribution & Tests of Probability	GAMMALN	Calculates the natural logarithm of the gamma function for a supplied value
Excel Statistical Functions	Distribution & Tests of Probability	GAMMALN.PRECISE	Returns the natural logarithm of the gamma function for a supplied value (New in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	GAUSS	Calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean (New in Excel 2013)
Excel Statistical Functions	Distribution & Tests of Probability	HYPGEOMDIST	Returns the hypergeometric distribution (Replaced by Hypgeom.Dist function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	HYPGEOM.DIST	Returns the hypergeometric distribution (New in Excel 2010 - replaces the Hypgeomdist function)
Excel Statistical Functions	Distribution & Tests of Probability	KURT	Returns the kurtosis of a data set
Excel Statistical Functions	Distribution & Tests of Probability	LOGNORMDIST	Returns the cumulative log-normal distribution (Replaced by Lognorm.Dist function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	LOGNORM.DIST	Returns the log-normal probability density function or the cumulative log- normal distribution (New in Excel 2010 - replaces the Lognormdist function)
Excel Statistical Functions	Distribution & Tests of Probability	LOGINV	Returns the inverse of the lognormal distribution (Replaced by Lognorm.Inv function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	LOGNORM.INV	Returns the inverse of the lognormal distribution (New in Excel 2010 - replaces the Loginv function)
Excel Statistical Functions	Distribution & Tests of Probability	NORMDIST	Returns the normal cumulative distribution (Replaced by Norm.Dist function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	NORM.DIST	Returns the normal cumulative distribution (New in Excel 2010 - replaces the Normdist function)
Excel Statistical Functions	Distribution & Tests of Probability	NORMINV	Returns the inverse of the normal cumulative distribution (Replaced by Norm.Inv function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	NORM.INV	Returns the inverse of the normal cumulative distribution (New in Excel 2010 - replaces the Norminv function)
Excel Statistical Functions	Distribution & Tests of Probability	NORMSDIST	Returns the standard normal cumulative distribution (Replaced by Norm.S.Dist function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	NORM.S.DIST	Returns the standard normal cumulative distribution (New in Excel 2010 - replaces the Normsdist function)
Excel Statistical Functions	Distribution & Tests of Probability	NORMSINV	Returns the inverse of the standard normal cumulative distribution (Replaced by Norm.S.Inv function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	NORM.S.INV	Returns the inverse of the standard normal cumulative distribution (New in Excel 2010 - replaces the Normsinv function)
Excel Statistical Functions	Distribution & Tests of Probability	PEARSON	Returns the Pearson product moment correlation coefficient
Excel Statistical Functions	Distribution & Tests of Probability	RSQ	Returns the square of the Pearson product moment correlation coefficient
Excel Statistical Functions	Distribution & Tests of Probability	PHI	Returns the value of the density function for a standard normal distribution, for a supplied number (New in Excel 2013)
Excel Statistical Functions	Distribution & Tests of Probability	POISSON	Returns the Poisson distribution (Replaced by Poisson.Dist function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	POISSON.DIST	Returns the Poisson distribution (New in Excel 2010 - replaces the Poisson function)
Excel Statistical Functions	Distribution & Tests of Probability	PROB	Returns the probablity that values in a supplied range are within given limits
Excel Statistical Functions	Distribution & Tests of Probability	SKEW	Returns the skewness of a distribution
Excel Statistical Functions	Distribution & Tests of Probability	SKEW.P	Returns the skewness of a distribution based on a population (New in Excel 2013)
Excel Statistical Functions	Distribution & Tests of Probability	STANDARDIZE	Returns a normalized value
Excel Statistical Functions	Distribution & Tests of Probability	TDIST	Returns the Student's T-distribution (Replaced by T.Dist.2t & T.Dist.Rt functions in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	T.DIST.2T	Returns the two-tailed Student's T-distribution (New in Excel 2010 - replaces the Tdist function)
Excel Statistical Functions	Distribution & Tests of Probability	T.DIST.RT	Returns the right-tailed Student's T-distribution (New in Excel 2010 - replaces the Tdist function)
Excel Statistical Functions	Distribution & Tests of Probability	T.DIST	Returns the Student's T-distribution (probability density or cumulative distribution function) (New in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	TINV	Returns the two-tailed inverse of the Student's T-distribution (Replaced by T.Inv.2t function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	T.INV.2T	Returns the two-tailed inverse of the Student's T-distribution (New in Excel 2010 - replaces the Tinv function)
Excel Statistical Functions	Distribution & Tests of Probability	T.INV	Returns the left-tailed inverse of the Student's T-distribution (New in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	TTEST	Returns the probability associated with a Student's T-Test (Replaced by T.Test function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	T.TEST	Returns the probability associated with a Student's T-Test (New in Excel 2010 - replaces the Ttest function)
Excel Statistical Functions	Distribution & Tests of Probability	WEIBULL	Returns the Weibull distribution (Replaced by Weibull.Dist function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	WEIBULL.DIST	Returns the Weibull distribution (New in Excel 2010 - replaces the Weibull function)
Excel Statistical Functions	Distribution & Tests of Probability	ZTEST	Returns the one-tailed probability value of a z-test (Replaced by Z.Test function in Excel 2010)
Excel Statistical Functions	Distribution & Tests of Probability	Z.TEST	Returns the one-tailed probability value of a z-test (New in Excel 2010 - replaces the Ztest function)
Excel Database Functions	Database Functions	DAVERAGE	Calculates the average of values in a field of a list or database, that satisfy specified conditions
Excel Database Functions	Database Functions	DCOUNT	Returns the number of cells containing numbers in a field of a list or database that satisfy specified conditions
Excel Database Functions	Database Functions	DCOUNTA	Returns the number of non-blank cells in a field of a list or database, that satisfy specified conditions
Excel Database Functions	Database Functions	DGET	Returns a single value from a field of a list or database, that satisfy specified conditions
Excel Database Functions	Database Functions	DMAX	Returns the maximum value from a field of a list or database, that satisfy specified conditions
Excel Database Functions	Database Functions	DMIN	Returns the minimum value from a field of a list or database, that satisfy specified conditions
Excel Database Functions	Database Functions	DPRODUCT	Calculates the product of values in a field of a list or database, that satisfy specified conditions
Excel Database Functions	Database Functions	DSTDEV	Calculates the standard deviation (based on a sample of a population) of values in a field of a list or database, that satisfy specified conditions
Excel Database Functions	Database Functions	DSTDEVP	Calculates the standard deviation (based on an entire population) of values in a field of a list or database, that satisfy specified conditions
Excel Database Functions	Database Functions	DSUM	Calculates the sum of values in a field of a list or database, that satisfy specified conditions
Excel Database Functions	Database Functions	DVAR	Calculates the variance (based on a sample of a population) of values in a field of a list or database, that satisfy specified conditions
Excel Database Functions	Database Functions	DVARP	Calculates the variance (based on an entire population) of values in a field of a list or database, that satisfy specified conditions
Excel Financial Functions	Investment Value Functions	FV	Calculates the future value of an investment with periodic constant payments and a constant interest rate
Excel Financial Functions	Investment Value Functions	FVSCHEDULE	Calculates the future value of an initial principal, after applying a series of compound interest rates
Excel Financial Functions	Investment Value Functions	NPV	Calculates the net present value of an investment, based on a supplied discount rate, and a series of future payments and income
Excel Financial Functions	Investment Value Functions	PV	Calculates the present value of an investment (i.e. the total amount that a series of future payments is worth now)
Excel Financial Functions	Investment Value Functions	RECEIVED	Calculates the amount received at maturity for a fully invested Security
Excel Financial Functions	Investment Value Functions	XNPV	Calculates the net present value for a schedule of cash flows
Excel Financial Functions	Price Functions	DISC	Calculates the discount rate for a security
Excel Financial Functions	Price Functions	PRICE	Calculates the price per $100 face value of a security that pays periodic interest
Excel Financial Functions	Price Functions	PRICEDISC	Calculates the price per $100 face value of a discounted security
Excel Financial Functions	Price Functions	PRICEMAT	Calculates the price per $100 face value of a security that pays interest at maturity
Excel Financial Functions	Price Functions	ODDFPRICE	Calculates the price per $100 face value of a security with an odd first period
Excel Financial Functions	Price Functions	ODDLPRICE	Calculates the price per $100 face value of a security with an odd last period
Excel Financial Functions	Price Functions	TBILLPRICE	Calculates the price per $100 face value for a treasury bill
Excel Financial Functions	Internal Rate of Return Functions	IRR	Calculates the internal rate of return for a series of cash flows
Excel Financial Functions	Internal Rate of Return Functions	MIRR	Calculates the internal rate of return for a series of periodic cash flows, considering the cost of the investment and the interest on the reinvestment of cash
Excel Financial Functions	Internal Rate of Return Functions	XIRR	Calculates the internal rate of return for a schedule of cash flows
Excel Financial Functions	Asset Depreciation Functions	AMORDEGRC	Calculates the prorated linear depreciation of an asset for each accounting period (with depreciation coefficient applied, depending on the life of the asset)
Excel Financial Functions	Asset Depreciation Functions	AMORLINC	Calculates the prorated linear depreciation of an asset for each accounting period
Excel Financial Functions	Asset Depreciation Functions	DB	Calculates the depreciation of an asset for a specified period, using the fixed-declining balance method
Excel Financial Functions	Asset Depreciation Functions	DDB	Calculates the depreciation of an asset for a specified period, using the double-declining balance method, or some other user-specified method
Excel Financial Functions	Asset Depreciation Functions	SLN	Returns the straight-line depreciation of an asset for one period
Excel Financial Functions	Asset Depreciation Functions	SYD	Returns the sum-of-years' digits depreciation of an asset for a specified period
Excel Financial Functions	Asset Depreciation Functions	VDB	Returns the depreciation of an asset for a specified period, (including partial periods), using the double-declining balance method or another user-specified method
Excel Financial Functions	Dollar Conversion	DOLLARDE	Converts a dollar price expressed as a fraction, into a dollar price expressed as a decimal
Excel Financial Functions	Dollar Conversion	DOLLARFR	Converts a dollar price expressed as a decimal, into a dollar price expressed as a fraction
Excel Financial Functions	Payment Functions	CUMIPMT	Calculates the cumulative interest paid between two specified periods
Excel Financial Functions	Payment Functions	CUMPRINC	Calculates the cumulative principal paid on a loan, between two specified periods
Excel Financial Functions	Payment Functions	IPMT	Calculates the interest payment for a given period of an investment, with periodic constant payments and a constant interest rate
Excel Financial Functions	Payment Functions	ISPMT	Returns the interest paid during a specified period of an investment
Excel Financial Functions	Payment Functions	PMT	Calculates the payments required to reduce a loan, from a supplied present value to a specified future value
Excel Financial Functions	Payment Functions	PPMT	Calculates the payment on the principal for a given investment, with periodic constant payments and a constant interest rate
Excel Financial Functions	Interest Rate Functions	ACCRINT	Calculates the accrued interest for a security that pays periodic interest
Excel Financial Functions	Interest Rate Functions	ACCRINTM	Calculates the accrued interest for a security that pays interest at maturity
Excel Financial Functions	Interest Rate Functions	EFFECT	Calculates the effective annual interest rate
Excel Financial Functions	Interest Rate Functions	INTRATE	Calculates the interest rate for a fully invested security
Excel Financial Functions	Interest Rate Functions	NOMINAL	Calculates the annual nominal interest rate
Excel Financial Functions	Interest Rate Functions	RATE	Calculates the interest rate required to pay off a specified amount of a loan, or reach a target amount on an investment over a given period
Excel Financial Functions	Interest Rate Functions	RRI	Calculates an equivalent interest rate for the growth of an investment (New in Excel 2013)
Excel Financial Functions	Yield Functions	YIELD	Calculates the yield of a security that pays periodic interest
Excel Financial Functions	Yield Functions	YIELDDISC	Calculates the annual yield of a discounted security
Excel Financial Functions	Yield Functions	YIELDMAT	Calculates the annual yield of a security that pays interest at maturity
Excel Financial Functions	Yield Functions	ODDFYIELD	Calculates the yield of a security with an odd first period
Excel Financial Functions	Yield Functions	ODDLYIELD	Calculates the yield of a security with an odd last period
Excel Financial Functions	Yield Functions	TBILLEQ	Calculates the bond-equivalent yield for a treasury bill
Excel Financial Functions	Yield Functions	TBILLYIELD	Calculates the yield for a treasury bill
Excel Financial Functions	Duration Functions	COUPDAYBS	Calculates the number of days from the beginning of the coupon period to the settlement date
Excel Financial Functions	Duration Functions	COUPDAYS	Calculates the number of days in the coupon period that contains the settlement date
Excel Financial Functions	Duration Functions	COUPDAYSNC	Calculates the number of days from the settlement date to the next coupon date
Excel Financial Functions	Duration Functions	COUPNCD	Returns the next coupon date after the settlement date
Excel Financial Functions	Duration Functions	COUPNUM	Returns the number of coupons payable between the settlement date and maturity date
Excel Financial Functions	Duration Functions	COUPPCD	Returns the previous coupon date, before the settlement date
Excel Financial Functions	Duration Functions	DURATION	Calculates the Macauley duration of a security with an assumed par value of $100
Excel Financial Functions	Duration Functions	MDURATION	Calculates the Macauley modified duration for a security with an assumed par value of $100
Excel Financial Functions	Duration Functions	NPER	Returns the number of periods for an investment with periodic constant payments and a constant interest rate
Excel Financial Functions	Duration Functions	PDURATION	Calculates the number of periods required for an investment to reach a specified value (New in Excel 2013)
Excel Engineering Functions	Converting Between Units of Measurement	CONVERT	Converts a number from one measurement system to another
Excel Engineering Functions	Bessel Functions	BESSELI	Calculates the modified Bessel function In(x)
Excel Engineering Functions	Bessel Functions	BESSELJ	Calculates the Bessel function Jn(x)
Excel Engineering Functions	Bessel Functions	BESSELK	Calculates the modified Bessel function Kn(x)
Excel Engineering Functions	Bessel Functions	BESSELY	Calculates the modified Bessel function Yn(x)
Excel Engineering Functions	Converting Between Bases	BIN2DEC	Converts a binary number to a decimal
Excel Engineering Functions	Converting Between Bases	BIN2HEX	Converts a binary number to hexadecimal
Excel Engineering Functions	Converting Between Bases	BIN2OCT	Converts a binary number to octal
Excel Engineering Functions	Converting Between Bases	DEC2BIN	Converts a decimal number to binary
Excel Engineering Functions	Converting Between Bases	DEC2HEX	Converts a decimal number to hexadecimal
Excel Engineering Functions	Converting Between Bases	DEC2OCT	Converts a decimal number to octal
Excel Engineering Functions	Converting Between Bases	HEX2BIN	Converts a hexadecimal number to binary
Excel Engineering Functions	Converting Between Bases	HEX2DEC	Converts a hexadecimal number to a decimal
Excel Engineering Functions	Converting Between Bases	HEX2OCT	Converts a hexadecimal number to octal
Excel Engineering Functions	Converting Between Bases	OCT2BIN	Converts octal number to binary
Excel Engineering Functions	Converting Between Bases	OCT2DEC	Converts octal number to a decimal
Excel Engineering Functions	Converting Between Bases	OCT2HEX	Converts octal number to hexadecimal
Excel Engineering Functions	The Error Function	ERF	Returns the error function integrated between two supplied limits
Excel Engineering Functions	The Error Function	ERF.PRECISE	Returns the error function integrated between 0 and a supplied limit (New in Excel 2010)
Excel Engineering Functions	The Error Function	ERFC	Returns the complementary error function integrated between a supplied lower limit and infinity
Excel Engineering Functions	The Error Function	ERFC.PRECISE	Returns the complementary error function integrated between a supplied lower limit and infinity (New in Excel 2010)
Excel Engineering Functions	Bitwise Functions	BITAND	Returns a Bitwise 'And' of two numbers (New in Excel 2013)
Excel Engineering Functions	Bitwise Functions	BITOR	Returns a Bitwise 'Or' of two numbers (New in Excel 2013)
Excel Engineering Functions	Bitwise Functions	BITXOR	Returns a Bitwise 'Exclusive Or' of two numbers (New in Excel 2013)
Excel Engineering Functions	Bitwise Functions	BITLSHIFT	Returns a number shifted left by a specified number of bits (New in Excel 2013)
Excel Engineering Functions	Bitwise Functions	BITRSHIFT	Returns a number shifted right by a specified number of bits (New in Excel 2013)
Excel Engineering Functions	Testing Numeric Values	DELTA	Tests whether two supplied numbers are equal
Excel Engineering Functions	Testing Numeric Values	GESTEP	Tests whether a number is greater than a supplied threshold value
Excel Engineering Functions	Complex Numbers	COMPLEX	Converts user-supplied real and imaginary coefficients into a complex number
Excel Engineering Functions	Complex Numbers	IMABS	Returns the absolute value (the modulus) of a complex number
Excel Engineering Functions	Complex Numbers	IMAGINARY	Returns the imaginary coefficient of a complex number
Excel Engineering Functions	Complex Numbers	IMARGUMENT	Returns the argument Θ (an angle expressed in radians) of a complex number
Excel Engineering Functions	Complex Numbers	IMCONJUGATE	Returns the complex conjugate of a complex number
Excel Engineering Functions	Complex Numbers	IMCOS	Returns the cosine of a complex number
Excel Engineering Functions	Complex Numbers	IMCOSH	Returns the hyperbolic cosine of a complex number (New in Excel 2013)
Excel Engineering Functions	Complex Numbers	IMCOT	Returns the cotangent of a complex number (New in Excel 2013)
Excel Engineering Functions	Complex Numbers	IMCSC	Returns the cosecant of a complex number (New in Excel 2013)
Excel Engineering Functions	Complex Numbers	IMCSCH	Returns the hyperbolic cosecant of a complex number (New in Excel 2013)
Excel Engineering Functions	Complex Numbers	IMDIV	Returns the quotient of two supplied complex numbers
Excel Engineering Functions	Complex Numbers	IMEXP	Returns the exponential of a complex number
Excel Engineering Functions	Complex Numbers	IMLN	Returns the natural logarithm of a complex number
Excel Engineering Functions	Complex Numbers	IMLOG10	Returns the base-10 logarithm of a complex number
Excel Engineering Functions	Complex Numbers	IMLOG2	Returns the base-2 logarithm of a complex number
Excel Engineering Functions	Complex Numbers	IMPOWER	Calculates a complex number raised to a supplied power
Excel Engineering Functions	Complex Numbers	IMPRODUCT	Returns the product of up to 255 supplied complex numbers
Excel Engineering Functions	Complex Numbers	IMREAL	Returns the real coefficient of a complex number
Excel Engineering Functions	Complex Numbers	IMSEC	Returns the secant of a complex number (New in Excel 2013)
Excel Engineering Functions	Complex Numbers	IMSECH	Returns the hyperbolic secant of a complex number (New in Excel 2013)
Excel Engineering Functions	Complex Numbers	IMSIN	Returns the sine of a complex number
Excel Engineering Functions	Complex Numbers	IMSINH	Returns the hyperbolic sine of a complex number (New in Excel 2013)
Excel Engineering Functions	Complex Numbers	IMSQRT	Returns the square root of a complex number
Excel Engineering Functions	Complex Numbers	IMSUB	Subtracts two complex numbers
Excel Engineering Functions	Complex Numbers	IMSUM	Calculates the sum of two complex numbers
Excel Engineering Functions	Complex Numbers	IMTAN	Returns the tangent of a complex number (New in Excel 2013)
Excel Cube Functions	Cube Functions	CUBEKPIMEMBER	Returns a Key Performance Indicator (KPI) property and displays the KPI name in the cell (New in Excel 2007)
Excel Cube Functions	Cube Functions	CUBEMEMBER	Returns a member or tuple from the cube (New in Excel 2007)
Excel Cube Functions	Cube Functions	CUBEMEMBERPROPERTY	Returns the value of a member property from the cube (New in Excel 2007)
Excel Cube Functions	Cube Functions	CUBERANKEDMEMBER	Returns the nth, or ranked, member in a set (New in Excel 2007)
Excel Cube Functions	Cube Functions	CUBESET	Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel (New in Excel 2007)
Excel Cube Functions	Cube Functions	CUBESETCOUNT	Returns the number of items in a set (New in Excel 2007)
Excel Cube Functions	Cube Functions	CUBEVALUE	Returns an aggregated value from the cube (New in Excel 2007)
Excel Web Functions	Web Functions	ENCODEURL	Returns a URL-encoded string (New in Excel 2013)
Excel Web Functions	Web Functions	FILTERXML	Returns data from XML content, using a specified XPath (New in Excel 2013)
Excel Web Functions	Web Functions	WEBSERVICE	Returns data from a web service on the Internet or Intranet (New in Excel 2013