Functions Excel Formulas Description

DATE =DATE(year,month,day) Returns the serial number of a particular date

DATEVALUE =DATEVALUE(date_text) Converts a date in the form of text to a serial number

DAY =DAY(serial_number) Converts a serial number to a day of the month

HOUR =HOUR(serial_number) Converts a serial number to an hour

MINUTE =MINUTE(serial_number) Converts a serial number to a minute

MONTH =MONTH(serial_number) Converts a serial number to a month

NOW =NOW() Returns the serial number of the current date and time

SECOND =SECOND(serial_number) Converts a serial number to a second

TIME =TIME(hour,minute,second) Returns the serial number of a particular time

TIMEVALUE =TIMEVALUE(time_text) Converts a time in the form of text to a serial number

TODAY =TODAY() Returns the serial number of today’s date

YEAR =YEAR(serial_number) Converts a serial number to a year

Returns information about the formatting, location, or

CELL =CELL(info_type, [reference]) contents of a cell

ISBLANK =ISBLANK(value) Returns TRUE if the value is blank

ISERROR =ISERROR(value) Returns TRUE if the value is any error value

ISNONTEXT =ISNONTEXT(value) Returns TRUE if the value is not text

ISNUMBER =ISNUMBER(value) Returns TRUE if the value is a number

 ISTEXT =ISTEXT(value) Returns TRUE if the value is text

AND =AND(logical1,logical2,…) Returns TRUE if all of its arguments are TRUE

FALSE =FALSE Returns the logical value FALSE

=IF(logical_test, [value_if_true],
IF [value_if_false]) Specifies a logical test to perform

Returns a value you specify if a formula evaluates to an

IFERROR =IFERROR(value, value_if_error) error; otherwise, returns the result of the formula

NOT =NOT(logical) Reverses the logic of its argument

OR =OR(logical1,logical2,…) Returns TRUE if any argument is TRUE

TRUE =TRUE Returns the logical value TRUE

=ADDRESS(row_num, column_num, Returns a reference as text to a single cell in a

ADDRESS [abs_num], [a1], [sheet_text]) worksheet

COLUMN =COLUMN([reference]) Returns the column number of a reference

COLUMNS =COLUMNS(array) Returns the number of columns in a reference

=HLOOKUP(lookup_value,table_array,r Looks in the top row of an array and returns the value of
HLOOKUP ow_index_num,[range_lookup]) the indicated cell

=INDEX(array,row_num,[column_num]) Uses an index to choose a value from a reference or

INDEX – 2 types array

INDIRECT =INDIRECT(ref_text,a1) Returns a reference indicated by a text value

=LOOKUP(lookup_value, array) –2
LOOKUP types Looks up values in a vector or array

=MATCH(lookup_value,lookup_array,m
MATCH atch_type) Looks up values in a reference or array
 =OFFSET(reference,rows,cols,height,w
OFFSET idth) Returns a reference offset from a given reference

ROW =ROW([reference]) Returns the row number of a reference

ROWS =ROWS(array) Returns the number of rows in a reference

=VLOOKUP(lookup_value,table_array,c Looks in the first column of an array and moves across

VLOOKUP ol_index_num,[range_lookup]) the row to return the value of a cell

ABS =ABS(number) Returns the absolute value of a number

PRODUCT =PRODUCT(number1,number2,…) Multiplies its arguments

RAND =RAND() Returns a random number between 0 and 1

Returns a random number between the numbers you

RANDBETWEEN =RANDBETWEEN(bottom,top) specify

ROUND =ROUND(number,num_digits) Rounds a number to a specified number of digits

ROUNDDOWN =ROUNDDOWN(number,num_digits) Rounds a number down, toward zero

ROUNDUP =ROUNDUP(number,num_digits) Rounds a number up, away from zero

SUBTOTAL =SUBTOTAL(function_num,ref1,…) Returns a subtotal in a list or database

SUM =SUM(number1,number2,…) Adds its arguments

SUMIF =SUMIF(range,criteria,[sum_range]) Adds the cells specified by a given criteria

=SUMIFS(sum_range,criteria_range,crit
SUMIFS eria,…) Adds the cells in a range that meet multiple criteria

=SUMPRODUCT(array1,array2, Returns the sum of the products of corresponding array

SUMPRODUCT [array3],…) components

AVERAGE =AVERAGE(number1,number2,…) Returns the average of its arguments

 =AVERAGEIF(range,criteria, Returns the average (arithmetic mean) of all the cells in
AVERAGEIF [average_range]) a range that meet a given criteria

COUNT =COUNT(value1,value2,…) Counts how many numbers are in the list of arguments

COUNTA =COUNTA(value1,value2,…) Counts how many values are in the list of arguments

COUNTBLANK =COUNTBLANK(range) Counts the number of blank cells within a range

Counts the number of cells within a range that meet the

COUNTIF =COUNTIF(range,criteria) given criteria

Counts the number of cells within a range that meet

COUNTIFS =COUNTIFS(criteria_range,criteria,…) multiple criteria

MAX =MAX(number1,number2,…) Returns the maximum value in a list of arguments

MEDIAN =MEDIAN(number1,number2,…) Returns the median of the given numbers

