Excel Formulas

---

Date and Time
DATE	Returns the number of the Date for given Year, Month and Day.
DATEDIF	Returns number of units between two dates.
DATEVALUE	Coverts Date in Text format to DATE.
DAY	Returns the Day of the month in a range from 1 to 31 for the given serial number.
DAYS	Returns number of days between two dates. (Excel 2013)
DAYS360	Returns number of days between two dates based on twelve 30 day months or 360-day year.
EDATE	Returns the serial number of the date that is a given number of months before or after a date.
EOMONTH	Returns the serial number of the last day of the month that is a given number of months before or after a date.
ISOWEEKNUM	Returns the number of the ISO week of the year according to European standard for the given date in serial number. (Excel 2013)
HOUR	Returns the hour in a range from 0 (12:00 AM) to 23 (11:00 PM) for the given serial number.
MINUTE	Returns the minute in a range from 0 to 59 for the given serial number.
MONTH	Returns the month in a range from 1 (January) to 12 (December) for the given serial number.
NETWORKDAYS	Returns the number of days between two dates excluding weekends and holidays.
NETWORKDAYS.INTL	Returns the number of days between two dates excluding weekend that can be specified as customer weekend parameters and holidays.
NOW	Returns current system Date and Time.
SECOND	Returns the second in a range from 0 to 59 for the given serial number.
TIME	Coverts given hours, minutes and seconds in number format to an Excel serial number in time format.
TIMEVALUE	Converts a text time to an Excel serial number.
TODAY	Returns current date in Date Format.
WEEKDAY	For the given serial number, returns a number in a range from 1 to 7 representing day of the week based on return type specified.
WEEKNUM	Returns the number of the week in the year for the specified date in the serial number format.
WORKDAY	Returns the serial number before or after a given number of days from a given date.
WORKDAY.INTL	Returns serial number of the date before or after specified number of workdays with custom weekend parameters.
YEAR	Returns the year in a range from 1900 to 9999for the given serial number.
YEARFRAC	Returns number of years in decimal format between given two dates.
Financial
ACCRINT	Returns accrued interest for a security that pays interest periodically.
ACCRINTM	Returns accrued interest for a security that pays interest at maturity.
AMORDEGRC	Returns depreciation of an asset in a single period.
AMORLINC	Returns depreciation of an asset in a single period.
COUPDAYBS	Returns number of days between previous coupon date and the settlement date.
COUPDAYS	Returns number of days between coupon days on either side of the settlement date.
COUPDAYSNC	Returns number of days between the settlement date and the next coupon date.
COUPNCD	Returns next coupon date after the settlement date.
COUPNUM	Returns number of coupons between the settlement date and the maturity date.
COUPPCD	Returns previous coupon date before the settlement date.
CUMIPMT	Returns cumulative interest paid on a loan between two dates.
CUMPRINC	Returns cumulative principal paid on a loan between two dates.
DB	Returns depreciation of an asset in a single period using declining balance method.
DDB	Returns depreciation of an asset in a single period using double or triple declining balance method.
DISC	Returns discount rate (interest rate) for a security held to maturity.
DOLLARDE	Returns dollar fraction expressed as a decimal.
DOLLARFR	Returns dollar decimal expressed as a fraction.
DURATION	Returns annual duration of a security that pays interest periodically.
EFFECT	Returns annual or effective interest rate given a nominal interest rate and compounding frequency.
FV	Returns future value of a series of equal cash flows at regular intervals.
FVSCHEDULE	Returns future value of an initial principal after applying compound interest rates.
INTRATE	Returns interest rate for a security held to maturity.
IPMT	Returns interest paid for a given period in a series of equal cash flows at regular intervals.
IRR	Returns internal rate of return for a series of cash flows.
ISPMT	Returns interest paid in a given period in a series of equal cash flows at regular intervals.
MDURATION	Returns modified duration for a security that pays interest periodically.
MIRR	Returns internal rate of return for a series of periodic cash flows, considering both cost of investment and interest on reinvestment of cash.
NOMINAL	returns nominal interest rate over a period given an annual interest rate.
NPER	Returns number of periods for an investment.
NPV	Returns net present value of an investment based on a discount rate and a series of future payments and income.
ODDFPRICE	Returns price per $100 face value of a security with an odd first period.
ODDFYIELD	Returns the yield of a security with an odd first period.
ODDLPRICE	Returns the price per $100 face value of a security with an odd last period.
ODDLYIELD	Returns yield of a security with an odd last period.
PMT	Returns payment for a loan based on constant payments and a constant interest rate.
PPMT	Returns payment on the principal for a given investment based on periodic constant payments and a constant interest rate.
PRICE	Returns price per $100 face value of a security that pays periodic interest.
PRICEDISC	Returns price per $100 face value of a discounted security.
PRICEMAT	Returns price per $100 face value of a security that pays interest at maturity.
PV	Returns present value of an investment.
RATE	Returns rate of interest per period of a loan or an investment.
RECEIVED	Returns amount received at maturity for a fully invested security.
SLN	Returns straight-line depreciation of an asset for one period.
SYD	Returns sum-of-years' digits depreciation of an asset for a specified period.
TBILLEQ	Returns bond-equivalent yield for a treasury bill.
TBILLPRICE	Returns price per $100 face value for a treasury bill.
TBILLYIELD	Returns yield for a treasury bill.
VDB	Returns depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify.
XIRR	Returns internal rate of return for a schedule of cash flows.
XNPV	Returns net present value for a schedule of cash flows.
YIELD	Returns yield on a security that pays periodic interest.
YIELDDISC	Returns annual yield for a discounted security.
YIELDMAT	Returns annual yield of a security that pays interest at maturity.
Maths and Trigonometry
ABS	Returns absolute value of a number without its sign.
ACOS	Returns arccosine of a number (i.e. angle whose cosine is the number) in radians.
ACOSH	Returns inverse hyperbolic cosine of a number.
ACOT	Returns arccotangent of a number (i.e. angle whose cotangent is the number) in radians. (Excel 2013)
ACOTH	Returns inverse hyperbolic cotangent of a number. (Excel 2013)
AGGREGATE	Returns aggregate of values in a list or database.
ARABIC	Returns a number converted from roman to arabic. (Excel 2013)
ASIN	Returns arcsine of a number (i.e. angle whose sine is the number) in radians.
ASINH	Returns inverse hyperbolic sine of a number.
ATAN	Returns arctangent of a number (i.e. angle whose tangent is the number) in radians.
ATAN2	Returns arctangent of the specified x and y coordinates in radians.
ATANH	Returns inverse hyperbolic tangent of a number.
BASE	Returns the number converted into a text representation with the given base. (Excel 2013)
CEILING	Returns up rounded number to the nearest integer or significant value.
CEILING.MATH	Returns up rounded number to the nearest integer or to the nearest significant value. (Excel 2013)
CEILING.PRECISE	Returns up rounded number to the nearest integer or significant value.
COMBIN	Returns the number of combinations for a given number of items.
COMBINA	Returns the number of combinations with repetitions for a given number of items. (Excel 2013)
COS	Returns cosine of an angle in radians.
COSH	Returns hyperbolic cosine of a number.
COT	Returns cotangent of an angle in radians. (Excel 2013)
COTH	Returns hyperbolic cotangent of a number. (Excel 2013)
CSC	Returns cosecant of an angle in radians. (Excel 2013)
CSCH	Returns hyperbolic cosecant of a number. (Excel 2013)
DECIMAL	Returns decimal number of a text representation of a number in a given base. (Excel 2013)
DEGREES	Returns degrees for given radians.
EVEN	Returns number rounded up (in case of positive number down incase of negative number) to the nearest even integer.
EXP	Returns exponential number raised to a given power.
FACT	Returns factorial of a number.
FACTDOUBLE	Returns double factorial of a number.
FLOOR	Returns a number down to the nearest multiple of significance.
FLOOR.MATH	Returns a number rounded down to the nearest integer in a given base into a decimal number. (Excel 2013)
FLOOR.PRECISE	Returns a number down to the nearest integer or nearest multiple of significance.
GCD	Returns Greatest Common Divisor.
INT	Returns number rounded down to the nearest integer.
LCM	Returns Least Common Multiple
LN	Returns natural logarithm of a number.
LOG	Returns logarithm of a number to the given base.
LOG10	Returns logarithm of a number to the base 10.
MDETERM	Returns matrix determinant of an array.
MINVERSE	Returns inverse matrix of an array.
MMULT	Returns matrix product of two arrays.
MOD	Returns the reminder after division.
MROUND	Returns a number rounded to the desired multiple.
MULTINOMIAL	Returns multinomial of a set of numbers in a list of cell range.
MUNIT	Returns unit matrix of the specified dimension. (Excel 2013)
ODD	Returns number rounded up (in case of positive number down incase of negative number) to the nearest odd integer.
PI	Returns number PI (3.14159265358979)
POWER	Returns number raised to a given power.
PRODUCT	Returns multiplication of all numbers given as arguments.
QUOTIENT	Returns integer portion of a division.
RADIANS	Returns radians for given degrees.
RAND	Returns random number between 0 and 1.
RANDBETWEEN	Returns random number between numbers specified.
ROMAN	Converts Arabic numeral to Roman.
ROUND	Returns number rounded to a specified number of digits.
ROUNDDOWN	Returns number rounded down.
ROUNDUP	Returns number rounded up.
SEC	Returns secant of an angle. (Excel 2013)
SECH	Returns hyperbolic secant of an angle. (Excel 2013)
SERIESSUM	Returns sum of a power series based on a formula.
SIGN	Returns sign of a number: 1 --> Positive number, zero --> number is zero, -1 --> negative number.
SIN	Returns sine of an angle in radians.
SINH	Returns hyperbolic sine of a number.
SQRT	Returns square root of a number.
SQRTPI	Returns square root of (number x PI)
SUBTOTAL	Returns subtotal of values in a list or database.
SUM	Returns sum of all numbers in a range of cells.
SUMIF	Returns sum of all numbers in a range of cells which meet the criteria.
SUMIFS	Returns sum of all number in the cells which meet given set of criteria.
SUMPRODUCT	Returns sum of the products of corresponding ranges or arrays.
SUMSQ	Returns sum of the squares of all the values in a list or cell range.
SUMX2MY2	Returns sum ofthe difference of squares of corresponding values in two arrays.
SUMX2PY2	Returns sum of squares of corresponding values in two arrays.
SUMXMY2	Returns sum of squares of differences of corresponding values in two arrays.
TAN	Returns tangent of an angle in radians.
TANH	Returns hyperbolic tanget of a number.
TRUNC	Truncates the number by removing the decimal, or fractional, part of the number.
Statistical
AVEDEV	Returns average deviation for a list or array of numbers.
AVERAGE	Returns arithmatic mean of a list or array of numbers.
AVERAGEA	Returns arithmatic mean of a list or array of numbers including text and logical values.
AVERAGEIF	Returns arithmatic mean of a list or array of numbers in a range that satisfies given confition.
AVERAGEIFS	Returns arithmatic mean of a list or array of numbers that satisfies given conditions.
BETA.DIST	Returns the beta probability distribution function (Excel 2010 - BETADIST)
BETA.INV	Returns the inverse of the cumulative beta probability density function - BETA.DIST (Excel 2010 - BETAINV).
BINOM.DIST	Returns probability of getting exactly or less than a particular value in a binomial distribution (Excel 2010 - BINOMDIST)
BINOM.INV	Returns probability of getting greater than a particular value in a binomial distribution (Excel 2010 - CRITBINOM)
CHISQ.DIST	Returns left-tailed probability of the chi-squared distribution.
CHISQ.DIST.RT	Returns right-tailed probability of the chi-squared distribution.
CHISQ.INV	Returns inverse of left-tailed probability of the chi-squared distribution - CHISQ.DIST.
CHISQ.INV.RT	Returns inverse of right-tailed probability of the chi-squared distribution - CHISQ.DIST.RT.
CHISQ.TEST	Returns the value from the chi-squared distribution for the satistic and the appropriate degrees of freedom.
CONFIDENCE.NORM	Returns confidence interval for a population mean, using a normal distribution.
CONFIDENCE.T	Returns confidence interval for a population mean, using a Student's T distribution.
CORREL	Returns correlation coefficient between two data sets.
COUNT	Returns count of number of cells in a range containing numbers.
COUNTA	Returns count of non-empty cells in a range.
COUNTBLANK	Returns count of empty cells in a range.
COUNTIF	Returns count of cells within a range satisfying given condition.
COUNTIFS	Returns count of cells within a range satisfying given conditions.
COVARIANCE.P	Returns population covariance, the average of the products of deviations for each data point pair in two data sets.
COVARIANCE.S	Returns sample covariance, the average of the products of deviations for each data point pair in two data sets
DEVSQ	Returns sum of squares of deciations of data points from their sample mean.
EXPON.DIST	Returns the exponential distribution.
F.DIST	Returns left-tailed F probability distribution for two data sets.
F.DIST.RT	Returns right-tailed F probability distribution for two data sets.
F.INV	Returns inverse of left-tailed F probability distribution for two data sets.
F.INV.RT	Returns inverse of right-tailed F probability distribution for two data sets.
F.TEST	Returns result of an F-test, the two-tailed probability that the variances in Array1 and Array2 are not significantly different.
FISHER	Returns the Fisher transformation.
FISHERINV	Returns inverse of Fisher transformation.
FORECAST	Returns a future value along a linear trend by using existing values.
FREQUENCY	Returns number of times a particular value occurs in a list or array.
GAMMA.DIST	Returns gamma distribution (Excel 2010 - GAMMADIST).
GAMMA.INV	Returns inverse of gamma distribution (Excel 2010 - GAMMAINV).
GAMMALN	Returns natual logarithm of gamma function.
GAMMALN.PRECISE	Returns natual logarithm of gamma function.
GEOMEAN	Returns geometric mean of an array or range of positive numeric data.
GROWTH	Returns numbers in an exponendial growth trend matching known data points.
HARMEAN	Returns harmonic mean of a data set of positive numbers.
HYPGEOM.DIST	Returns hypergeometric distribution.
INTERCEPT	Returns intersection with the y-axis using a linear regression plotted through known values.
KURT	Returns kurtosis of a data set.
LARGE	Returns the k-th largest value in a data set.
LINEST	Returns statistics describing a linear trend matching known data points, by fitting a straight line using the least squares method.
LOGEST	Returns statistics describing an exponential curve matching known data points.
LOGNORM.DIST	Returns lognormal distribution of x where ln(x) is normally distributed with parameters Mean and Standard_dev.
LOGNORM.INV	Returns inverse of lognormal distribution of x where ln(x) is normally distributed with parameters Mean and Standard_dev
MAX	Returns the largest value in a set of values ignoring logical values and text.
MAXA	Returns the largest value in a set of values considering logical values and text
MEDIAN	Returns the median of the set of given numbers.
MIN	Returns the smallest value in a set of values ignoring logical values and text
MINA	Returns the smallest value in a set of values considering logical values and text
MODE.MULT	Returns a vertical array of the most frequently occurring values in an array or range of data.
MODE.SNGL	Returns the most frequently occurring value in an array or range of data
NEGBINOM.DIST	Returns negative binomial distribution.
NORM.DIST	Returns normal distribution for the specified mean and standard deviation.
NORM.INV	Returns inverse of normal distribution for the specified mean and standard deviation
NORM.S.DIST	Returns standard normal distribution.
NORM.S.INV	Returns inverse of standard normal distribution.
PEARSON	Returns Pearson product moment correlation coefficient, r.
PERCENTILE.EXC	Returns k-th percentile of values in a range, k being in a range from 0 to 1 both exclusive.
PERCENTILE.INC	Returns k-th percentile of values in a range, k being in a range from 0 to 1 both inclusive
PERCENTRANK.EXC	Returns the rank of a value in a data set as a percentage of the data set, percentage being in a range from 0 to 1 both exclusive.
PERCENTTANK.INC	Returns the rank of a value in a data set as a percentage of the data set, percentage being in a range from 0 to 1 both inclusive.
PERMUT	Returns number of permutations for a given number of objects that can be selected from the total objects.
POISSON.DIST	Returns Poisson distribution.
PROB	Returns the probability that values in a range are between two limits or equal to a lower limit.
QUARTILE.EXC	Returns the quartile of a data set based on percentile values from 0 to 1 both exclusive.
QUARTILE.INC	Returns the quartile of a data set based on percentile values from 0 to 1 both inclusive.
RANK.AVG	Returns the rank of a number in a list of numbers. In case of more than one value having same rank, the average rank is returned.
RANK.EQ	Returns the rank of a number in a list of numbers. In case of more than one value having same rank, the top rank of that set of values is returned.
RSQ	Returns square of the Pearson product moment correlation coefficient through the given data points.
SKEW	Returns the skewness of a distribution.
SLOPE	Returns the slope of the linear regression line through the given data points.
SMALL	Returns k-th smallest value in a data set.
STANDARDIZE	Returns a normalized value from a distribution characterized by a mean and standard deviation.
STDEV.P	Returns standard deviation based on entire population.
STDEV.S	Returns standard deviation based on sample.
STDEVA	Returns standard deviation based on sample, including logical values and text.
STDEVPA	Returns standard deviation based on entire population, including logical values and text
STEYX	Returns standard error of the predicted y-value for each x in a regression.
T.DIST	Returns left-tailed Student's T-distribution.
T.DIST.2T	Returns two-tailed Student's T-distribution.
T.DIST.RT	Returns right-tailed Student's T-distribution.
T.INV	Returns inverse of left-tailed Student's T-distribution
T.INV.2T	Returns inverse of two-tailed Student's T-distribution
T.TEST	Returns the probability associated with a Student's T-Test.
TREND	Returns numbers in a linear trend matching known data points, using the least squares method.
TRIMMEAN	Returns the mean of the interior portion of a set of data values.
VAR.P	Returns variance based on the entire population ignoring logical values and text.
VAR.S	Returns variance based on the sample ignoring logical values and text.
VARA	Returns variance based on the sample including logical values and text
VARPA	Returns variance based on the entire population including logical values and text.
WEIBULL.DIST	Returns Weibull distribution.
Z.TEST	Returns one-tailed P-value of a z-test.
Lookup and Reference
ADDRESS	Returns cell reference for given row and column number.
AREAS	Returns number of areas in a cell range or reference.
CHOOSE	Chooses a value or action to perform from a list of values, based on an index number.
COLUMN	Returns a column number of the cell reference.
COLUMNS	Returns the number of columns in a cell range or reference.
FORMULATEXT	Returns the formula in text format from a particular cell. (Excel 2013)
GETPIVOTDATA	Provides data stored in the pivot table.
HLOOKUP	Looks for a value in the top row of the table and returns the value in the same column from a row you specify
HYPERLINK	Creates hyperlink linked to a cell, document or webpage.
INDEX	Returns value from a table, basd on an index number
INDIRECT	Returns the reference specified by a text string.
LOOKUP	Looks for the value in a row (or column) that matches a value in a column (or row)
MATCH	Returns relative position of an item in an array that matches specified value in a specified order.
OFFSET	Returns cell value which is an offset from a given cell reference.
ROW	Returns row number of the cell reference.
ROWS	Returns the number of rows in a cell range or reference.
RTD	Returns real time data from a program that supports COM.
TRANSPOSE	Converts orientation of the array - vertical to horizontal and vice-versa.
VLOOKUP	Looks for a value in the leftmost column of the table and returns the value in the same row from a column you specify.
Database
DAVERAGE	Returns average of values in a column satisfying certain conditions.
DCOUNT	Returns total number of values in a column satisfying certain conditions.
DCOUNTA	Returns total number of non blank cells in a column satisfying certain conditions.
DGET	Returns single value from a column satisfying certain conditions.
DMAX	Returns maximum value in a column satisfying certain conditions.
DMIN	Returns minimum value in a column satisfying certain conditions.
DPRODUCT	Returns product of values in a column satisfying certain conditions.
DSTDEV	Returns standard deviation of values in a column satisfying certain conditions.
DSTDEVP	Returns standard deviation of values in a column satisfying certain conditions.
DSUM	Returns sum of values in a column satisfying certain conditions.
DVAR	Returns variance from a database column that satisfies certain conditions.
DVARP	Returns variance from a database column that satisfies certain conditions.
Text
ASC	Converts double byte characters into single byte characters.
BAHTTEXT	Returns number converted to Thai text with word "Baht" added to it.
CHAR	Returns character with corresponding ANSI number.
CLEAN	Returns text string with all non-printable characters removed.
CODE	Returns ANSI number for the first character in a text string.
CONCATENATE	Returns concatenated string for all given strings.
DOLLAR	Returns text string of a number with dollar formatting $0,000.00
EXACT	Returns boolean value for exact match of given two strings.
FIND	Returns position of a substring within a larger text string.
FIXED	Returns text string of a number rounded to a fixed number of decimal places.
LEFT	Returns specified number of characters from the start of a text string.
LEN	Returns number of characters in the given string.
LOWER	Converts characters of given string to lower case.
MID	Returns characters from the middle of a text string starting from a given position length.
NUMBERVALUE	Converts text to number in a locale independent manner (Excel 2013)
PHONETIC	Returns phonetic characters from a text string.
PROPER	Returns text string with first character of every word as a capital letter (camel case).
REPLACE	Replaces part of a string with a different text string.
REPT	Repeats text a given number of times.
RIGHT	Returns specified number of characters from the end of a text string.
SEARCH	Returns number of the character from left at which a specific character or text string is first found.
SUBSTITUTE	Replaces existing text with new text in a text string.
T	Verifies if given value is a text. If yes, returns the text as it is, else return double quotes "".
TEXT	Converts a value to text in a specific number format.
TRIM	Removes all spaces from a text string appearing either at beginning or end of the string.
UNICHAR	Returns unicode character referenced by the given numeric value (Excel 2013).
UNICODE	Returns the number corresponding to the first character of the text (Excel 2013).
UPPER	Converts all characters of the text string to upper case.
VALUE	Returns the number represented by the text string.
Logical
AND	Logical AND. Returns TRUE if all the arguments are TRUE.
FALSE	Logical FALSE value.
IF	Checks whether given condition is TRUE and FALSE. Returns different values based on given condition is TRUE or FALSE.
IFERROR	If value (or expression) specified in first parameter is error, then returns the value_if_error, otherwise the value (or value of the expression) in the first parameter itself.
NOT	Logical NOT operator. Changes FALSE to TRUE and vice-versa.
OR	Logical OR. Returns TRUE if any of the given arguments in TRUE, else returns FALSE.
TRUE	Logical TRUE value.
Information
CELL	Returns number of text string indicating information about a cell.
ERROR.TYPE	Returns number corresponding to a particular error value in a cell.
INFO	Returns text string returning useful information about the environment.
ISBLANK	Returns boolean value depending on whether value is blank.
ISERR	Returns boolean value depending on whether value is error (not N/A).
ISERROR	Returns boolean value depending on whether value is error.
ISEVEN	Returns boolean value depending on whether value is an even number.
ISLOGICAL	Returns boolean value depending on whether value is TRUE or FALSE.
ISNA	Returns boolean value depending on whether value is N/A.
ISNONTEXT	Returns boolean value depending on whether value is not Text.
ISNUMBER	Returns boolean value depending on whether value is Number.
ISODD	Returns boolean value depending on whether value is an odd number.
ISREF	Returns boolean value depending on whether value is a cell reference.
ISTEXT	Returns boolean value depending on whether value is Text.
N	Converts value into a number.
NA	The error value #N/A.
TYPE	Returns number indicating the datatype of the value.
Engineering
BESSELI	Returns modified Bessel function In(x).
BESSELJ	Returns Bessel function Jn(x).
BESSELK	Returns modified Bessel function kn(x).
BESSELY	Returns Bessel function Yn(x).
BIN2DEC	Converts Binary number to Decimal.
BIN2HEX	Converts Binary number to Hexadecimal.
BIN2OCT	Converts Binary number to Octal.
COMPLEX	Converts real and imaginary coefficients into a complex number.
CONVERT	Converts number from one measurement system to another.
DEC2BIN	Converts Decimal number to Binary.
DEC2HEX	Converts Decimal number to Hexadecimal.
DEC2OCT	Converts Decimal number to Octal.
DELTA	Tests whether two numbers are equal.
ERF	Returns the error function.
ERF.PRECISE	Returns the error function.
ERFC	Returns the complementary error function.
ERFC.PRECISE	Returns the complementary error function.
GESTEP	Tests whether a number is greater than a threshold value.
HEX2BIN	Converts Hexadecimal to Binary.
HEX2DEC	Converts Hexadecimal to Decimal.
HEX2OCT	Converts Hexadecimal to Octal.
IMABS	Returns absolute value (modulus) of a complex number.
IMAGINARY	Returns imaginary coefficient of a complex number.
IMARGUMENT	Returns the argument q, an angle expressed in radians.
IMCONJUGATE	Returns complex conjugate of a complex number.
IMCOS	Returns cosine of a complex number.
IMDIV	Returns quotient of two complex numbers.
IMEXP	Returns exponential of a complex number.
IMLN	Returns natural logarithm of a complex number.
IMLOG10	Returns base-10 logarithm of a complex number.
IMLOG2	Returns base-2 logarithm of a complex number.
IMPOWER	Returns complex number raised to an integer power.
IMPRODUCT	Returns product of complex numbers.
IMREAL	Returns real coefficient of a complex number.
IMSIN	Returns sine of a complex number.
IMSQRT	Returns square root of a complex number.
IMSUB	Returns difference between two complex numbers.
IMSUM	Returns sum of complex numbers.
OCT2BIN	Converts Octal number to Binary.
OCT2DEC	Converts Octal number to Decimal.
OCT2HEX	Converts Octal number to Hexadecimal.
Cube
CUBEKPIMEMBER	Returns Key Performance Indicator (KPI) property.
CUBEMEMBER	Returns a member or tuple from the cube.
CUBEMEMBERPROPERTY	Returns value of a member property from the cube.
CUBERANKEDMEMBER	Returns nth, or ranked, member in a set.
CUBESET	Defines calculated set of members or tuples by sending a set expression to the cube on the server.
CUBESETCOUNT	Returns number of items in a set.
CUBEVALUE	Returns aggregated value from the cube.
Compatibility
BETADIST	Returns the beta probability distribution function. (Compatibility with Excel 2007 and earlier).
BETAINV	Returns the inverse of the cumulative beta probability density function - BETA.DIST. (Compatibility with Excel 2007 and earlier).
BINOMDIST	Returns probability of getting exactly or less than a particular value in a binomial distribution. (Compatibility with Excel 2007 and earlier).
CHIDIST	Returns right-tailed probability of the chi-squared distribution. (Compatibility with Excel 2007 and earlier).
CHIINV	Returns inverse of right-tailed probability of the chi-squared distribution. (Compatibility with Excel 2007 and earlier).
CHITEST	Returns the value from the chi-squared distribution for the satistic and the appropriate degrees of freedom. (Compatibility with Excel 2007 and earlier).
CONFIDENCE	Returns confidence interval for a population mean, using a normal distribution. (Compatibility with Excel 2007 and earlier).
COVAR	Returns covariance, the average of the products of deviations for each data point pair in two data sets. (Compatibility with Excel 2007 and earlier).
CRITBINOM	Returns probability of getting greater than a particular value in a binomial distribution. (Compatibility with Excel 2007 and earlier).
EXPONDIST	Returns the exponential distribution. (Compatibility with Excel 2007 and earlier).
FDIST	Returns right-tailed F probability distribution for two data sets. (Compatibility with Excel 2007 and earlier).
FINV	Returns inverse of right-tailed F probability distribution for two data sets. (Compatibility with Excel 2007 and earlier).
FTEST	Returns result of an F-test, the two-tailed probability that the variances in Array1 and Array2 are not significantly different. (Compatibility with Excel 2007 and earlier).
GAMMADIST	Returns gamma distribution. (Compatibility with Excel 2007 and earlier).
GAMMAINV	Returns inverse of gamma distribution. (Compatibility with Excel 2007 and earlier).
HYPGEOMDIST	Returns hypergeometric distribution. (Compatibility with Excel 2007 and earlier).
LOGINV	Returns inverse of lognormal distribution of x where ln(x) is normally distributed with parameters Mean and Standard_dev. (Compatibility with Excel 2007 and earlier).
LOGNORMDIST	Returns lognormal distribution of x where ln(x) is normally distributed with parameters Mean and Standard_dev. (Compatibility with Excel 2007 and earlier).
MODE	Returns the most frequently occurring value in an array or range of data (Compatibility with Excel 2007 and earlier).
NEGBINOMDIST	Returns negative binomial distribution. (Compatibility with Excel 2007 and earlier).
NORMDIST	Returns normal distribution for the specified mean and standard deviation. (Compatibility with Excel 2007 and earlier).
NORMINV	Returns inverse of normal distribution for the specified mean and standard deviation. (Compatibility with Excel 2007 and earlier).
NORMSDIST	Returns standard normal cumulative distrubution having a mean of zero and a standard deviation of one. (Compatibility with Excel 2007 and earlier).
NORMSINV	Returns inverse of standard normal cumulative distrubution having a mean of zero and a standard deviation of one. (Compatibility with Excel 2007 and earlier).
PERCENTILE	Returns k-th percentile of values in a range. (Compatibility with Excel 2007 and earlier).
PERCENTRANK	Returns the rank of a value in a data set as a percentage of the data set. (Compatibility with Excel 2007 and earlier).
POISSON	Returns Poisson distribution. (Compatibility with Excel 2007 and earlier).
QUARTILE	Returns the quartile of a data set. (Compatibility with Excel 2007 and earlier).
RANK	Returns the rank of a number in a list of numbers. (Compatibility with Excel 2007 and earlier).
STDEV	Returns standard deviation based on sample, ignoring logical values and text. (Compatibility with Excel 2007 and earlier).
STDEVP	Returns standard deviation based on entire population. (Compatibility with Excel 2007 and earlier).
TDIST	Returns Student's T-distribution. (Compatibility with Excel 2007 and earlier).
TINV	Returns inverse of two-tailed Student's T-distribution. (Compatibility with Excel 2007 and earlier).
TTEST	Returns the probability associated with a Student's T-Test. (Compatibility with Excel 2007 and earlier).
VAR	Returns variance based on the sample ignoring logical values and text. (Compatibility with Excel 2007 and earlier).
VARP	Returns variance based on the entire population ignoring logical values and text. (Compatibility with Excel 2007 and earlier).
WEIBULL	Returns Weibull distribution. (Compatibility with Excel 2007 and earlier).
ZTEST	Returns one-tailed P-value of a z-test. (Compatibility with Excel 2007 and earlier).

---