Built-in

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

Other

 * ABS function - Math and trigonometry - Returns the absolute value of a number
 * ACOS function - Math and trigonometry - Returns the arccosine of a number
 * ACOSH function - Math and trigonometry - Returns the inverse hyperbolic cosine of a number
 * ADDRESS function - Lookup and reference - Returns a reference as text to a single cell in a worksheet
 * AND function - Logical - Returns TRUE if all of its arguments are TRUE
 * AREAS function - Lookup and reference - Returns the number of contiguous cells in a reference'''
 * ASIN function - Math and trigonometry - Returns the arcsine of a number
 * ASINH function - Math and trigonometry - Returns the inverse hyperbolic sine of a number
 * ATAN function - Math and trigonometry - Returns the arctangent of a number
 * ATAN2 function - Math and trigonometry - Returns the arctangent from x- and y-coordinates
 * ATANH function - Math and trigonometry - Returns the inverse hyperbolic tangent of a number
 * AVEDEV function - Statistical - Returns the average of the absolute deviations of data points from their mean
 * AVERAGE function - Statistical - Returns the average of its arguments
 * CEILING function - Math and trigonometry - Rounds a number to the nearest integer or to the nearest multiple of significance
 * CELL function - Information - Returns information about the formatting location
 * CHAR function - Text - Returns the character specified by the code number
 * CHIDIST function - Compatibility - Returns the one-tailed probability of the chi-squared distribution
 * CHIINV function - Compatibility - Returns the inverse of the one-tailed probability of the chi-squared distribution
 * CHITEST function - Compatibility - Returns the test for independence
 * CHOOSE function - Lookup and reference - Chooses a value from a list of values
 * CLEAN function - Text - Removes all nonprintable characters from text
 * CODE function - Text - Returns a numeric code for the first character in a text string
 * COLUMN function - Lookup and reference - Returns the column number of a reference
 * COLUMNS function - Lookup and reference - Returns the number of columns in a reference
 * COMBIN function - Math and trigonometry - Returns the number of combinations for a given number of objects
 * CONCATENATE function - Text - Joins several text items into one text item
 * CORREL function - Statistical - Returns the correlation coefficient between two data sets
 * COS function - Math and trigonometry - Returns the cosine of a number
 * COSH function - Math and trigonometry - Returns the hyperbolic cosine of a number
 * COT function - Math and trigonometry - Returns the trigonometric cosine of a number
 * COTH function - Math and trigonometry - Returns the hyperbolic cotangent of an angle
 * COUNT function - Statistical - Counts how many numbers are in the list of arguments
 * COUNTA function - Statistical - Counts how many values are in the list of arguments
 * COUNTBLANK function - Statistical - Counts the number of blank cells within a range
 * COUNTIF function - Statistical - Counts the number of cells within a range that meet the given criteria
 * COUPDAYBS function - Financial - Returns the number of days from the beginning of the coupon period to the settlement date
 * COVAR function - Compatibility - Returns covariance the average of the products of paired deviations
 * CRITBINOM function - Compatibility - Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
 * DATE function - Date and time - Returns the serial number of a particular date
 * DATEDIF function - Date and time - Calculates the number of days months
 * DATEVALUE function - Date and time - Converts a date in the form of text to a serial number
 * DAVERAGE function - Database - Returns the average of selected database entries
 * DAY function - Date and time - Converts a serial number to a day of the month
 * DAYS function - Date and time - Returns the number of days between two dates
 * DAYS360 function - Date and time - Calculates the number of days between two dates based on a 360-day year
 * DB function - Financial - Returns the depreciation of an asset for a specified period by using the fixed-declining balance method
 * DBCS function - Text - Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters
 * DCOUNT function - Database - Counts the cells that contain numbers in a database
 * DCOUNTA function - Database - Counts nonblank cells in a database
 * DDB function - Financial - Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
 * DEGREES function - Math and trigonometry - Converts radians to degrees
 * DELTA function - Engineering - Tests whether two values are equal
 * DEVSQ function - Statistical - Returns the sum of squares of deviations
 * DGET function - Database - Extracts from a database a single record that matches the specified criteria
 * DMAX function - Database - Returns the maximum value from selected database entries
 * DMIN function - Database - Returns the minimum value from selected database entries
 * DOLLAR function - Text - Converts a number to text using the $ (dollar) currency format
 * DPRODUCT function - Database - Multiplies the values in a particular field of records that match the criteria in a database
 * DSTDEV function - Database - Estimates the standard deviation based on a sample of selected database entries
 * DSTDEVP function - Database - Calculates the standard deviation based on the entire population of selected database entries
 * DSUM function - Database - Adds the numbers in the field column of records in the database that match the criteria
 * DVAR function - Database - Estimates variance based on a sample from selected database entries
 * DVARP function - Database - Calculates variance based on the entire population of selected database entries
 * ERROR.TYPE - Information - Returns a number corresponding to an error type
 * EVEN function - Math and trigonometry - Rounds a number up to the nearest even integer
 * EXACT function - Text - Checks to see if two text values are identical
 * EXP function - Math and trigonometry - Returns e raised to the power of number.
 * EXPONDIST function - Compatibility - Returns the exponential distribution
 * FACT function - Math and trigonometry - Returns the factorial of a number
 * FALSE function - Logical - Returns the logical value FALSE
 * FDIST function - Compatibility - Returns the F probability distribution
 * FIND - Text - Finds one text value within another (case-sensitive)
 * FISHER function - Statistical - Returns the Fisher transformation
 * FISHERINV function - Statistical - Returns the inverse of the Fisher transformation
 * FIXED function - Text - Formats a number as text with a fixed number of decimals
 * FLOOR function - Compatibility - Rounds a number down toward zero significance
 * FORECAST function - Statistical - Returns a value along a linear trend
 * FREQUENCY function - Statistical - Returns a frequency distribution as a vertical array
 * FTEST function - Compatibility - Returns the result of an F-test
 * FV function - Financial - Returns the future value of an investment
 * GAMMADIST function - Compatibility - Returns the gamma distribution
 * GAMMAINV function - Compatibility - Returns the inverse of the gamma cumulative distribution
 * GAMMALN function - Statistical - Returns the natural logarithm of the gamma function G(x)
 * GEOMEAN function - Statistical - Returns the geometric mean
 * GESTEP function - Engineering - Tests whether a number is greater than a threshold value
 * GETPIVOTDATA function - Lookup and reference - Returns data stored in a PivotTable report
 * GROWTH function - Statistical - Returns values along an exponential trend
 * HARMEAN function - Statistical - Returns the harmonic mean
 * HLOOKUP function - Lookup and reference - Looks in the top row of an array and returns the value of the indicated cell
 * HOUR function - Date and time - Converts a serial number to an hour
 * HYPERLINK function - Lookup and reference - Creates a shortcut or jump that opens a document stored on a network server an intranet
 * HYPGEOMDIST function - Compatibility - Returns the hypergeometric distribution
 * INDEX function - Lookup and reference - Uses an index to choose a value from a reference or array
 * INDIRECT function - Lookup and reference - Returns a reference indicated by a text value
 * INFO function - Information - Returns information about the current operating environment
 * INT function - Math and trigonometry - Rounds a number down to the nearest integer
 * INTERCEPT function - Statistical - Returns the intercept of the linear regression line
 * IPMT function - Financial - Returns the interest payment for an investment for a given period
 * IRR function - Financial - Returns the internal rate of return for a series of cash flows
 * ISBLANK function - Information - Returns TRUE if the value is blank
 * ISERR function - Information - Returns TRUE if the value is any error value except #N
 * ISERROR function - Information - Returns TRUE if the value is any error value
 * ISLOGICAL function - Information - Returns TRUE if the value is a logical value
 * ISNA function - Information - Returns TRUE if the value is the #N error value
 * ISNONTEXT function - Information - Returns TRUE if the value is not text
 * ISNUMBER function - Information - Returns TRUE if the value is a number
 * ISPMT function - Financial - Calculates the interest paid during a specific period of an investment
 * ISREF function - Information - Returns TRUE if the value is a reference
 * ISTEXT function - Information - Returns TRUE if the value is text
 * KURT function - Statistical - Returns the kurtosis of a data set
 * LARGE function - Statistical - Returns the k-th largest value in a data set
 * LEFT - Text - Returns the leftmost characters from a text value
 * LEN - Text - Returns the number of characters in a text string
 * LINEST function - Statistical - Returns the parameters of a linear trend
 * LN function - Math and trigonometry - Returns the natural logarithm of a number
 * LOG function - Math and trigonometry - Returns the logarithm of a number to a specified base
 * LOG10 function - Math and trigonometry - Returns the base-10 logarithm of a number
 * LOGEST function - Statistical - Returns the parameters of an exponential trend
 * LOGINV function - Compatibility - Returns the inverse of the lognormal cumulative distribution
 * LOGNORMDIST function - Compatibility - Returns the cumulative lognormal distribution
 * LOOKUP function - Lookup and reference - Looks up values in a vector or array
 * LOWER function - Text - Converts text to lowercase
 * MATCH function - Lookup and reference - Looks up values in a reference or array
 * MAX function - Statistical - Returns the maximum value in a list of arguments
 * MAXA function - Statistical - Returns the maximum value in a list of arguments including numbers
 * MDETERM function - Math and trigonometry - Returns the matrix determinant of an array
 * MEDIAN function - Statistical - Returns the median of the given numbers
 * MID - Text - Returns a specific number of characters from a text string starting at the position you specify
 * MIN function - Statistical - Returns the minimum value in a list of arguments
 * MINA function - Statistical - Returns the smallest value in a list of arguments including numbers
 * MINUTE function - Date and time - Converts a serial number to a minute
 * MINVERSE function - Math and trigonometry - Returns the matrix inverse of an array
 * MIRR function - Financial - Returns the internal rate of return where positive and negative cash flows are financed at different rates
 * MMULT function - Math and trigonometry - Returns the matrix product of two arrays
 * MOD function - Math and trigonometry - Returns the remainder from division
 * MODE function - Compatibility - Returns the most common value in a data set
 * MONTH function - Date and time - Converts a serial number to a month
 * N function - Information - Returns a value converted to a number
 * NA function - Information - Returns the error value #N
 * NEGBINOMDIST function - Compatibility - Returns the negative binomial distribution
 * NORMDIST function - Compatibility - Returns the normal cumulative distribution
 * NORMINV function - Statistical - Returns the inverse of the normal cumulative distribution
 * NORMSDIST function - Compatibility - Returns the standard normal cumulative distribution
 * NORMSINV function - Compatibility - Returns the inverse of the standard normal cumulative distribution
 * NOT function - Logical - Reverses the logic of its argument
 * NOW function - Date and time - Returns the serial number of the current date and time
 * NPER function - Financial - Returns the number of periods for an investment
 * NPV function - Financial - Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
 * ODD function - Math and trigonometry - Rounds a number up to the nearest odd integer
 * OFFSET function - Lookup and reference - Returns a reference offset from a given reference
 * OR function - Logical - Returns TRUE if any argument is TRUE
 * PDURATION function - Financial - Returns the number of periods required by an investment to reach a specified value
 * PEARSON function - Statistical - Returns the Pearson product moment correlation coefficient
 * PERCENTILE function - Compatibility - Returns the k-th percentile of values in a range
 * PERCENTRANK function - Compatibility - Returns the percentage rank of a value in a data set
 * PERMUT function - Statistical - Returns the number of permutations for a given number of objects
 * PI function - Math and trigonometry - Returns the value of pi
 * PMT function - Financial - Returns the periodic payment for an annuity
 * POISSON function - Compatibility - Returns the Poisson distribution
 * POWER function - Math and trigonometry - Returns the result of a number raised to a power
 * PPMT function - Financial - Returns the payment on the principal for an investment for a given period
 * PROB function - Statistical - Returns the probability that values in a range are between two limits
 * PRODUCT function - Math and trigonometry - Multiplies its arguments
 * PROPER function - Text - Capitalizes the first letter in each word of a text value
 * PV function - Financial - Returns the present value of an investment
 * QUARTILE function - Compatibility - Returns the quartile of a data set
 * RADIANS function - Math and trigonometry - Converts degrees to radians
 * RAND function - Math and trigonometry - Returns a random number between 0 and 1
 * RANK function - Compatibility - Returns the rank of a number in a list of numbers
 * RATE function - Financial - Returns the interest rate per period of an annuity
 * REPLACE - Text - Replaces characters within text
 * REPT function - Text - Repeats text a given number of times
 * RIGHT - Text - Returns the rightmost characters from a text value
 * ROMAN function - Math and trigonometry - Converts an arabic numeral to roman as text
 * ROUND function - Math and trigonometry - Rounds a number to a specified number of digits
 * ROUNDDOWN function - Math and trigonometry - Rounds a number down toward zero
 * ROUNDUP function - Math and trigonometry - Rounds a number up away from zero
 * ROW function - Lookup and reference - Returns the row number of a reference
 * ROWS function - Lookup and reference - Returns the number of rows in a reference
 * RSQ function - Statistical - Returns the square of the Pearson product moment correlation coefficient
 * RTD function - Lookup and reference - Retrieves real-time data from a program that supports COM automation
 * SEARCH - Text - Finds one text value within another (not case-sensitive)
 * SECOND function - Date and time - Converts a serial number to a second
 * SIGN function - Math and trigonometry - Returns the sign of a number
 * SIN function - Math and trigonometry - Returns the sine of the given angle
 * SINGLE function - Lookup and reference - Returns a single value using logic known as implicit intersection
 * SINH function - Math and trigonometry - Returns the hyperbolic sine of a number
 * SKEW function - Statistical - Returns the skewness of a distribution
 * SLN function - Financial - Returns the straight-line depreciation of an asset for one period
 * SLOPE function - Statistical - Returns the slope of the linear regression line
 * SMALL function - Statistical - Returns the k-th smallest value in a data set
 * SQRT function - Math and trigonometry - Returns a positive square root
 * STANDARDIZE function - Statistical - Returns a normalized value
 * STDEV function - Compatibility - Estimates standard deviation based on a sample
 * STDEVA function - Statistical - Estimates standard deviation based on a sample including numbers
 * STDEVP function - Compatibility - Calculates standard deviation based on the entire population
 * STDEVPA function - Statistical - Calculates standard deviation based on the entire population including numbers
 * STEYX function - Statistical - Returns the standard error of the predicted y-value for each x in the regression
 * SUBSTITUTE function - Text - Substitutes new text for old text in a text string
 * SUBTOTAL function - Math and trigonometry - Returns a subtotal in a list or database
 * SUM function - Math and trigonometry - Adds its arguments
 * SUMIF function - Math and trigonometry - Adds the cells specified by a given criteria
 * SUMPRODUCT function - Math and trigonometry - Returns the sum of the products of corresponding array components
 * SUMSQ function - Math and trigonometry - Returns the sum of the squares of the arguments
 * SUMX2MY2 function - Math and trigonometry - Returns the sum of the difference of squares of corresponding values in two arrays
 * SUMX2PY2 function - Math and trigonometry - Returns the sum of the sum of squares of corresponding values in two arrays
 * SUMXMY2 function - Math and trigonometry - Returns the sum of squares of differences of corresponding values in two arrays
 * SWITCH function - Logical - 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.
 * SYD function - Financial - Returns the sum-of-years' digits depreciation of an asset for a specified period
 * T function - Text - Converts its arguments to text
 * TAN function - Math and trigonometry - Returns the tangent of a number
 * TANH function - Math and trigonometry - Returns the hyperbolic tangent of a number
 * TDIST function - Compatibility - Returns the Student's t-distribution
 * TEXT function - Text - Formats a number and converts it to text
 * TIME function - Date and time - Returns the serial number of a particular time
 * TIMEVALUE function - Date and time - Converts a time in the form of text to a serial number
 * TINV function - Compatibility - Returns the inverse of the Student's t-distribution
 * TODAY function - Date and time - Returns the serial number of today's date
 * TRANSPOSE function - Lookup and reference - Returns the transpose of an array
 * TREND function - Statistical - Returns values along a linear trend
 * TRIM function - Text - Removes spaces from text
 * TRIMMEAN function - Statistical - Returns the mean of the interior of a data set
 * TRUE function - Logical - Returns the logical value TRUE
 * TRUNC function - Math and trigonometry - Truncates a number to an integer
 * TTEST function - Compatibility - Returns the probability associated with a Student's t-test
 * TYPE function - Information - Returns a number indicating the data type of a value
 * UPPER function - Text - Converts text to uppercase
 * VALUE function - Text - Converts a text argument to a number
 * VAR function - Compatibility - Estimates variance based on a sample
 * VARA function - Statistical - Estimates variance based on a sample including numbers
 * VARP function - Compatibility - Calculates variance based on the entire population
 * VARPA function - Statistical - Calculates variance based on the entire population including numbers
 * VDB function - Financial - Returns the depreciation of an asset for a specified or partial period by using a declining balance method
 * VLOOKUP function - Lookup and reference - Looks in the first column of an array and moves across the row to return the value of a cell
 * WEEKDAY function - Date and time - Converts a serial number to a day of the week
 * WEIBULL function - Compatibility - Calculates variance based on the entire population including numbers
 * YEAR function - Date and time - Converts a serial number to a year
 * ZTEST function - Statistical - Returns the one-tailed probability-value of a z-test