MIN =MIN(number1,number2,…) Returns the minimum value in a list of arguments

Joins several text items into one text item. Easier to

CONCATENATE =CONCATENATE(text1,text2,…) use ‘&’ instead of the function usually.

EXACT =EXACT(text1,text2) Checks to see if two text values are identical

FIND =FIND(find_text,within_text,start_num) Finds one text value within another (case-sensitive)

LEFT =LEFT(text,num_chars) Returns the leftmost characters from a text value

LEN =LEN(text) Returns the number of characters in a text string

LOWER =LOWER(text) Converts text to lowercase

Returns a specific number of characters from a text

MID =MID(text,start_num,num_chars) string starting at the position you specify

PROPER =PROPER(text) Capitalizes the first letter in each word of a text value
 =REPLACE(old_text,start_num,num_ch
REPLACE ars,new_text) Replaces characters within text

RIGHT =RIGHT(text,num_chars) Returns the rightmost characters from a text value

=SEARCH(find_text,within_text,start_n
SEARCH um) Finds one text value within another (not case-sensitive)

TEXT =TEXT(value,format_text) Formats a number and converts it to text

TRIM =TRIM(text) Removes spaces from text

UPPER =UPPER(text) Converts text to uppercase

Extracts from a database a single record that matches

DGET =DGET(database,field,criteria) the specified criteria

Adds the numbers in the field column of records in the

DSUM =DSUM(database,field,criteria) database that match the criteria

=DAYS360(start_date,end_date,metho Calculates the number of days between two dates

DAYS360 d) based on a 360-day year

Returns the serial number of the date that is the

indicated number of months before or after the start
EDATE =EDATE(start_date,months) date

Returns the serial number of the last day of the month

EOMONTH =EOMONTH(start_date,months) before or after a specified number of months

=NETWORKDAYS(start_date,end_date Returns the number of whole workdays between two

NETWORKDAYS ,[holidays]) dates

Returns the number of whole workdays between two

NETWORKDAYS.IN =NETWORKDAYS.INTL(start_date,end dates using parameters to indicate which and how
TL _date,[weekend],[holidays]) many days are weekend days

=WEEKDAY(serial_number,
WEEKDAY [return_type]) Converts a serial number to a day of the week

WEEKNUM =WEEKNUM(serial_number, Converts a serial number to a number representing

 [return_type]) where the week falls numerically with a year

=WORKDAY(start_date, days, Returns the serial number of the date before or after a
WORKDAY [holidays]) specified number of workdays

Returns the serial number of the date before or after a

=WORKDAY.INTL(start_date,days,wee specified number of workdays using parameters to
WORKDAY.INTL kend,holidays) indicate which and how many days are weekend days

=YEARFRAC(start_date,end_date,basi Returns the year fraction representing the number of

YEARFRAC s) whole days between start_date and end_date

Converts a number from one measurement system to

CONVERT =CONVERT(number,from_unit,to_unit) another

DELTA =DELTA(number1,number2) Tests whether two values are equal

ERF =ERF(lower_limit,upper_limit) Returns the error function

ERFC =ERFC(x) Returns the complementary error function

Tests whether a number is greater than a threshold

GESTEP =GESTEP(number,step) value

=AMORDEGRC(cost,date_purchased,fi Returns the depreciation for each accounting period by

AMORDEGRC rst_period,salvage,period,rate,basis) using a depreciation coefficient

=AMORLINC(cost,date_purchased,first
AMORLINC _period,salvage,period,rate,basis) Returns the depreciation for each accounting period

Converts a dollar price, expressed as a fraction, into a

DOLLARDE =DOLLARDE(fractional_dollar,fraction) dollar price, expressed as a decimal number

Converts a dollar price, expressed as a decimal

DOLLARFR =DOLLARFR(decimal_dollar,fraction) number, into a dollar price, expressed as a fraction

Returns the straight-line depreciation of an asset for

SLN =SLN(cost,salvage,life) one period
 Returns the sum-of-years’ digits depreciation of an
SYD =SYD(cost,salvage,life,per) asset for a specified period

ERROR.TYPE =ERROR.TYPE(error_val) Returns a number corresponding to an error type

Returns information about the current operating

INFO =INFO(type_text) environment

Returns TRUE if the value is any error value except

ISERR =ISERR(value) #N/A

ISEVEN =ISEVEN(number) Returns TRUE if the number is even

ISLOGICAL =ISLOGICAL(value) Returns TRUE if the value is a logical value

ISNA =ISNA(value) Returns TRUE if the value is the #N/A error value

ISODD =ISODD(number) Returns TRUE if the number is odd

ISREF =ISREF(value) Returns TRUE if the value is a reference

N =N(value) Returns a value converted to a number

NA =NA() Returns the error value #N/A

TYPE =TYPE(value) Returns a number indicating the data type of a value

=CHOOSE(index_num,value1,value2,
CHOOSE …) Chooses a value from a list of values

=GETPIVOTDATA(data_field,pivot_tabl
GETPIVOTDATA e,field,item,…) Returns data stored in a PivotTable report

=HYPERLINK(link_location,friendly_na Creates a shortcut or jump that opens a document

HYPERLINK me) stored on a network server, an intranet, or the Internet

