Supported Excel Functions
Supported Excel Compatible Functions
The list below describes the Excel functions that are supported when Excel formatted data is being used in an automated process. This means that if your workbook contains these functions, the results of calculating the workbook during the automation process will be correct. If your workbook uses a function that is not supported, it will generate a value of #ERROR in the cell during automation. The unsupported formula will not be removed from the workbook however. In total, there are 398 of Excel 2010’s financial, date, time, text, lookup, math, trigonometry, statistical, database, engineering, information and logical functions currently supported.
Database and List Management Functions 

DAVERAGE  Indicates the average of the values that meet the specified criteria. 
DCOUNT  Counts the number of cells containing numbers that meet the specified criteria. 
DCOUNTA  Counts nonblank cells containing numbers or text that meet the specified criteria. 
DGET  Returns a single value that meets the specified criteria. 
DMAX  Extracts the highest value that meets the specified criteria. 
DMIN  Extracts the lowest value that meets the specified criteria. 
DPRODUCT  Returns the product of the values that meet the specified criteria. 
DSTDEV  Estimates the standard deviation of a population, based on a sample of selected entries from the database. 
DSTDEVP  Returns the calculation of the standard deviation of a population, based on the sum of the whole population. 
DSUM  Returns the total of the values that meet the specified criteria. 
DVAR  Estimates the variance of a sample population based on the values that meet the specified criteria. 
DVARP  Returns the calculation of the true variance of an entire population based on the values that meet the specified criteria. 
Date and Time Functions 

DATE  Returns the serial number that represents a date. 
DATEDIF  Returns the difference of two dates in years, months or days. 
DATEVALUE  Converts date text to a DATEVALUE serial number. 
DAY  Returns the corresponding day of the month serial number or date text from 1 to 31. 
DAYS360  Returns the number of days between two set dates based on a 360day year. 
EDATE  Returns the value or serial number of the date which is a certain number of months before or after a userspecified date. 
EOMONTH  Returns the date at the end of the month a specified number of months before or after a specified date. 
HOUR  Returns the hour as a serial number integer between 0 and 23. 
MINUTE  Returns the serial number that corresponds to the minute. 
MONTH  Returns the corresponding serial number of the month of a date between 1 and 12. 
NETWORKDAYS  Returns the number of working days between two dates. Excludes weekends and specified holidays. 
NETWORKDAYS.INTL  Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. 
NOW  Returns the current date and time in the form of a serial number. 
SECOND  Returns the seconds portion of a serial time value. 
TIME  Returns the decimal value of a given time. 
TIMEVALUE  Returns the decimal number for a given time. 
TODAY  Returns the current date as a serial number. 
WEEKDAY  Returns the corresponding day of the week as a serial number. 
WEEKNUM  Returns the number where a week falls numerically within a year. 
WORKDAY  Returns a date that is a specified number of working days before or after a given date. 
WORKDAY.INTL  Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days. 
YEAR  Returns the corresponding year as a serial number in the form of an integer. 
YEARFRAC  Calculates the fraction of the year between two dates. 
Engineering Functions 

