Built-in

Compatibility

 * CHIDIST function - Returns the one-tailed probability of the chi-squared distribution
 * CHIINV function - Returns the inverse of the one-tailed probability of the chi-squared distribution
 * CHITEST function - Returns the test for independence
 * COVAR function - Returns covariance the average of the products of paired deviations
 * CRITBINOM function - 	 - Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
 * FDIST function - Returns the F probability distribution
 * FLOOR function - Rounds a number down toward zero significance
 * FTEST function - Returns the result of an F-test
 * GAMMADIST function - Returns the gamma distribution
 * GAMMAINV function - Returns the inverse of the gamma cumulative distribution
 * HYPGEOMDIST function - Returns the hypergeometric distribution
 * LOGINV function - Returns the inverse of the lognormal cumulative distribution
 * LOGNORMDIST function - Returns the cumulative lognormal distribution
 * MODE function - Returns the most common value in a data set
 * NEGBINOMDIST function - Returns the negative binomial distribution
 * NORMDIST function - Returns the normal cumulative distribution
 * NORMSDIST function - Returns the standard normal cumulative distribution
 * NORMSINV function - Returns the inverse of the standard normal cumulative distribution
 * PERCENTILE function - Returns the k-th percentile of values in a range
 * PERCENTRANK function - Returns the percentage rank of a value in a data set
 * POISSON function - Returns the Poisson distribution
 * QUARTILE function - Returns the quartile of a data set
 * RANK function - Returns the rank of a number in a list of numbers
 * STDEV function - Estimates standard deviation based on a sample
 * STDEVP function - Calculates standard deviation based on the entire population
 * TDIST function - Returns the Student's t-distribution
 * TINV function - Returns the inverse of the Student's t-distribution
 * TTEST function - Returns the probability associated with a Student's t-test
 * VAR function - Estimates variance based on a sample
 * VARP function - Calculates variance based on the entire population
 * WEIBULL function - Calculates variance based on the entire population including numbers

Database

 * DAVERAGE function - Returns the average of selected database entries
 * DCOUNT function - Counts the cells that contain numbers in a database
 * DCOUNTA function - Counts nonblank cells in a database
 * DGET function - Extracts from a database a single record that matches the specified criteria
 * DMAX function - Returns the maximum value from selected database entries
 * DMIN function - Returns the minimum value from selected database entries
 * DPRODUCT function - Multiplies the values in a particular field of records that match the criteria in a database
 * DSTDEV function - Estimates the standard deviation based on a sample of selected database entries
 * DSTDEVP function - Calculates the standard deviation based on the entire population of selected database entries
 * DSUM function - Adds the numbers in the field column of records in the database that match the criteria
 * DVAR function - Estimates variance based on a sample from selected database entries
 * DVARP function - Calculates variance based on the entire population of selected database entries

Date and time

 * DATE function - Returns the serial number of a particular date
 * DATEDIF function - Calculates the number of days months
 * DATEVALUE function - Converts a date in the form of text to a serial number
 * DAY function - 	 - Converts a serial number to a day of the month
 * DAYS function - Returns the number of days between two dates
 * DAYS360 function - Calculates the number of days between two dates based on a 360-day year
 * HOUR function - Converts a serial number to an hour
 * MINUTE function - Converts a serial number to a minute
 * MONTH function - Converts a serial number to a month
 * NOW function - Returns the serial number of the current date and time
 * SECOND function - Converts a serial number to a second
 * TIME function - Returns the serial number of a particular time
 * TIMEVALUE function - 	 - Converts a time in the form of text to a serial number
 * TODAY function - Returns the serial number of today's date
 * WEEKDAY function - Converts a serial number to a day of the week
 * YEAR function - Converts a serial number to a year

Information

 * CELL function - Returns information about the formatting location
 * ERROR.TYPE - Returns a number corresponding to an error type
 * INFO function - Returns information about the current operating environment
 * ISBLANK function - Returns TRUE if the value is blank
 * ISERR function - Returns TRUE if the value is any error value except #N
 * ISERROR function - Returns TRUE if the value is any error value
 * ISLOGICAL function - Returns TRUE if the value is a logical value
 * ISNA function - Returns TRUE if the value is the #N error value
 * ISNONTEXT function - Returns TRUE if the value is not text
 * ISNUMBER function - Returns TRUE if the value is a number
 * ISREF function - Returns TRUE if the value is a reference
 * ISTEXT function - Returns TRUE if the value is text
 * N function - Returns a value converted to a number
 * NA function - Returns the error value #N
 * TYPE function - Returns a number indicating the data type of a value