TRANSPOSE =TRANSPOSE(array) Returns the transpose of an array

 Rounds a number to the nearest integer or to the
CEILING =CEILING(number,significance) nearest multiple of significance

Rounds a number the nearest integer or to the nearest

=CEILING.PRECISE(number,significan multiple of significance. Regardless of the sign of the
CEILING.PRECISE ce) number, the number is rounded up.

EVEN =EVEN(number) Rounds a number up to the nearest even integer

EXP =EXP(number) Returns e raised to the power of a given number

FACT =FACT(number) Returns the factorial of a number

FLOOR =FLOOR(number,significance) Rounds a number down, toward zero

Rounds a number the nearest integer or to the nearest

=FLOOR.PRECISE(number,significanc multiple of significance. Regardless of the sign of the
FLOOR.PRECISE e) number, the number is rounded up.

GCD =GCD(number1,number2,…) Returns the greatest common divisor

INT =INT(number) Rounds a number down to the nearest integer

Returns a number that is rounded up to the nearest

ISO.CEILING =ISO.CEILING(number,significance) integer or to the nearest multiple of significance

LCM =LCM(number1,number2,…) Returns the least common multiple

MOD =MOD(number,divisor) Returns the remainder from division

MROUND =MROUND(number,multiple) Returns a number rounded to the desired multiple

ODD =ODD(number) Rounds a number up to the nearest odd integer

PI =PI() Returns the value of pi

POWER =POWER(number,power) Returns the result of a number raised to a power

QUOTIENT =QUOTIENT(numerator,denominator) Returns the integer portion of a division

 Returns the sum of a power series based on the
SERIESSUM =SERIESSUM(x,n,m,coefficients) formula

SIGN =SIGN(number) Returns the sign of a number

SQRT =SQRT(number) Returns a positive square root

SUMSQ =SUMSQ(number1,number2,…) Returns the sum of the squares of the arguments

TRUNC =TRUNC(number,num_digits) Truncates a number to an integer

Returns the average of its arguments, including

AVERAGEA =AVERAGEA(value1,value2,…) numbers, text, and logical values

=AVERAGEIFS(average_range,criteria Returns the average (arithmetic mean) of all cells that

AVERAGEIFS _range,criteria,…) meet multiple criteria.

GEOMEAN =GEOMEAN(number1,number2,…) Returns the geometric mean

INTERCEPT =INTERCEPT(known_y’s,known_x’s) Returns the intercept of the linear regression line

LARGE =LARGE(array,k) Returns the k-th largest value in a data set

=LINEST(known_y’s,known_x’s,const,s
LINEST tats) Returns the parameters of a linear trend

=LOGEST(known_y’s,known_x’s,const,
LOGEST stats) Returns the parameters of an exponential trend

Returns the maximum value in a list of arguments,

MAXA =MAXA(value1,value2,…) including numbers, text, and logical values

Returns the smallest value in a list of arguments,

MINA =MINA(value1,value2,…) including numbers, text, and logical values

Returns a vertical array of the most frequently

occurring, or repetitive values in an array or range of
MODE.MULT =MODE.MULT(number1,number2,…) data

MODE.SNGL =MODE.SNGL(number1,number2,…) Returns the most common value in a data set

 =PROB(x_range,prob_range,lower_limi Returns the probability that values in a range are
PROB t,upper_limit) between two limits

RANK.AVG =RANK.AVG(number,ref,order) Returns the rank of a number in a list of numbers

RANK.EQ =RANK.EQ(number,ref,order) Returns the rank of a number in a list of numbers

SKEW =SKEW(number1,number2,…) Returns the skewness of a distribution

SLOPE =SLOPE(known_y’s,known_x’s) Returns the slope of the linear regression line

SMALL =SMALL(array,k) Returns the k-th smallest value in a data set

=STANDARDIZE(x,mean,standard_dev
STANDARDIZE ) Returns a normalized value

=TREND(known_y’s,known_x’s,new_x’
TREND s,const) Returns values along a linear trend

CHAR =CHAR(number) Returns the character specified by the code number

CLEAN =CLEAN(text) Removes all nonprintable characters from text

Returns a numeric code for the first character in a text

CODE =CODE(text) string

Converts a number to text, using the $ (dollar) currency

DOLLAR =DOLLAR(number,decimals) format

Formats a number as text with a fixed number of

FIXED =FIXED(number,decimals,no_commas) decimals

Extracts the phonetic (furigana) characters from a text

PHONETIC =PHONETIC(reference) string

REPT =REPT(text,number_times) Repeats text a given number of times

=SUBSTITUTE(text,old_text,new_text,i
SUBSTITUTE nstance_num) Substitutes new text for old text in a text string
 T =T(value) Converts its arguments to text

VALUE =VALUE(text) Converts a text argument to a number

=BINOMDIST(number_s,trials,probabilit Returns the individual term binomial distribution

BINOMDIST y_s,cumulative) probability

Returns the one-tailed probability of the chi-squared

CHIDIST =CHIDIST(x,deg_freedom) distribution

Returns the inverse of the one-tailed probability of the

CHIINV =CHIINV(probability,deg_freedom) chi-squared distribution

=CHITEST(actual_range,expected_ran
CHITEST ge) Returns the test for independence