BESSELI  Returns the BESSEL function in modified form for imaginary arguments. 
BESSELJ  Returns the actual BESSEL function. 
BESSELK  Returns the BESSEL function in modified form for imaginary arguments. 
BESSELY  Returns the BESSEL function, also known as the Weber or Neumann function. 
BIN2DEC  Converts a binary number to decimal form. 
BIN2HEX  Converts a binary number to a hexadecimal. 
BIN2OCT  Converts a binary number to octal form. 
COMPLEX  Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj. 
CONVERT  Interprets data from one measurement system to another. 
DEC2BIN  Converts decimal numbers to binary form. 
DEC2HEX  Converts decimal numbers to hexadecimal. 
DEC2OCT  Converts decimal numbers to octal. 
DELTA  Tests whether numbers or values are equal with a number result. Returns “0” for unequal, “1” for equal. 
ERF  Returns the integrated error function between a lower and upper limit. 
ERF.PRECISE  Returns the error function 
ERFC  Returns a complementary ERF function integrated between ‘x’ and infinity. 
ERFC.PRECISE  Returns the complementary ERF function integrated between x and infinity 
GESTEP  Returns the value 1 if the number is greater than or equal to a specified step value, otherwise it returns 0. 
HEX2BIN  Converts hexadecimal numbers to binary form. 
HEX2DEC  Converts hexadecimal numbers to decimal form. 
HEX2OCT  Converts hexadecimal numbers to octal form. 
IMABS  Returns the absolute value (modulus) of a complex number in x+yi or x+yj text format. 
IMAGINARY  Returns the coefficient of a complex number in x+yi or x+yj text format. 
IMARGUMENT  Returns the theta argument – an angle expressed in radians. 
IMCONJUGATE  Returns the complex conjugate of a complex number in x+yi or x+yj text format. 
IMCOS  Returns the cosine of a complex number in x+yi or x+yj text format. 
IMDIV  Returns the quotient of complex numbers in x+yi or x+yj text format. 
IMEXP  Returns the exponential of a complex number in x+yi or x+yj text format. 
IMLN  Returns the natural logarithm of a complex number in x+yi or x+yj text format. 
IMLOG10  Returns the common logarithm (Base 10) of a complex number in x+yi or x+yj text format. 
IMLOG2  Returns the common logarithm (Base 2) of a complex number in x+yi or x+yj text format. 
IMPOWER  Returns a complex number raised to a power in x+yi or x+yj text format. 
IMPRODUCT  Returns the product from 2 to 29 complex numbers in x+yi or x+yj text format. 
IMREAL  Returns the real coefficient of a complex number in x+yi or x+yj text format. 
IMSIN  Returns the sine of a complex number in x+yi or x+yj text format. 
IMSQRT  Returns the square root of a complex number in x+yi or x+yj text format. 
IMSUB  Returns the difference of two complex numbers in x+yi or x+yj text format. 
IMSUM  Returns the sum of 2 to 29 complex numbers in x+yi or x+yj text format. 
OCT2BIN  Converts an octal number to binary form. 
OCT2DEC  Converts an octal number to decimal form. 
OCT2HEX  Converts an octal number to hexadecimal form. 
Financial Functions 

ACCRINT  Returns accrued interest for securities that pay periodic interest. 
ACCRINTM  Returns the accrued interest for securities that pay interest at the maturity date. 
AMORDEGRC  Returns the depreciation for each accounting period within the formula. 
AMORLINC  Returns the depreciation for each accounting period. 
COUPDAYBS  Returns the number of days from the beginning of the period to the couponperiod settlement date. 
COUPDAYS  Returns the number of days in the period that contains the coupon period settlement date. 
COUPDAYSNC  Returns the number of days between the settlement date to the next coupon date. 
COUPNCD  Returns the next coupon date after the settlement date. 
COUPNUM  Returns the total number of coupons to be paid between the settlement and maturity dates, rounded up to the nearest whole coupon. 
COUPPCD  Returns the coupon date previous to the settlement date. 
CUMIPMT  Returns the cumulative interest on a loan between start and stop dates. 
CUMPRINC  Returns the cumulative principal amount between start and stop dates on a loan or mortgage. 
DB  Returns the asset depreciation for a period using the fixed declining balance method. 
DDB  Returns the asset depreciation for a period using the doubledeclining balance method or another specified method. 
DISC  Returns the security discount rate. 
DOLLARDE  Converts a fraction dollar price into a decimal dollar price. 
DOLLARFR  Converts a decimal dollar price into a fraction dollar price. 
DURATION  Returns the Macauley duration for an assumed par value. 
EFFECT  Returns the effective interest rate annually. This is based on the nominal annual interest rate and the number of compounding periods per year. 
FV  Returns the future value of an investment that makes payments as a lump sum or as a series of equal periodic payments. 
FVSCHEDULE  Returns the future value of a principal amount after applying several, or a series of compound interest rates. 
INTRATE  Returns the interest rate of a security that is fully invested. 
IPMT  Returns the interest for a period of time based on an investment with periodic constant payments and a constant interest rate. 
IRR  Returns the internal rate of return for a series of cash flows represented by numbers in the form of values. 
ISPMT  Calculates the interest paid during a defined period of an investment. 
MDURATION  Returns the modified duration of a security with a par value assumed to be $100. 
MIRR  Returns a modified internal rate of return for several periodic cash flows. 
NOMINAL  Returns the nominal annual interest rate given an effective rate and the total number of compounding periods for the year. 
NPER  Returns the total number of periods for an investment. This is based on a periodic constant payment and a constant interest rate. 
NPV  Calculates the net present value of an investment from the discount rate and several future payments and income. 
ODDFPRICE  Returns the value of a security based on a per $100 face value and an odd (short or long) first period. 
ODDFYIELD  Returns the security yield with an odd first period. 
ODDLPRICE  Returns the per $100 face value of a security having an odd last coupon period. 
ODDLYIELD  Returns the security yield that has an odd last period. 
PMT  Calculates the loan payment for a loan based on constant payments and constant interest rates. 
PPMT  Returns the principal payment for a period of an investment based on periodic constant payments and a constant interest rate. 
PRICE  Returns the value of a security based on price per $100 face value and periodic interest payments. 
PRICEDISC  Returns the value of a discounted security based on a price per $100 face value. 
PRICEMAT  Returns the value of a security that pays interest at maturity and price per $100 face value. 
PV  Returns the present value based on an investment. 
RATE  Returns per period the interest of an annuity. 
RECEIVED  Based on a fully invested security, returns the amount received at maturity. 
SLN  Returns the straightline depreciation on an asset. 
SYD  Based on a specified period, SYD returns the sumofyears’ digits depreciation of an asset. 
TBILLEQ  Returns the bond equivalent yield for a treasury bill. 
TBILLPRICE  Returns the price per $100 face value for a treasury bill. 
TBILLYIELD  Returns the yield of a treasury bill. 
VDB  For a period you specify, returns the depreciation of an asset. 
XIRR  Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. 
XNPV  Returns the net present value for a schedule of cash flows that is not necessarily periodic. 
YIELD  Based on a yield that pays periodic interest, returns the yeild of the security. 
YIELDDISC  Returns the annual yield for a discounted security. 
YIELDMAT  Returns the annual yield based on a security that pays interest at a maturity. 
Information Functions 