Logical

 * AND function - Returns TRUE if all of its arguments are TRUE
 * FALSE function - Returns the logical value FALSE
 * NOT function - Reverses the logic of its argument
 * OR function - Returns TRUE if any argument is TRUE
 * SWITCH function - Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match an optional default value may be returned.
 * TRUE function - Returns the logical value TRUE

Lookup and reference

 * ADDRESS function - Returns a reference as text to a single cell in a worksheet
 * AREAS function - Returns the number of contiguous cells in a reference
 * CHOOSE function - Chooses a value from a list of values
 * COLUMN function - Returns the column number of a reference
 * COLUMNS function - Returns the number of columns in a reference
 * GETPIVOTDATA function - Returns data stored in a PivotTable report
 * HLOOKUP function - Looks in the top row of an array and returns the value of the indicated cell
 * HYPERLINK function - Creates a shortcut or jump that opens a document stored on a network server an intranet
 * INDEX function - Uses an index to choose a value from a reference or array
 * INDIRECT function - Returns a reference indicated by a text value
 * LOOKUP function - Looks up values in a vector or array
 * MATCH function - Looks up values in a reference or array
 * OFFSET function - Returns a reference offset from a given reference
 * ROW function - Returns the row number of a reference
 * ROWS function - Returns the number of rows in a reference
 * RTD function - Retrieves real-time data from a program that supports COM automation
 * SINGLE function - Returns a single value using logic known as implicit intersection
 * TRANSPOSE function - Returns the transpose of an array
 * VLOOKUP function - Looks in the first column of an array and moves across the row to return the value of a cell

Math

 * ABS function - Returns the absolute value of a number
 * ACOS function - Returns the arccosine of a number
 * ACOSH function - Returns the inverse hyperbolic cosine of a number
 * ASIN function - Returns the arcsine of a number
 * ASINH function - Returns the inverse hyperbolic sine of a number
 * ATAN function - Returns the arctangent of a number
 * ATAN2 function - Returns the arctangent from x- and y-coordinates
 * ATANH function - Returns the inverse hyperbolic tangent of a number
 * CEILING function - Rounds a number to the nearest integer or to the nearest multiple of significance
 * COMBIN function - Returns the number of combinations for a given number of objects
 * COS function - Returns the cosine of a number
 * COSH function - Returns the hyperbolic cosine of a number
 * COT function - Returns the trigonometric cosine of a number
 * COTH function - Returns the hyperbolic cotangent of an angle
 * DEGREES function - Converts radians to degrees
 * EVEN function - Rounds a number up to the nearest even integer
 * EXP function - Returns e raised to the power of number.
 * FACT function - Returns the factorial of a number
 * INT function - Rounds a number down to the nearest integer
 * LN function - Returns the natural logarithm of a number
 * LOG function - Returns the logarithm of a number to a specified base
 * LOG10 function - Returns the base-10 logarithm of a number
 * MDETERM function - Returns the matrix determinant of an array
 * MINVERSE function - Returns the matrix inverse of an array
 * MMULT function - Returns the matrix product of two arrays
 * MOD function - Returns the remainder from division
 * ODD function - Rounds a number up to the nearest odd integer
 * PI function - Returns the value of pi
 * POWER function - Returns the result of a number raised to a power
 * PRODUCT function - Multiplies its arguments
 * RADIANS function - Converts degrees to radians
 * RAND function - Returns a random number between 0 and 1
 * ROMAN function - Converts an arabic numeral to roman as text
 * ROUND function - Rounds a number to a specified number of digits
 * ROUNDDOWN function - Rounds a number down toward zero
 * ROUNDUP function - Rounds a number up away from zero
 * SIGN function - Returns the sign of a number
 * SIN function - Returns the sine of the given angle
 * SINH function - Returns the hyperbolic sine of a number
 * SQRT function - Returns a positive square root
 * SUBTOTAL function - Returns a subtotal in a list or database
 * SUM function - Adds its arguments
 * SUMIF function - Adds the cells specified by a given criteria
 * SUMPRODUCT function - Returns the sum of the products of corresponding array components
 * SUMSQ function - Returns the sum of the squares of the arguments
 * SUMX2MY2 function - Returns the sum of the difference of squares of corresponding values in two arrays
 * SUMX2PY2 function - Returns the sum of the sum of squares of corresponding values in two arrays
 * SUMXMY2 function - Returns the sum of squares of differences of corresponding values in two arrays
 * TAN function - Returns the tangent of a number
 * TANH function - Returns the hyperbolic tangent of a number
 * TRUNC function - Truncates a number to an integer