=CONFIDENCE(alpha,standard_dev,si
CONFIDENCE ze) Returns the confidence interval for a population mean

FTEST =FTEST(array1,array2)

=LOGINV(probability,mean,standard_d Returns the inverse of the lognormal cumulative

LOGINV ev) distribution

=LOGNORMDIST(x,mean,standard_de
LOGNORMDIST v) Returns the cumulative lognormal distribution

MODE =MODE(number1,number2,…) Returns the most common value in a data set

=NORMDIST(x,mean,standard_dev,cu
NORMDIST mulative) Returns the normal cumulative distribution

=NORMINV(probability,mean,standard_ Returns the inverse of the normal cumulative

NORMINV dev) distribution

NORMSDIST =NORMSDIST(z) Returns the standard normal cumulative distribution

Returns the inverse of the standard normal cumulative

NORMSINV =NORMSINV(probability) distribution
PERCENTILE =PERCENTILE(array,k) Returns the k-th percentile of values in a range

PERCENTRANK =PERCENTRANK(array,x,significance) Returns the percentage rank of a value in a data set

POISSON =POISSON(x,mean,cumulative) Returns the Poisson distribution

QUARTILE =QUARTILE(array,quart) Returns the quartile of a data set

RANK =RANK(number,ref,order) Returns the rank of a number in a list of numbers

STDEV =STDEV(number1,number2,…) Estimates standard deviation based on a sample

Calculates standard deviation based on the entire

STDEVP =STDEVP(number1,number2,…) population

TDIST =TDIST(x,deg_freedom,tails) Returns the Student’s t-distribution

TINV =TINV(probability,deg_freedom) Returns the inverse of the Student’s t-distribution

VAR =VAR(number1,number2,…) Estimates variance based on a sample

VARP =VARP(number1,number2,…) Calculates variance based on the entire population

DAVERAGE =DAVERAGE(database,field,criteria) Returns the average of selected database entries

DCOUNT =DCOUNT(database,field,criteria) Counts the cells that contain numbers in a database

DCOUNTA =DCOUNTA(database,field,criteria) Counts nonblank cells in a database

Returns the maximum value from selected database

DMAX =DMAX(database,field,criteria) entries

Returns the minimum value from selected database

DMIN =DMIN(database,field,criteria) entries

Multiplies the values in a particular field of records that

DPRODUCT =DPRODUCT(database,field,criteria) match the criteria in a database
 Estimates the standard deviation based on a sample of
DSTDEV =DSTDEV(database,field,criteria) selected database entries

Calculates the standard deviation based on the entire

DSTDEVP =DSTDEVP(database,field,criteria) population of selected database entries

Estimates variance based on a sample from selected

DVAR =DVAR(database,field,criteria) database entries

Calculates variance based on the entire population of

DVARP =DVARP(database,field,criteria) selected database entries

ERF.PRECISE =ERF.PRECISE(X) Returns the error function

Returns the complementary ERF function integrated

ERFC.PRECISE =ERFC.PRECISE(X) between x and infinity

Returns the depreciation of an asset for a specified

DB =DB(cost,salvage,life,period,month) period by using the fixed-declining balance method

Returns the depreciation of an asset for a specified

period by using the double-declining balance method or
DDB =DDB(cost,salvage,life,period,factor) some other method that you specify

EFFECT =EFFECT(nominal_rate,npery) Returns the effective annual interest rate

FV =FV(rate,nper,pmt,pv,type) Returns the future value of an investment

Returns the interest payment for an investment for a

IPMT =IPMT(rate,per,nper,pv,fv,type) given period

Returns the internal rate of return for a series of cash

IRR =IRR(values,guess) flows

=MIRR(values,finance_rate,reinvest_rat Returns the internal rate of return where positive and

MIRR e) negative cash flows are financed at different rates

NOMINAL =NOMINAL(effect_rate,npery) Returns the annual nominal interest rate

NPER =NPER(rate,pmt,pv,fv,type) Returns the number of periods for an investment

 Returns the net present value of an investment based
NPV =NPV(rate,value1,value2,…) on a series of periodic cash flows and a discount rate

PV =PV(rate,nper,pmt,fv,type) Returns the present value of an investment

RATE =RATE(nper,pmt,pv,fv,type,guess) Returns the interest rate per period of an annuity

=YIELD(settlement,maturity,rate,pr,rede Returns the yield on a security that pays periodic

YIELD mption,frequency,basis) interest

AREAS =AREAS(reference) Returns the number of areas in a reference

Retrieves real-time data from a program that supports

COM automation (Automation: A way to work with an
application’s objects from another application or
development tool. Formerly called OLE Automation,
Automation is an industry standard and a feature of the
RTD =RTD(progID,server,topic1,topic2,…) Component Object Model (COM).)

=AGGREGATE(function_num,options,a
AGGREGATE rray,k) Returns an aggregate in a list or database

Returns the number of combinations for a given number

COMBIN =COMBIN(number,number_chosen) of objects

COS =COS(number) Returns the cosine of a number

COSH =COSH(number) Returns the hyperbolic cosine of a number

FACTDOUBLE =FACTDOUBLE(number) Returns the double factorial of a number

