|
Get sum of squared deviations
|
AVEDEV(number1, [number2],…)
|
|
Get the average of a group of numbers
|
AVERAGE(number1, [number2], …)
|
|
Get the average of a group of numbers and text
|
AVERAGEA( number1, [number2], … [number_n] )
|
|
Get the average of numbers that meet criteria
|
AVERAGEIF(range, criteria, [average_range])
|
|
Average cells that match multiple criteria
|
AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
|
|
Get accrued interest periodic
|
ACCRINT( issue_date, first_interest_date, settlement_date, rate, par, frequency, [basis], [calculation_method] )
|
|
Get accrued interest at maturity
|
ACCRINTM( issue_date, maturity_date, rate, par, [basis] )
|
|
Depreciation for accounting period coefficient
|
AMORDEGRC( cost, date_purchased, first_period, salvage, period, rate, [basis] )
|
|
Depreciation for accounting period
|
AMORLINC( cost, date_purchased, first_period, salvage, period, rate, [basis] )
|
|
Get binomial distribution probability
|
BINOM.DIST( number_s, trials, probability_s, cumulative)
|
|
Returns the probability of a trial result using a binomial distribution
|
BINOM.DIST.RANGE( trials, probability_s, number_s, [number_s2] )
|
|
Get binomial distribution probability
|
BINOMDIST( number_s, trials, probability_s, cumulative )
|
|
Returns the beta cumulative distribution function
|
BETADIST ( x, alpha, beta, [A], [B] )
|
|
Returns the beta cumulative distribution function
|
BETA.DIST ( x, alpha, beta, cumulative, [A], [B] )
|
|
Returns the inverse of the cumulative distribution function for a specified beta distribution
|
BETAINV(probability, alpha, beta ,[A], [B])
|
|
Returns the inverse of the cumulative distribution function for a specified beta distribution
|
BETA.INV ( probability, alpha, beta, [A], [B] )
|
|
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
|
BINOM.INV( trials, probability_s, alpha )
|
|
Converts a binary number to decimal
|
BIN2DEC( number )
|
|
Converts a binary number to hexadecimal
|
BIN2HEX( number, [places] )
|
|
Converts a binary number to octal
|
BIN2OCT( number, [places] )
|
|
Returns a ‘Bitwise And’ of two numbers
|
BITAND( number1, number2 )
|
|
Returns a number shifted left by some number of bits
|
BITLSHIFT( number, shift_amount )
|
|
Returns a ‘Bitwise Or’ of two numbers
|
BITOR( number1, number2 )
|
|
Returns a number shifted right by some number of bits
|
BITRSHIFT( number, shift_amount )
|
|
Returns a ‘Bitwise Xor’ of two numbers
|
BITXOR( number1, number2 )
|
|
Returns the modified Bessel function In(x)
|
BESSELI( x, n )
|
|
Returns the modified Bessel function Kn(x)
|
BESSELK ( x, n )
|
|
Returns the Bessel function Yn(x)
|
BESSELLY ( x, n )
|
|
Count numbers
|
COUNT (value1, [value2], …)
|
|
Count the number of non-blank cells
|
COUNTA (value1, [value2], …)
|
|
Count cells that are blank
|
COUNTBLANK (range)
|
|
Count cells that match criteria
|
COUNTIF (range, criteria)
|
|
Count cells that match multiple criteria
|
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
|
|
Convert measurement units
|
CONVERT (number, from_unit, to_unit)
|
|
Returns the confidence interval for a population mean
|
CONFIDENCE( alpha, standard_dev, size )
|
|
Returns the confidence interval for a population mean
|
CONFIDENCE.NORM( alpha, standard_dev, size )
|
|
Returns the confidence interval for a population mean, using a Student’s t distribution
|
CONFIDENCE.T( alpha, standard_dev, size )
|
|
Returns the correlation coefficient between two data sets
|
CORREL(array1, array2)
|
|
Returns covariance, the average of the products of paired deviations
|
COVAR ( array1, array2 )
|
|
Returns covariance, the average of the products of paired deviations
|
COVARIANCE.P(array1, array2)
|
|
Returns the sample covariance, the average of the products deviations for each data point pair in two data sets
|
COVARIANCE.S(array1, array2)
|
|
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
|
CRITBINOM( trials, probability_s, alpha )
|
|
Get days from coupon period to settlement date
|
COUPDAYBS( settlement, maturity, frequency, [basis] )
|
|
Get days in coupon period incl settlement date
|
COUPDAYS( settlement, maturity, frequency, [basis] )
|
|
Get days from settlement date to next coupon date
|
COUPDAYSNC( settlement, maturity, frequency, [basis] )
|
|
Get next coupon date after settlement date
|
COUPNCD( settlement, maturity, frequency, [basis] )
|
|
Get number of coupons payable
|
COUPNUM( settlement, maturity, frequency, [basis] )
|
|
Get previous coupon date before settlement date
|
COUPPCD( settlement, maturity, frequency, [basis] )
|
|
Get cumulative interest paid on a loan
|
CUMIPMT( rate, nper, pv, start_period, end_period, type )
|
|
Get cumulative principal paid on a loan
|
CUMPRINC( rate, nper, pv, start_period, end_period, type )
|
|
Get sum of squared deviations
|
DEVSQ(number1, [number2],…)
|
|
Converts a decimal number to binary
|
DEC2BIN ( number, [places])
|
|
Converts a decimal number to hexadecimal
|
DEC2HEX ( number, [places] )
|
|
Converts a decimal number to octal
|
DEC2OCT ( number, [places] ) )
|
|
Test two values are equal
|
DELTA(number1, [number2])
|
|
Depreciation – fixed-declining balance
|
DB( cost, salvage, life, period, [month] )
|
|
Depreciation – double-declining
|
DDB (cost, salvage, life, period, [factor])
|
|
Get discount rate for a security
|
DISCUSSION ( settlement, maturity, pr, redemption, [basis] )
|
|
Convert dollar price as fraction to decimal
|
DOLLARDE(fractional dollar, fraction)
|
|
Convert price to fractional notation
|
DOLLARFR(decimal dollar, fraction)
|
|
Get annual duration with periodic interest
|
DURATION(settlement, maturity, coupon, yield, frequency, [basis])
|
|
Returns the exponential distribution
|
EXPON.DIST(x, lambda, cumulative )
|
|
Returns the error function
|
ERF( lower_limit, [upper_limit] )
|
|
Returns the error function
|
ERF.PRECISE( x )
|
|
Returns the complementary error function
|
ERFC( x )
|
|
Returns the complementary ERF function integrated between x and infinity
|
ERFC.PRECISE(x)
|
|
Get effective annual interest rate
|
EFFECT( nominal_rate, npery )
|
|
converts a number from euros to a euro member currency
|
EUROCONVERT(number, source, target, full_precision, triangulation_precision)
|
|
Returns the inverse of the F probability distribution
|
F.INV( probability, deg_freedom1, deg_freedom2
|
|
Returns the inverse of the F probability distribution
|
F.INV.RT( probability, deg_freedom1, deg_freedom2 )
|
|
Returns the inverse of the F probability distribution
|
FINV( probability, deg_freedom1, deg_freedom2 )
|
|
Returns the F probability distribution
|
F.DIST( x, deg_freedom1, deg_freedom2, cumulative)
|
|
Returns the F probability distribution
|
FDIST(x, deg_freedom1, deg_freedom2 )
|
|
Returns the F probability distribution
|
F.DIST.RT( x, deg_freedom1, deg_freedom2 )
|
|
Returns the Fisher transformation
|
FISHER( x )
|
|
Returns the inverse of the Fisher transformation
|
FISHERINV( y )
|
|
Returns the result of an F-test
|
F.TEST( array1, array2 )
|
|
Returns the result of an F-test
|
FTEST( array1, array2 )
|
|
Predict value along a linear trend
|
FORECAST(x, known_y’s, known_x’s)
|
|
Predict value with a seasonal trend
|
FORECAST.ETS( target_date, values, timeline, [seasonality], [data completion], [aggregation] )
|
|
Get confidence interval for forecast value at given date
|
FORECAST.ETS.CONFINT( target_date, values, timeline, [confidence_level], [seasonality], [data completion], [aggregation] )
|
|
Get length of the seasonal pattern
|
FORECAST.ETS.SEASONALITY( values, timeline, [data completion], [aggregation] )
|
|
Get statistical value related to forecasting
|
FORECAST.ETS.STAT( values, timeline, statistic_type, [seasonality], [data completion], [aggregation] )
|
|
Predict value along a linear trend
|
FORECAST.LINEAR( x, known_y’s, known_x’s )
|
|
Get the frequency of values in a data set
|
FREQUENCY (data_array, bins_array)
|
|
Get the future value of an investment
|
FV (rate, nper, pmt, [pv], [type])
|
|
Get future value of principal compound interest
|
FVSCHEDULE( principal, schedule)
|
|
Returns the Gamma function value
|
GAMMA( number )
|
|
Returns the gamma distribution
|
GAMMA.DIST(x,alpha,beta,cumulative)
|
|
Returns the gamma distribution
|
GAMMADIST( x, alpha, beta, cumulative )
|
|
Returns the inverse of the gamma cumulative distribution
|
GAMMA.INV( probability, alpha, beta )
|
|
Returns the inverse of the gamma cumulative distribution
|
GAMMAINV( probability, alpha, beta )
|
|
Calculate geometric mean
|
GEOMEAN( number1, [number2], ..,)
|
|
Returns the natural logarithm of the gamma function, Γ(x)
|
GAMMALN( x )
|
|
Returns the natural logarithm of the gamma function, Γ(x)
|
GAMMALN.PRECISE( x )
|
|
Returns 0.5 less than the standard normal cumulative distribution
|
GAUSS( z )
|
|
Returns values along an exponential trend
|
GROWTH( known_y’s, [known_x’s], [new_x’s], [const] )
|
|
Tests whether a number is greater than a threshold value
|
GESTEP( number, [step] )
|
|
Calculate harmonic mean
|
HARMEAN( number1, [number2], … )
|
|
Returns the hypergeometric distribution
|
HYPGEOM.DIST( sample_s, number_sample, population_s, number_pop, cumulative )
|
|
Returns the hypergeometric distribution
|
HYPGEOMDIST( sample_s, number_sample,
population_s, number_pop )
|
|
Converts a hexadecimal number to binary
|
HEX2BIN( number, [places] )
|
|
Converts a hexadecimal number to decimal
|
HEX2DEC( number )
|
|
Converts a hexadecimal number to octal
|
HEX2OCT( number, [places] )
|
|
Get intercept of linear regression line
|
INTERCEPT( known_y’s, known_x’s )
|
|
Get absolute value of complex number
|
IMABS( inumber )
|
|
Get imaginary coefficient of complex numberr
|
IMAGINARY( inumber )
|
|
Raise complex number to given power
|
IMPOWER( inumber, number )
|
|
Get product of complex numbers
|
IMPRODUCT( inumber1, inumber2, … )
|
|
Get real coefficient of complex number
|
IMREAL( inumber )
|
|
Get difference between two complex numbers
|
IMSUB( inumber1, inumber2 )
|
|
Get sum of complex numbers
|
IMSUM( inumber1, inumber2, … )
|
|
Returns the argument theta, an angle expressed in radians
|
IMARGUMENT( inumber )
|
|
Returns the complex conjugate of a complex number
|
IMCONJUGATE( inumber )
|
|
Returns the cosine of a complex number
|
IMCOS( inumber )
|
|
Returns the hyperbolic cosine of a complex number
|
IMCOSH( inumber )
|
|
Returns the cotangent of a complex number
|
IMCOT( inumber )
|
|
Returns the cosecant of a complex number
|
IMCSC( inumber )
|
|
Returns the quotient of two complex numbers
|
IMDIV( inumber1, inumber2 )
|
|
Returns the exponential of a complex number
|
IMEXP( inumber )
|
|
Returns the natural logarithm of a complex number
|
IMLN( inumber )
|
|
Returns the base-10 logarithm of a complex number
|
IMLOG10( inumber )
|
|
Returns the base-2 logarithm of a complex number
|
IMLOG2( inumber )
|
|
Returns the secant of a complex number
|
IMSEC( inumber )
|
|
Returns the sine of a complex number
|
IMSIN( inumber )
|
|
Returns the square root of a complex number
|
IMSQRT( inumber )
|
|
Returns the tangent of a complex number
|
IMTAN( inumber )
|
|
Get interest rate for fully invested security
|
INTRATE( settlement, maturity, investment, redemption, [basis] )
|
|
Get interest in given period
|
IPMT(rate, per, nper, pv, [fv], [type])
|
|
Calculate internal rate of return
|
IRR( values, [guess] )
|
|
Returns the kurtosis of a data set
|
KURT( number1, [number2], …)
|
|
Get nth largest value
|
LARGE (array, k)
|
|
Get parameters of linear trend
|
LINEST( known_y’s, [known_x’s], [const], [stats] )
|
|
Returns the parameters of an exponential trend
|
LOGEST(known_y’s, [known_x’s], [const], [stats])
|
|
Returns the inverse of the lognormal cumulative distribution
|
LOGINV( probability, mean, standard_dev )
|
|
Returns the cumulative lognormal distribution
|
LOGNORM.DIST( x, mean, standard_dev, cumulative )
|
|
Returns the cumulative lognormal distribution
|
LOGNORMDIST( x, mean, standard_dev )
|
|
Returns the inverse of the lognormal cumulative distribution
|
LOGNORM.INV( probability, mean, standard_dev )
|
|
Get the largest value
|
MAX(number1, [number2], …)
|
|
Return largest value
|
MAXA( number1, [number2], … )
|
|
Get maximum value with criteria
|
MAXIFS( max_range, criteria_range1, criteria1, [criteria_range2, criteria2], … )
|
|
Get the median of a group of numbers
|
MEDIAN (number1, [number2], …)
|
|
Get the smallest value.
|
MIN (number1, [number2], …)
|
|
Return smallest value
|
MINA(value1, [value2], …)
|
|
Get minimum value with criteria
|
MINIFS( min_range, criteria_range1, criteria1, [criteria_range2, criteria2], … )
|
|
Get most frequently occurring number
|
MODE (number1, [number2], …)
|
|
Get most frequently occurring numbers
|
MODE.MULT( number1, [number2], … )
|
|
Get most frequently occurring number
|
MODE.SNGL( number1, [number2], … )
|
|
Get Macauley modified duration par value of $100
|
MDURATION( settlement, maturity, coupon, yld, frequency, [basis] )
|
|
Calculate modified internal rate of return
|
MIRR( values, finance_rate, reinvest_rate )
|
|
Get values and areas for the normal distribution
|
NORM.DIST( x, mean, standard_dev, cumulative )
|
|
Get the inverse of normal cumulative distribution
|
NORM.INV( probability, mean, standard_dev )
|
|
Get the standard normal CDF and PDF
|
NORM.S.DIST( z, cumulative )
|
|
Returns the standard normal cumulative distribution
|
NORMDIST( x, mean, standard_dev, cumulative )
|
|
Get inverse of the standard normal cumulative distribution
|
NORMSINV( probability )
|
|
Returns the inverse of the normal cumulative distribution
|
NORMINV( probability, mean, standard_dev )
|
|
Returns the negative binomial distribution
|
NEGBINOMDIST( number_f, number_s, probability_s )
|
|
Get annual nominal interest rate
|
NOMINAL( effect_rate, npery)
|
|
Get number of periods for loan or investment
|
NPER (rate, pmt, pv, [fv], [type])
|
|
Calculate net present value
|
NPV(rate,value1,[value2],…)
|
|
Converts an octal number to binary
|
OCT2BIN( number, [places] )
|
|
Converts an octal number to decimal
|
OCT2DEC( number )
|
|
Converts an octal number to hexadecimal
|
OCT2HEX( number, [places] )
|
|
Get price per $100 odd first period
|
ODDFPRICE( settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis] )
|
|
Get yield security with odd first period
|
ODDFYIELD( settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis] )
|
|
Get price per $100 face value with odd last period
|
ODDLPRICE( settlement, maturity, last_interest, rate, yld, redemption, frequency, [basis] )
|
|
Get yield of security with odd last period
|
ODDFYIELD( settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis] )
|
|
Returns the Pearson product moment correlation coefficient
|
PEARSON( array1, array2 )
|
|
Get kth percentile
|
PERCENTILE (array, k)
|
|
Get kth percentile
|
PERCENTILE.EXC( array, k )
|
|
Get kth percentile
|
PERCENTILE.INC( array, k )
|
|
Get percentile rank, inclusive
|
PERCENTRANK( array, x, [significance] )
|
|
Get percentile rank, exclusive
|
PERCENTRANK.EXC( array, x, [significance] )
|
|
Get percentile rank, inclusive
|
PERCENTRANK.INC( array, x, [significance] )
|
|
Get number of permutations without repetitions
|
PERMUT( number, number_chosen )
|
|
Get number of permutations with repetitions
|
PERMUTATIONA( number, number_chosen )
|
|
Returns the Poisson distribution
|
POISSON.DIST( x, mean, cumulative )
|
|
Returns the Poisson distribution
|
POISSON( x, mean, cumulative )
|
|
Returns the value of the density function for a standard normal distribution
|
PHI( x )
|
|
Returns the probability that values in a range are between two limits
|
PROB( x_range, prob_range, [lower_limit], [upper_limit] )
|
|
Get periods required to reach given value
|
PDURATION( rate, pv, fv )
|
|
Get the periodic payment for a loan
|
PMT (rate, pmt, pv, [fv], [type])
|
|
Get principal payment in given period
|
PPMT ( rate, per, nper, pv, [fv], [type] )
|
|
Get price per $100 face value – periodic interest
|
PRICE( settlement, maturity, rate, yld, redemption, frequency, [basis] )
|
|
Get price per $100 discounted security
|
PRICEDISC( settlement, maturity, discount, redemption, [basis] )
|
|
Get price per $100 interest at maturity
|
PRICEMAT( settlement, maturity, issue, rate, yld, [basis] )
|
|
Get the present value of an investment
|
PV (rate, nper, pmt, [fv], [type])
|
|
Get the quartile in a data set
|
QUARTILE( array, quart )
|
|
Get the quartile in a data set
|
QUARTILE.EXC( array, quart )
|
|
Get the quartile in a data set
|
QUARTILE.INC( array, quart )
|
|
Rank a number against a range of numbers
|
RANK (number, ref, [order])
|
|
Rank a number against a range of numbers
|
RANK.AVG( number, ref, [order] )
|
|
Rank a number against a range of numbers
|
RANK.EQ( number, ref, [order] )
|
|
Returns the square of the Pearson product moment correlation coefficient
|
RSQ( known_y’s, known_x’s )
|
|
Get the interest rate per period of an annuity
|
RATE (nper, pmt, pv, [fv], [type], [guess])
|
|
Get amount received at maturity
|
RECEIVED( settlement, maturity, investment, discount, [basis] )
|
|
Get equivalent interest rate for growth
|
RRI( nper, pv, fv )
|
|
Get skewness of a distribution
|
SKEW( number1, [number2], … )
|
|
Get skewness of a distribution based on population
|
SKEW.P( number1, [number2], … )
|
|
Get slope of linear regression line
|
SLOPE( known_y’s, known_x’s )
|
|
Get nth smallest value
|
SMALL(array,k)
|
|
Calculate a normalized value (z-score)
|
STANDARDIZE( x, mean, standard_dev )
|
|
Returns the standard error of the predicted y-value for each x in the regression
|
STEYX( known_y’s, known_x’s )
|
|
Get the standard deviation in a sample
|
STDEV( number1, [number2], … )
|
|
Get standard deviation of population
|
STDEV.P( number1, [number2], … )
|
|
Get the standard deviation in a sample
|
STDEV.S( number1, [number2], … )
|
|
Get standard deviation in a sample
|
STDEVA( number1, [number2], … )
|
|
Get standard deviation of population
|
STDEVP( number1, [number2], … )
|
|
Get standard deviation for a population
|
STDEVPA (number1, [number2], …)
|
|
Depreciation – straight-line
|
SLN( cost, salvage, life )
|
|
Depreciation – sum-of-years
|
SYD(cost, salvage, life, per)
|
|
Returns the probability associated with a Student’s t-test
|
T.TEST( array1, array2, tails, type )
|
|
Returns the probability associated with a Student’s t-test
|
TTEST( array1, array2, tails, type )
|
|
Returns the inverse of the Student’s t-distribution
|
TINV( probability, degrees_freedom )
|
|
Returns the t-value of the Student’s t-distribution as a function of the probability and the degrees of freedom
|
T.INV( probability, degrees_freedom )
|
|
Returns the inverse of the Student’s t-distribution
|
T.INV.2T( probability, degrees_freedom )
|
|
Returns the Student’s t-distribution
|
TDIST( x, degrees_freedom, tails )
|
|
Returns the Percentage Points (probability) for the Student t-distribution
|
T.DIST( x, degrees_freedom, cumulative )
|
|
Returns the Percentage Points (probability) for the Student t-distribution
|
T.DIST.2T( x, degrees_freedom )
|
|
Returns the Student’s t-distribution
|
T.DIST.RT( x, degrees_freedom )
|
|
Calculate mean excluding outliers
|
TRIMMEAN( array, percent )
|
|
Get bond-equivalent yield for a Treasury bill
|
TBILLEQ( settlement, maturity, discount )
|
|
Get price per $100 Treasury bill
|
TBILLPRICE( settlement, maturity, discount )
|
|
Get yield for a Treasury bill
|
TBILLYIELD( settlement, maturity, pr )
|
|
Get variation of a sample
|
VAR( number1, [number2], … )
|
|
Get variation of population
|
VAR.P( number1, [number2], … )
|
|
Get variation of a sample
|
VAR.S( number1, [number2], … )
|
|
Get variation of a sample
|
VARA( number1, [number2], … )
|
|
Get variation of a population
|
VARP( number1, [number2], … )
|
|
Get variation of a population
|
VARPA( number1, [number2], … )
|
|
Depreciation – double-declining variable
|
VDB( cost, salvage, life, start_period, end_period, [factor], [no_switch] )
|
|
Calculates variance based on the entire population, including numbers, text, and logical values
|
WEIBULL( x, alpha, beta, cumulative)
|
|
Returns the Weibull distribution
|
WEIBULL.DIST( x, alpha, beta, cumulative )
|
|
Calculate internal rate of return for irregular cash flows
|
XIRR (values, dates,[guess])
|
|
Calculate net present value for irregular cash flows
|
XNPV(Rate, Cash Flows, Dates of Cash Flow)
|
|
Get yield for security that pays periodic interest
|
YIELD (settlement, maturity, rate, pr, redemption, frequency, [basis])
|
|
Get annual yield for discounted security
|
YIELDDISC( settlement, maturity, pr, redemption, [basis] )
|
|
Get annual yield of security interest at maturity
|
YIELDMAT( settlement, maturity, issue, rate, pr, [basis] )
|
|
Returns the one-tailed probability-value of a z-test
|
Z.TEST( array, x, [sigma] )
|
|
Returns the one-tailed probability-value of a z-test
|
ZTEST( array, x, [sigma] )
|
