| 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 | 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 360-day year. |
| EDATE | Returns the value or serial number of the date which is a certain number of months before or after a user-specified 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. |
|
| 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. |
|
| 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 coupon-period 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 double-declining 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 straight-line depreciation on an asset. |
| SYD | Based on a specified period, SYD returns the sum-of-years' 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. |
|
| CELL | Returns information about a cell's location, formatting, or contents in the upper-left 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. |
|
| 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". |
|
| 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. |
|
| 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 four-quadrant 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 x-axis, 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 base-10 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. |
|
| 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 one-tailed probability of the chi-squared (X^2) distribution; the area in the right tail under the chi-squared distribution curve. |
| CHIINV | Returns the inverse of the one-tailed probability of the chi-squared (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 F-test. |
| 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 k-th 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 t-distribution, where a numeric value (x) is a calculated value of t for which the percentage points are to be computed. |
| TINV | Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. |
| TTEST | The probability associated with t-test. |
| 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 two-tailed P-value of a z-test. |
|
| 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 chi-squared distribution |
| CHISQ.DIST.RT | Returns the one-tailed probability of the chi-squared distribution |
| CHISQ.INV | Returns the inverse of the left-tailed probability of the chi-squared distribution |
| CHISQ.INV.RT | Returns the inverse of the right-tailed probability of the chi-squared 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 formulae 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 (right-tailed) 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 (right-tailed) F probability distribution |
| F.TEST | Returns the result of an F-test. |
| 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 y-axis by using existing x and y values. |
| KURT | Returns the Kurtosis of a data set. |
| LARGE | Returns the k-th 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 k-th percentile of values in a range, where k is in the range 0..1, exclusive |
| PERCENTILE.INC | Returns the k-th 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 k-th 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 t-distribution. |
| T.DIST.2T | Returns the percentage points (probability) for the student t-distribution. |
| T.DIST.RT | Returns the Student's t-distribution. |
| T.INV | Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. |
| T.INV.2T | Returns the inverse of the Student's t-distribution. |
| T.TEST | Returns the probability associated with a Student's t-test. |
| TREND | Returns the y-values 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 one-tailed probability-value of a z-test. |
|
| 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. |