LN =LN(number) Returns the natural logarithm of a number

LOG =LOG(number,base) Returns the logarithm of a number to a specified base

LOG10 =LOG10(number) Returns the base-10 logarithm of a number

MULTINOMIAL =MULTINOMIAL(number1,number2,…) Returns the multinomial of a set of numbers

SIN =SIN(number) Returns the sine of the given angle

SINH =SINH(number) Returns the hyperbolic sine of a number

Returns the sum of the difference of squares of

SUMX2MY2 =SUMX2MY2(array_x,array_y) corresponding values in two arrays

Returns the sum of the sum of squares of

SUMX2PY2 =SUMX2PY2(array_x,array_y) corresponding values in two arrays

Returns the sum of squares of differences of

SUMXMY2 =SUMXMY2(array_x,array_y) corresponding values in two arrays

TAN =TAN(number) Returns the tangent of a number

TANH =TANH(number) Returns the hyperbolic tangent of a number

Returns the inverse of the standard normal cumulative

NORM.S.INV =NORM.S.INV(probability) distribution

Returns the average of the absolute deviations of data

AVEDEV =AVEDEV(number1,number2,…) points from their mean

=BETA.DIST(x,alpha,beta,cumulative,A
BETA.DIST ,B) Returns the beta cumulative distribution function

Returns the inverse of the cumulative distribution

BETA.INV =BETA.INV(probability,alpha,beta,A,B) function for a specified beta distribution

=BINOM.DIST(number_s,trials,probabili Returns the individual term binomial distribution

BINOM.DIST ty_s,cumulative) probability

Returns the smallest value for which the cumulative

binomial distribution is less than or equal to a criterion
BINOM.INV =BINOM.INV(trials,probability_s,alpha) value

=CHISQ.DIST(x,deg_freedom,cumulati
CHISQ.DIST ve) Returns the cumulative beta probability density function
 Returns the one-tailed probability of the chi-squared
CHISQ.DIST.RT =CHISQ.DIST.RT(x,deg_freedom) distribution

CHISQ.INV =CHISQ.INV(probability,deg_freedom) Returns the cumulative beta probability density function

=CHISQ.INV.RT(probability,deg_freedo Returns the inverse of the one-tailed probability of the

CHISQ.INV.RT m) chi-squared distribution

=CHISQ.TEST(actual_range,expected_
CHISQ.TEST range) Returns the test for independence

CONFIDENCE.NOR =CONFIDENCE.NORM(alpha,standard
M _dev,size) Returns the confidence interval for a population mean

=CONFIDENCE.T(alpha,standard_dev, Returns the confidence interval for a population mean,

CONFIDENCE.T size) using a Student’s t distribution

Returns the correlation coefficient between two data

CORREL =CORREL(array1,array2) sets

Returns covariance, the average of the products of

COVARIANCE.P =COVARIANCE.P(array1,array2) paired deviations

Returns the sample covariance, the average of the

products deviations for each data point pair in two data
COVARIANCE.S =COVARIANCE.S(array1,array2) sets

DEVSQ =DEVSQ(number1,number2,…) Returns the sum of squares of deviations

EXPON.DIST =EXPON.DIST(x,lambda,cumulative) Returns the exponential distribution

=F.DIST(x,deg_freedom1,deg_freedom
F.DIST 2,cumulative) Returns the F probability distribution

=F.DIST.RT(x,deg_freedom1,deg_freed
F.DIST.RT om2) Returns the F probability distribution

=F.INV(probability,deg_freedom1,deg_f
F.INV reedom2) Returns the inverse of the F probability distribution
 =F.INV.RT(probability,deg_freedom1,d
F.INV.RT eg_freedom2) Returns the inverse of the F probability distribution

F.TEST =F.TEST(array1,array2) Returns the result of an F-test

=FINV(probability,deg_freedom1,deg_fr
FINV eedom2) Returns the inverse of the F probability distribution

FISHER =FISHER(x) Returns the Fisher transformation

FISHERINV =FISHERINV(y) Returns the inverse of the Fisher transformation

FORECAST =FORECAST(x,known_y’s,known_x’s) Returns a value along a linear trend

FREQUENCY =FREQUENCY(data_array,bins_array) Returns a frequency distribution as a vertical array

=GAMMA.DIST(x,alpha,beta,cumulativ
GAMMA.DIST e) Returns the gamma distribution

Returns the inverse of the gamma cumulative

GAMMA.INV =GAMMA.INV(probability,alpha,beta) distribution

Returns the natural logarithm of the gamma function,

GAMMALN =GAMMALN(x) Γ(x)

GAMMALN.PRECIS Returns the natural logarithm of the gamma function,

E =GAMMALN.PRECISE(x) Γ(x)

=GROWTH(known_y’s,known_x’s,new
GROWTH _x’s,const) Returns values along an exponential trend

HARMEAN =HARMEAN(number1,number2,…) Returns the harmonic mean

=HYPGEOM.DIST(sample_s,number_s
ample,population_s,number_pop,cumul
HYPGEOM.DIST ative) Returns the hypergeometric distribution

KURT =KURT(number1,number2,…) Returns the kurtosis of a data set