CELL  Returns information about a cell’s location, formatting, or contents in the upperleft cell in a reference. 
ERROR.TYPE  Returns the corresponding number value associated with an error type in Microsoft Excel. 
INFO  Returns operating environment information. 
ISBLANK  Returns TRUE if the cell is empty, FALSE if it contains data. 
ISERR  Returns TRUE if value contains any error value except #N/A, FALSE if it does not. 
ISERROR  Returns TRUE if value contains any error value (including #N/A), FALSE if it does not. 
ISEVEN  Returns TRUE if value is an even number, FALSE if it is not. 
ISLOGICAL  Returns TRUE if value is a logical value, FALSE if it is not. 
ISNA  Returns TRUE if value is #N/A, FALSE if it is not. 
ISNONTEXT  Returns TRUE if value is not text, FALSE if it is. 
ISNUMBER  Returns TRUE if value is a number, FALSE if it is not. 
ISODD  Returns TRUE if value is an odd number, FALSE if it is not. 
ISREF  Returns TRUE if value is a reference, FALSE if it is not. 
ISTEXT  Returns TRUE if value is text, FALSE if it is not. 
N  Returns a value converted to a number. 
NA  An alternative representation of the error value #N/A. 
TYPE  Determines the type of value in a cell. 
Logical Functions 

AND  Returns TRUE if all the arguments are TRUE in the formula, and FALSE if any one argument is FALSE. 
FALSE  Returns the value FALSE. May be typed directly into the cell as “FALSE”. 
IF  Returns a value if one condition is TRUE and returns another value if the condition is FALSE. 
IFERROR  Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula 
NOT  Returns the reverse value of its arguments; TRUE becomes FALSE and FALSE becomes TRUE. 
OR  Returns FALSE if all arguments are FALSE, and TRUE if at least one argument is TRUE. 
TRUE  Returns the value TRUE. May be typed directly into the cell as “TRUE”. 
Lookup and Reference Functions 

ADDRESS  Given specified row and column numbers, creates a cell address as text. 
AREAS  Returns the number of areas based on a reference. 
CHOOSE  Returns an item from a list of values.. 
COLUMN  Returns the column number(s) based on a given reference. 
COLUMNS  Returns the number of columns based on an array or reference. 
HLOOKUP  Searches for a specified value in an array or a table’s top row. 
HYPERLINK  Creates a shortcut to jump to a document stored on a network server. 
INDEX  Returns the value of an element selected by the row number and column letter indexes. 
INDIRECT  Returns the contents of a cell using its reference. 
LOOKUP  Looks in the first row or column of a range or array, and returns the specified value from the same position in the last row or column of the range or array. 
MATCH  Returns the relative position of an item in an array that matches a specified value in a specified order, or the position of an item. 
OFFSET  Returns a reference to a range that is a specific number of rows and columns from a cell or range of cells. 
ROW  Returns the row number based on a reference. 
ROWS  Returns the number of rows in a reference or array. 
TRANSPOSE  Returns a horizontal range of cells as vertical or vice versa. 
VLOOKUP  Searches for a value in the leftmost column of a table and returns a value from the same row in a column number that you specify. 
Math and Trigonometry Functions 

ABS  Returns the absolute value of a number. 
ACOS  Returns the arccosine of a number in radians in the range 0 to pi. 
ACOSH  Returns the inverse hyperbolic cosine of a number. 
ASIN  Returns the arcsine of a number in radians in the range pi/2 to pi/2. 
ASINH  Returns the inverse hyperbolic sine of a number. 
ATAN  Returns the arctangent of a number in radians in the range pi/2 to pi/2 
ATAN2  Returns the fourquadrant arctangent of the specified x and y coordinates in radians between pi and pi excluding pi. A positive result represents a counterclockwise angle from the xaxis, a negative result represents a clockwise angle. 
ATANH  Returns the inverse hyperbolic tangent of a number. 
CEILING  Returns a number rounded up, away from zero, to the nearest multiple of significance. 
CEILING.PRECISE  Rounds a number to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number if rounded up. 
COMBIN  Returns the number of combinations for a given number of items. 
COS  Returns the cosine of the given angle. 
COSH  Returns the hyperbolic cosine of a number. 
DEGREES  Converts radians into degrees. 
EVEN  Returns a number rounded up to the next even integer for positive integers and rounded down to the next even integer for negative numbers. 
EXP  Returns e (2.71828182845804) raised to the power of a specified number. 
FACT  Returns the factorial of a number. 
FACTDOUBLE  Returns the double factorial of a number. 
FLOOR  Returns a number rounded down, toward zero, to the nearest multiple of significance. 
FLOOR.PRECISE  Rounds a number to the nearest integeror to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. 
GCD  Returns the greatest common divisor of two or more integers. 
INT  Rounds a number down to the nearest integer. 
LCM  Returns the least common multiple of integers. 
LN  Returns the natural (base e) logarithm of a number. 
LOG  Returns the logarithm of a number of the base you specify. 
LOG10  Returns the base10 logarithm of a number. 
MDETERM  Returns the matrix determinant of an array. 
MINVERSE  Returns the inverse matrix for the matrix stored in an array. 
MMULT  Returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. 
MOD  Returns the remainder of a division operation (modulus). 
MROUND  Returns a number rounded to the desired multiple. Rounds up if the remainder after dividing the number by the multiple is at least half the value of the multiple. 
MULTINOMIAL  Returns the ratio of the factorial of the sum of the values to the product of the factorials. 
ODD  Returns a number rounded up away from zero to the nearest odd integer. 
PI  Returns the approximate number 3.14159265358979, the mathematical constant pi, accurate to 15 digits. 
POWER  Returns the result of a specified number raised to a specified power. 
PRODUCT  Multiplies all the numbers given as arguments and returns the product. 
QUOTIENT  Returns the integer portion of a division. 
RADIANS  Converts degrees to radians. 
RAND  Returns an evenly distributed random number greater than or equal to 0 and less than 1. A new random number is returned every time the worksheet is calculated. 
RANDBETWEEN  Returns a random integer between the integers you specify. A new random number is returned every time the worksheet is calculated. 
ROMAN  Converts an Arabic numeral to Roman, as text. 
ROUND  Round a number to a specified number of digits. 
ROUNDDOWN  Rounds a number down, towards zero. 
ROUNDUP  Rounds a number up, away from zero. 
SERIESSUM  Returns the sum of a power series. 
SIGN  Determines the sign of a number. Returns 1 if the value is positive, 0 if the value is 0, and 1 if the value is negative. 
SIN  Returns the sine of a given angle. 
SINH  Returns the hyperbolic sine of a number. 
SQRT  Returns a positive square root. 
SQRTPI  Returns the square root of (NUMBER * Pi) 
SUBTOTAL  Returns a subtotal in a list or database. 
SUM  Adds all the numbers in a range of cells. 
SUMIF  Adds the cells specified by a certain criteria. 
SUMIFS  Adds the cells in a range that meet multiple criteria 
SUMPRODUCT  Multiplies corresponding components in the given arrays, and returns the sum of those products. 
SUMSQ  Returns the sum of the squares of the arguments. 
SUMX2MY2  Returns the sum of the difference of squares of corresponding values in two arrays. 
SUMX2PY2  Returns the sum of the sum of squares of corresponding values in two arrays. 
SUMXMY2  Returns the sum of squares of differences of corresponding values in two arrays. 
TAN  Returns the tangent of the given angle. 
TANH  Returns the hyperbolic tangent of a number. 
TRUNC  Truncates a number to an integer by removing the fractional part of a number. 
PreExcel 2010 Statistical Functions 

BETADIST  Returns the cumulative beta probability density function. 
BETAINV  Returns the inverse of the cumulative beta probability density function. 
BINOMDIST  Returns the individual term binomial distribution probability. 
CHIDIST  Returns the onetailed probability of the chisquared (X^2) distribution; the area in the right tail under the chisquared distribution curve. 
CHIINV  Returns the inverse of the onetailed probability of the chisquared (X^2) distribution. 
CHITEST  Returns the test for independence of the characteristics in a table. 
CONFIDENCE  Returns the confidence interval for a population mean. 
COVAR  Returns the covariance, the average of products of deviations, for each data point pair. 
EXPONDIST  Returns the exponential distribution. 
FDIST  Returns the F probability distribution. 
FINV  Returns the inverse of the F probability distribution. 
FTEST  Returns the result of an Ftest. 
GAMMADIST  Returns the gamma distribution. 
GAMMAINV  Returns the inverse of the gamma cumulative distribution. 
LOGINV  Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard deviation. 
LOGNORMDIST  Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard deviation. 
MODE  Returns the most frequently occuring, or repetitive, number in an array or range of data. 
NEGBINOMDIST  Returns the negative binomial distribution. 
NORMDIST  Returns the normal cumulative distribution for the specified mean and standard deviation. 
NORMINV  Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. 
NORMSDIST  Returns the standard normal cumulative distribution function. 
PERCENTILE  Returns the kth percentile of values in a range. 
PERCENTRANK  Returns the rank of a value in a data set set as a percentage of the data set. 
POISSON  Returns the Poisson distribution. 
QUARTILE  Returns the quartile of a data set. 
RANK  Returns the rank of a number in a list of numbers. 
STDEV  Estimates standard deviation based on a sample. 
STDEVP  Estimates standard deviation based on a sample assuming that the arguments represent the total population. 
TDIST  Returns the percentage points (probability) for the student tdistribution, where a numeric value (x) is a calculated value of t for which the percentage points are to be computed. 
TINV  Returns the tvalue of the Student’s tdistribution as a function of the probability and the degrees of freedom. 
TTEST  The probability associated with ttest. 
VAR  Returns an estimate for the variance of a population based on a sample data set. 
VARP  Calculates variance based on the entire population. 
WEIBULL  Returns the Weibull distribution. 
ZTEST  Returns the twotailed Pvalue of a ztest. 
Statistical Functions 

AVEDEV  Retuns the average of the absolute deviations of data points from their mean. 
AVERAGE  Returns the average of its arguments. 
AVERAGEA  Returns the average of the values in its list of arguments including text and logical values. 
AVERAGEIF  Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria 
AVERAGEIFS  Returns the average (arithmetic mean) of all cells that meet multiple criteria 
BETA.DIST  Returns the beta cumulative distribution function 
BETA.INV  Returns the inverse of the cumulative distribution function for a specified beta distribution 
BINOM.DIST  Returns the individual term binomial distribution probability 
BINOM.INV  Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value 
CHISQ.DIST  Returns the chisquared distribution 
CHISQ.DIST.RT  Returns the onetailed probability of the chisquared distribution 
CHISQ.INV  Returns the inverse of the lefttailed probability of the chisquared distribution 
CHISQ.INV.RT  Returns the inverse of the righttailed probability of the chisquared distribution 
CHISQ.TEST  Returns the test for independence. 
CONFIDENCE.NORM  Returns the confidence interval for a population mean. 
CONFIDENCE.T  Returns the confidence interval for a population mean, using a Student’s t distribution 
CORREL  Returns the correlation coefficient between two data sets. 
COUNT  Counts the number of cells that contain numbers (including dates and formulas that evaluate to numbers) within the list of arguments. 
COUNTA  Counts the number of cells that are not empty. 
COUNTBLANK  Counts the empty cells in a specified range. 
COUNTIF  Counts the number of cells in a range that meet a given criteria. 
COUNTIFS  Counts the number of cells within a range that meet multiple criteria 
COVARIANCE.P  Returns covariance, the average of the products of paired deviations 
COVARIANCE.S  Returns the sample covariance, the average of the products deviations for each data point pair intwo data sets 
CRITBINOM  Returns the minimum number yields a binomial distribution less than or equal to the specified criteria 
DEVSQ  Returns the sum of the squares of deviations of a data set from their sample mean. 
EXPON.DIST  Returns the exponential distribution. 
F.DIST  Returns the F probability distribution. 
F.DIST.RT  Returns the (righttailed) F probability distribution (degree of diversity) for two data sets 
F.INV  Returns the inverse of the F probability distribution 
F.INV.RT  Returnd the inverse of the (righttailed) F probability distribution 
F.TEST  Returns the result of an Ftest. 
FISHER  Returns the Fisher transformation at x. 
FISHERINV  Returns the inverse of the Fisher transformation at y. 
FORECAST  Calculates or predicts a future value by using existing values. 
FREQUENCY  Calculates how often values occur within a range of values and then returns a vertical array of numbers. 
GAMMA.DIST  Returns the gamma distribution. 
GAMMA.INV  Returns the inverse of the gamma cumulative distribution. 
GAMMALN  Returns the natural logarithm of the gamma function. 
GAMMALN.PRECISE  Returns the natural logarithm of the gamma function. 
GEOMEAN  Returns the geometric mean of an array or range of positive data. 
GROWTH  Calculates predicted exponential growth by using existing data. 
HARMEAN  Returns the harmonic mean of a data set. 
HYPGEOM.DIST  Returns the hypergeometric distribution. 
HYPGEOMDIST  Returns the hypergeometric distribution. 
INTERCEPT  Calculates the point at which a line will intersect the yaxis by using existing x and y values. 
KURT  Returns the Kurtosis of a data set. 
LARGE  Returns the kth largest value in a data set. 
LINEST  Calculates a straight line that best fits your data using the least squares method. 
LOGEST  Calculates an exponential curve that fits your data and returns an array of values that describes the curve. 
LOGNORM.DIST  Returns the lognormal distribution, of x, where ln(x) is normally distributed with mean and standard deviation. 
LOGNORM.INV  Returns the inverse of the lognormal cumulative distribution. 
MAX  Returns the largest value in a set of values. 
MAXA  Returns the largest value in a set of values including text and logical values. 
MEDIAN  Returns the median of the given numbers. 
MIN  Returns the smallest value in a set of values. 
MINA  Returns the smallest value in a set of values including text and logical values. 
MODE.MULT  Returns a vertical array of the most frequestly occurring, or repetitive values in an array or range of data. 
MODE.SNGL  Returns the most common value in a data set. 
NEGBINOM.DIST  Returns the negative binomial distribution. 
NORM.DIST  Returns the normal cumulative distribution. 
NORM.INV  Returns the inverse of the normal cumulative distribution. 
NORM.S.DIST  Return the standard normal cumulative distribution. 
NORM.S.INV  Returns the inverse of the standard normal cumulative distribution. 
NORMSINV  Returns the inverse of the standard normal cumulative distribution function. 
PEARSON  Returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from 1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets. 
PERCENTILE.EXC  Returns the kth percentile of values in a range, where k is in the range 0..1, exclusive 
PERCENTILE.INC  Returns the kth percentile of values in a range. 
PERCENTRANK.EXC  Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set 
PERCENTRANK.INC  Returns the percentage rank of a value in a data set 
PERMUT  Returns the number of permutations for a given number of objects that can be selected from a range of numbers. 
POISSON.DIST  Returns the Poisson distribution. 
PROB  Returns the probability that values in a range are between two specified limits. 
QUARTILE.EXC  Returns the quartile of the data set, based on percentile values fro 0..1, exclusive. 
QUARTILE.INC  Returns the quartile of a data set. 
RANK.AVG  Returns the rank of a number in a list of numbers. 
RANK.EQ  Returns the rank of a number in a list of numbers. 
RSQ  Returns the r^2 value of a linear regression line. 
SKEW  Returns the skew of a distribution. 
SLOPE  Returns the slope of a regression line through data points in KNOWN_Y’S and KNOWN_X’S. 
SMALL  Returns the kth smallest value in a data set. 
STANDARDIZE  Returns a normalized value from a distribution characterized by MEAN and STANDARD_DEV. 
STDEV.P  Calculates standard deviation based on the entire population 
STDEV.S  Estimates standard deviation based on a sample. 
STDEVA  Estimates standard deviation based on a sample. Includes text and logical values. 
STDEVPA  Estimates standard deviation based on a sample assuming that the arguments represent the total population. Includes text and logical values. 
STEYX  Returns the standard error of the predicted y value for each x in the regression. 
T.DIST  Returns the percentage points (probability) for the student tdistribution. 
T.DIST.2T  Returns the percentage points (probability) for the student tdistribution. 
T.DIST.RT  Returns the Student’s tdistribution. 
T.INV  Returns the tvalue of the Student’s tdistribution as a function of the probability and the degrees of freedom. 
T.INV.2T  Returns the inverse of the Student’s tdistribution. 
T.TEST  Returns the probability associated with a Student’s ttest. 
TREND  Returns the yvalues along a linear trendline that best fits the values in a data set. 
TRIMMEAN  Returns the mean of the interior of a data set. 
VAR.P  Calculates variance based on the entire population 
VAR.S  Estimates variance based on a sample. 
VARA  Returns an estimate for the variance of a population based on a sample data set and may include text or logical values. 
VARPA  Calculates variance based on the entire population and may include text or logical values. 
WIEBULL.DIST  Returns the Weibull distribution. 
Z.TEST  Returns the onetailed probabilityvalue of a ztest. 
Text Functions 

CHAR  Returns the character specified by a number. 
CLEAN  Removes all nonprintable characters from text. 
CODE  Returns a numeric code from the first character in a text string. The opposite of the CHAR function. 
CONCATENATE  Joins several text strings into one text string. 
DOLLAR  Converts a number to text using Currency format, with the decimals rounded to the specified place. 
EXACT  Compares two text strings and returns TRUE if they are exactly the same, and FALSE otherwise. 
FIND  Locates one text string within another text string, and returns the number of the starting position of of FIND_TEXT from the leftmost character of WITHIN_TEXT. 
FINDB  Returns the position of specified text within another specified text string based on the number of bytes each character uses from the first character of WITHIN_TEXT. 
FIXED  Rounds a number to a specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. 
LEFT  Returns the first character(s) in a text string. 
LEFTB  Returns the first character(s) in a text string based on a specified number of bytes 
LEN  Returns the number of characters in a text string. 
LENB  Returns the number of characters in a text string expressed in bytes. 
LOWER  Converts all letters in a text string to lowercase. 
MID  Returns a specific number of characters from a text string starting at the position you specify. 
MIDB  Returns a group of characters based on a specified number of bytes from a text string starting at the position you specify. 
PROPER  Capitalizes the first letter of each word in a text string or sentence. 
REPLACE  Replaces part of a text string with a different text string based on the number of characters you specify. 
REPLACEB  Replaces part of a text string with a different text string based on the number of characters you specify in terms of bytes. 
REPT  Repeats specified text a given number of times. 
RIGHT  Returns the last character(s) in a text string. 
RIGHTB  Returns the last character(s) in a text string based on a specified number of bytes. 
SEARCH  Returns the number of the character at which a specific character or text string is first found, reading from left to right. 
SEARCHB  Returns the number of the character at which a specific character or text string is first found in bytes, reading from left to right. 
SUBSTITUTE  Substitutes NEW_TEXT for OLD_TEXT in a string. 
T  Returns the text referred to by a value. 
TEXT  Converts a value to text in a specific number format. 
TRIM  Removes all spaces from text except single spaces between words. 
UPPER  Converts text to uppercase. 
USDOLLAR  Converts a number to text using US Dollar format, with the decimals rounded to the specified place. 
VALUE  Converts a text string that represents a number to a number. 
Recommended Posts