Statistical

 * AVEDEV function - Returns the average of the absolute deviations of data points from their mean
 * AVERAGE function - Returns the average of its arguments
 * CORREL function - Returns the correlation coefficient between two data sets
 * COUNT function - Counts how many numbers are in the list of arguments
 * COUNTA function - Counts how many values are in the list of arguments
 * COUNTBLANK function - Counts the number of blank cells within a range
 * COUNTIF function - Counts the number of cells within a range that meet the given criteria
 * DEVSQ function - Returns the sum of squares of deviations
 * FISHER function - Returns the Fisher transformation
 * FISHERINV function - Returns the inverse of the Fisher transformation
 * FORECAST function - Returns a value along a linear trend
 * FREQUENCY function - Returns a frequency distribution as a vertical array
 * GAMMALN function - Returns the natural logarithm of the gamma function G(x)
 * GEOMEAN function - Returns the geometric mean
 * GROWTH function - Returns values along an exponential trend
 * HARMEAN function - Returns the harmonic mean
 * INTERCEPT function - Returns the intercept of the linear regression line
 * KURT function - Returns the kurtosis of a data set
 * LARGE function - Returns the k-th largest value in a data set
 * LINEST function - Returns the parameters of a linear trend
 * LOGEST function - Returns the parameters of an exponential trend
 * MAX function - Returns the maximum value in a list of arguments
 * MAXA function - Returns the maximum value in a list of arguments including numbers
 * MEDIAN function - Returns the median of the given numbers
 * MIN function - Returns the minimum value in a list of arguments
 * MINA function - Returns the smallest value in a list of arguments including numbers
 * NORMINV function - Returns the inverse of the normal cumulative distribution
 * PEARSON function - Returns the Pearson product moment correlation coefficient
 * PERMUT function - 	Statistical	 - Returns the number of permutations for a given number of objects
 * PROB function - Returns the probability that values in a range are between two limits
 * RSQ function - Returns the square of the Pearson product moment correlation coefficient
 * SKEW function - Returns the skewness of a distribution
 * SLOPE function - Returns the slope of the linear regression line
 * SMALL function - Returns the k-th smallest value in a data set
 * STANDARDIZE function - Returns a normalized value
 * STDEVA function - Estimates standard deviation based on a sample including numbers
 * STDEVPA function - Calculates standard deviation based on the entire population including numbers
 * STEYX function - Returns the standard error of the predicted y-value for each x in the regression
 * TREND function - Returns values along a linear trend
 * TRIMMEAN function - Returns the mean of the interior of a data set
 * VARA function - Estimates variance based on a sample including numbers
 * VARPA function - Calculates variance based on the entire population including numbers
 * ZTEST function - Returns the one-tailed probability-value of a z-test

Text

 * CHAR function - Returns the character specified by the code number
 * CLEAN function - Removes all nonprintable characters from text
 * CODE function - Returns a numeric code for the first character in a text string
 * CONCATENATE function - Joins several text items into one text item
 * DBCS function - Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters
 * DOLLAR function - Converts a number to text using the $ (dollar) currency format
 * EXACT function - Checks to see if two text values are identical
 * FIND - Finds one text value within another (case-sensitive)
 * FIXED function - Formats a number as text with a fixed number of decimals
 * LEFT - Returns the leftmost characters from a text value
 * LEN - Returns the number of characters in a text string
 * LOWER function - Converts text to lowercase
 * MID - Returns a specific number of characters from a text string starting at the position you specify
 * PROPER function - Capitalizes the first letter in each word of a text value
 * REPLACE - Replaces characters within text
 * REPT function - Repeats text a given number of times
 * RIGHT - Returns the rightmost characters from a text value
 * SEARCH - Finds one text value within another (not case-sensitive)
 * SUBSTITUTE function - Substitutes new text for old text in a text string
 * T function - Converts its arguments to text
 * TEXT function - Formats a number and converts it to text
 * TRIM function - Removes spaces from text
 * UPPER function - Converts text to uppercase
 * VALUE function - Converts a text argument to a number