LOGNORM.DIST =LOGNORM.DIST(x,mean,standard_d Returns the cumulative lognormal distribution

 ev,cumulative)

=LOGNORM.INV(probability,mean,stan Returns the inverse of the lognormal cumulative

LOGNORM.INV dard_dev) distribution

=NEGBINOM.DIST(number_f,number_
NEGBINOM.DIST s,probability_s,cumulative) Returns the negative binomial distribution

=NORM.DIST(x,mean,standard_dev,cu
NORM.DIST mulative) Returns the normal cumulative distribution

=NORM.INV(probability,mean,standard Returns the inverse of the normal cumulative

NORM.INV _dev) distribution

NORM.S.DIST =NORM.S.DIST(z,cumulative) Returns the standard normal cumulative distribution

Returns the Pearson product moment correlation

PEARSON =PEARSON(array1,array2) coefficient

Returns the k-th percentile of values in a range, where k

PERCENTILE.EXC =PERCENTILE.EXC(array,k) is in the range 0..1, exclusive

PERCENTILE.INC =PERCENTILE.INC(array,k) Returns the k-th percentile of values in a range

PERCENTRANK.EX =PERCENTRANK.EXC(array,x,signific Returns the rank of a value in a data set as a

C ance) percentage (0..1, exclusive) of the data set

PERCENTRANK.IN =PERCENTRANK.INC(array,x,significa
C nce) Returns the percentage rank of a value in a data set

Returns the number of permutations for a given number

PERMUT =PERMUT(number,number_chosen) of objects

POISSON.DIST =POISSON.DIST(x,mean,cumulative) Returns the Poisson distribution

Returns the quartile of the data set, based on percentile

QUARTILE.EXC =QUARTILE.EXC(array,quart) values from 0..1, exclusive

QUARTILE.INC =QUARTILE.INC(array,quart) Returns the quartile of a data set

 Returns the square of the Pearson product moment
RSQ =RSQ(known_y’s,known_x’s) correlation coefficient

Calculates standard deviation based on the entire

STDEV.P =STDEV.P(number1,number2,…) population

STDEV.S =STDEV.S(number1,number2,…) Estimates standard deviation based on a sample

Estimates standard deviation based on a sample,

STDEVA =STDEVA(value1,value2,…) including numbers, text, and logical values

Calculates standard deviation based on the entire

STDEVPA =STDEVPA(value1,value2,…) population, including numbers, text, and logical values

Returns the standard error of the predicted y-value for

STEYX =STEYX(known_y’s,known_x’s) each x in the regression

Returns the Percentage Points (probability) for the

T.DIST =T.DIST(x,deg_freedom,cumulative) Student t-distribution

Returns the Percentage Points (probability) for the

T.DIST.2T =T.DIST.2T(x,deg_freedom) Student t-distribution

T.DIST.RT =T.DIST.RT(x,deg_freedom) Returns the Student’s t-distribution

Returns the t-value of the Student’s t-distribution as a

T.INV =T.INV(probability,deg_freedom) function of the probability and the degrees of freedom

T.INV.2T =T.INV.2T(probability,deg_freedom) Returns the inverse of the Student’s t-distribution

Returns the probability associated with a Student’s t-

T.TEST =T.TEST(array1,array2,tails,type) test

TRIMMEAN =TRIMMEAN(array,percent) Returns the mean of the interior of a data set

VAR.P =VAR.P(number1,number2,…) Calculates variance based on the entire population

VAR.S =VAR.S(number1,number2,…) Estimates variance based on a sample

 Estimates variance based on a sample, including
VARA =VARA(value1,value2,…) numbers, text, and logical values

Calculates variance based on the entire population,

VARPA =VARPA(value1,value2,…) including numbers, text, and logical values

=WEIBULL.DIST(x,alpha,beta,cumulati
WEIBULL.DIST ve) Returns the Weibull distribution

Z.TEST =Z.TEST(array,x,sigma) Returns the one-tailed probability-value of a z-test

Changes full-width (double-byte) English letters or

katakana within a character string to half-width (single-
ASC =ASC(text) byte) characters

BETADIST =BETADIST(x,alpha,beta,A,B) Returns the beta cumulative distribution function

Returns the inverse of the cumulative distribution

BETAINV =BETAINV(probability,alpha,beta,A,B) function for a specified beta distribution

Returns covariance, the average of the products of

COVAR =COVAR(array1,array2) paired deviations

Returns the smallest value for which the cumulative

binomial distribution is less than or equal to a criterion
CRITBINOM =CRITBINOM(trials,probability_s,alpha) value

EXPONDIST =EXPONDIST(x,lambda,cumulative) Returns the exponential distribution

=FDIST(x,deg_freedom1,deg_freedom
FDIST 2) Returns the F probability distribution

=GAMMADIST(x,alpha,beta,cumulative
GAMMADIST ) Returns the gamma distribution

Returns the inverse of the gamma cumulative

GAMMAINV =GAMMAINV(probability,alpha,beta) distribution

=HYPGEOMDIST(sample_s,number_s
HYPGEOMDIST ample,population_s,number_pop) Returns the hypergeometric distribution
 =NEGBINOMDIST(number_f,number_s
NEGBINOMDIST ,probability_s) Returns the negative binomial distribution

Returns the probability associated with a Student’s t-

TTEST =TTEST(array1,array2,tails,type) test

Calculates variance based on the entire population,

WEIBULL =WEIBULL(x,alpha,beta,cumulative) including numbers, text, and logical values

ZTEST =ZTEST(array,x,sigma) Returns the one-tailed probability-value of a z-test

BESSELI =BESSELI(x,n) Returns the modified Bessel function In(x)

BESSELJ =BESSELJ(x,n) Returns the Bessel function Jn(x)

BESSELK =BESSELK(x,n) Returns the modified Bessel function Kn(x)

BESSELY =BESSELY(x,n) Returns the Bessel function Yn(x)

BIN2DEC =BIN2DEC(number) Converts a binary number to decimal

BIN2HEX =BIN2HEX(number,places) Converts a binary number to hexadecimal

BIN2OCT =BIN2OCT(number,places) Converts a binary number to octal

Converts real and imaginary coefficients into a complex

COMPLEX =COMPLEX(real_num,i_num,suffix) number

DEC2BIN =DEC2BIN(number,places) Converts a decimal number to binary

DEC2HEX =DEC2HEX(number,places) Converts a decimal number to hexadecimal

DEC2OCT =DEC2OCT(number,places) Converts a decimal number to octal

HEX2BIN =HEX2BIN(number,places) Converts a hexadecimal number to binary

HEX2DEC =HEX2DEC(number) Converts a hexadecimal number to decimal

 HEX2OCT =HEX2OCT(number,places) Converts a hexadecimal number to octal

Returns the absolute value (modulus) of a complex

IMABS =IMABS(inumber) number

IMAGINARY =IMAGINARY(inumber) Returns the imaginary coefficient of a complex number

Returns the argument theta, an angle expressed in

IMARGUMENT =IMARGUMENT(inumber) radians

IMCONJUGATE =IMCONJUGATE(inumber) Returns the complex conjugate of a complex number

IMCOS =IMCOS(inumber) Returns the cosine of a complex number

IMDIV =IMDIV(inumber1,inumber2) Returns the quotient of two complex numbers

IMEXP =IMEXP(inumber) Returns the exponential of a complex number

IMLN =IMLN(inumber) Returns the natural logarithm of a complex number

IMLOG10 =IMLOG10(inumber) Returns the base-10 logarithm of a complex number

IMLOG2 =IMLOG2(inumber) Returns the base-2 logarithm of a complex number

IMPOWER =IMPOWER(inumber,number) Returns a complex number raised to an integer power

IMPRODUCT =IMPRODUCT(inumber1,inumber2,…) Returns the product of complex numbers

IMREAL =IMREAL(inumber) Returns the real coefficient of a complex number

IMSIN =IMSIN(inumber) Returns the sine of a complex number

IMSQRT =IMSQRT(inumber) Returns the square root of a complex number

IMSUB =IMSUB(inumber1,inumber2) Returns the difference between two complex numbers

IMSUM =IMSUM(inumber1,inumber2,…) Returns the sum of complex numbers

 OCT2BIN =OCT2BIN(number,places) Converts an octal number to binary

OCT2DEC =OCT2DEC(number) Converts an octal number to decimal

OCT2HEX =OCT2HEX(number,places) Converts an octal number to hexadecimal

=ACCRINT(issue,first_interest,settleme
nt,rate,par,frequency,basis,calc_metho Returns the accrued interest for a security that pays
ACCRINT d) periodic interest

=ACCRINTM(issue,settlement,rate,par, Returns the accrued interest for a security that pays

ACCRINTM basis) interest at maturity

=COUPDAYBS(settlement,maturity,freq Returns the number of days from the beginning of the

COUPDAYBS uency,basis) coupon period to the settlement date

=COUPDAYS(settlement,maturity,frequ Returns the number of days in the coupon period that

COUPDAYS ency,basis) contains the settlement date

=COUPDAYSNC(settlement,maturity,fr Returns the number of days from the settlement date to

COUPDAYSNC equency,basis) the next coupon date

=COUPNCD(settlement,maturity,freque
COUPNCD ncy,basis) Returns the next coupon date after the settlement date

=COUPNUM(settlement,maturity,freque Returns the number of coupons payable between the

COUPNUM ncy,basis) settlement date and maturity date

=COUPPCD(settlement,maturity,freque Returns the previous coupon date before the settlement

COUPPCD ncy,basis) date

=CUMIPMT(rate,nper,pv,start_period,e Returns the cumulative interest paid between two

CUMIPMT nd_period,type) periods

=CUMPRINC(rate,nper,pv,start_period, Returns the cumulative principal paid on a loan

CUMPRINC end_period,type) between two periods

=DISC(settlement,maturity,pr,redemptio
DISC n,basis) Returns the discount rate for a security

DURATION =DURATION(settlement,maturity,coupo Returns the annual duration of a security with periodic

 n,yld,frequency,basis) interest payments

Returns the future value of an initial principal after

FVSCHEDULE =FVSCHEDULE(principal,schedule) applying a series of compound interest rates

=INTRATE(settlement,maturity,investm
INTRATE ent,redemption,basis) Returns the interest rate for a fully invested security

Calculates the interest paid during a specific period of

ISPMT =ISPMT(rate,per,nper,pv) an investment

=MDURATION(settlement,maturity,cou Returns the Macauley modified duration for a security

MDURATION pon,yld,frequency,basis) with an assumed par value of $100

=ODDFPRICE(settlement,maturity,issu
e,first_coupon,rate,yld,redemption,frequ Returns the price per $100 face value of a security with
ODDFPRICE ency,basis) an odd first period

=ODDFYIELD(settlement,maturity,issue
,first_coupon,rate,pr,redemption,freque
ODDFYIELD ncy,basis) Returns the yield of a security with an odd first period

=ODDLPRICE(settlement,maturity,last_
interest,rate,yld,redemption,frequency,b Returns the price per $100 face value of a security with
ODDLPRICE asis) an odd last period

=ODDLYIELD(settlement,maturity,last_i
nterest,rate,pr,redemption,frequency,ba
ODDLYIELD sis) Returns the yield of a security with an odd last period

PMT =PMT(rate,nper,pv,fv,type) Returns the periodic payment for an annuity

Returns the payment on the principal for an investment

PPMT =PPMT(rate,per,nper,pv,fv,type) for a given period

=PRICE(settlement,maturity,rate,yld,red Returns the price per $100 face value of a security that
PRICE emption,frequency,basis) pays periodic interest

=PRICEDISC(settlement,maturity,disco Returns the price per $100 face value of a discounted

PRICEDISC unt,redemption,basis) security
 =PRICEMAT(settlement,maturity,issue, Returns the price per $100 face value of a security that
PRICEMAT rate,yld,basis) pays interest at maturity

=RECEIVED(settlement,maturity,invest Returns the amount received at maturity for a fully

RECEIVED ment,discount,basis) invested security

=TBILLEQ(settlement,maturity,discount
TBILLEQ ) Returns the bond-equivalent yield for a Treasury bill

=TBILLPRICE(settlement,maturity,disco
TBILLPRICE unt) Returns the price per $100 face value for a Treasury bill

TBILLYIELD =TBILLYIELD(settlement,maturity,pr) Returns the yield for a Treasury bill

=VDB(cost,salvage,life,start_period,end Returns the depreciation of an asset for a specified or

VDB _period,factor,no_switch) partial period by using a declining balance method

Returns the internal rate of return for a schedule of cash

XIRR =XIRR(values,dates,guess) flows that is not necessarily periodic

Returns the net present value for a schedule of cash

XNPV =XNPV(rate,values,dates) flows that is not necessarily periodic

=YIELDDISC(settlement,maturity,pr,red Returns the annual yield for a discounted security; for

YIELDDISC emption,basis) example, a Treasury bill

=YIELDMAT(settlement,maturity,issue,r Returns the annual yield of a security that pays interest

YIELDMAT ate,pr,basis) at maturity

ACOS =ACOS(number) Returns the arccosine of a number

ACOSH =ACOSH(number) Returns the inverse hyperbolic cosine of a number

ASIN =ASIN(number) Returns the arcsine of a number

ASINH =ASINH(number) Returns the inverse hyperbolic sine of a number

ATAN =ATAN(number) Returns the arctangent of a number

 ATAN2 =ATAN2(x_num,y_num) Returns the arctangent from x- and y-coordinates

ATANH =ATANH(number) Returns the inverse hyperbolic tangent of a number

DEGREES =DEGREES(angle) Converts radians to degrees

MDETERM =MDETERM(array) Returns the matrix determinant of an array

MINVERSE =MINVERSE(array) Returns the matrix inverse of an array

MMULT =MMULT(array1,array2) Returns the matrix product of two arrays

RADIANS =RADIANS(angle) Converts degrees to radians

ROMAN =ROMAN(number,form) Converts an arabic numeral to roman, as text

SQRTPI =SQRTPI(number) Returns the square root of (number * pi)

Converts a number to text, using the ß (baht) currency

BAHTTEXT =BAHTTEXT(number) format

Returns a key performance indicator (KPI) name,

property, and measure, and displays the name and
property in the cell. A KPI is a quantifiable
measurement, such as monthly gross profit or quarterly
=CUBEKPIMEMBER(connection,kpi_n employee turnover, used to monitor an organization’s
CUBEKPIMEMBER ame,kpi_property,caption) performance.

=CUBEMEMBER(connection,member_ Returns a member or tuple in a cube hierarchy. Use to

CUBEMEMBER expression,caption) validate that the member or tuple exists in the cube.

Returns the value of a member property in the cube.

Use to validate that a member name exists within the
CUBEMEMBERPR =CUBEMEMBERPROPERTY(connecti cube and to return the specified property for this
OPERTY on,member_expression,property) member.

Returns the nth, or ranked, member in a set. Use to

CUBERANKEDME =CUBERANKEDMEMBER(connection, return one or more elements in a set, such as the top
MBER set_expression,rank,caption) sales performer or top 10 students.
 Defines a calculated set of members or tuples by
sending a set expression to the cube on the server,
=CUBESET(connection,set_expression which creates the set, and then returns that set to
CUBESET ,caption,sort_order,sort_by) Microsoft Office Excel.

CUBESETCOUNT =CUBESETCOUNT(set)