# Supported Excel Formulae

XLCubed Web Edition supports the following Excel formulae, as well as all XLCubed formulae.

## Contents

- 1 Database and List Management Functions
- 2 Date and Time Functions
- 3 Engineering Functions
- 4 Financial Functions
- 5 Information Functions
- 6 Logical Functions
- 7 Lookup and Reference Functions
- 8 Math and Trigonometry Functions
- 9 Pre-Excel 2010 Statistical Functions
- 10 Statistical Functions
- 11 Text Functions
- 12 Web Functions
- 13 See Also

## Database and List Management Functions

DAVERAGE | Indicates the average of the values that meet the specified criteria. | v6.5 |

DCOUNT | Counts the number of cells containing numbers that meet the specified criteria. | v6.5 |

DCOUNTA | Counts nonblank cells containing numbers or text that meet the specified criteria. | v6.5 |

DGET | Returns a single value that meets the specified criteria. | v6.5 |

DMAX | Extracts the highest value that meets the specified criteria. | v6.5 |

DMIN | Extracts the lowest value that meets the specified criteria. | v6.5 |

DPRODUCT | Returns the product of the values that meet the specified criteria. | v6.5 |

DSTDEV | Estimates the standard deviation of a population, based on a sample of selected entries from the database. | v6.5 |

DSTDEVP | Returns the calculation of the standard deviation of a population, based on the sum of the whole population. | v6.5 |

DSUM | Returns the total of the values that meet the specified criteria. | v6.5 |

DVAR | Estimates the variance of a sample population based on the values that meet the specified criteria. | v6.5 |

DVARP | Returns the calculation of the true variance of an entire population based on the values that meet the specified criteria. | v6.5 |

## Date and Time Functions

DATE | Returns the serial number that represents a date. | v6.5 |

DATEDIF | Returns the difference of two dates in years, months or days. | v6.5 |

DATEVALUE | Converts date text to a DATEVALUE serial number. | v6.5 |

DAY | Returns the corresponding day of the month serial number or date text from 1 to 31. | v6.5 |

DAYS | Returns the number of days between the two specified dates. | v9.0 |

DAYS360 | Returns the number of days between two set dates based on a 360-day year. | v6.5 |

EDATE | Returns the value or serial number of the date which is a certain number of months before or after a user-specified date. | v6.5 |

EOMONTH | Returns the date at the end of the month a specified number of months before or after a specified date. | v6.5 |

HOUR | Returns the hour as a serial number integer between 0 and 23. | v6.5 |

ISOWEEKNUM | Returns the ISO week number for a specified date. | v9.0 |

MINUTE | Returns the serial number that corresponds to the minute. | v6.5 |

MONTH | Returns the corresponding serial number of the month of a date between 1 and 12. | v6.5 |

NETWORKDAYS | Returns the number of working days between two dates. Excludes weekends and specified holidays. | v6.5 |

NETWORKDAYS.INTL | Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. | v8.0 |

NOW | Returns the current date and time in the form of a serial number. | v6.5 |

SECOND | Returns the seconds portion of a serial time value. | v6.5 |

TIME | Returns the decimal value of a given time. | v6.5 |

TIMEVALUE | Returns the decimal number for a given time. | v6.5 |

TODAY | Returns the current date as a serial number. | v6.5 |

WEEKDAY | Returns the corresponding day of the week as a serial number. | v6.5 |

WEEKNUM | Returns the number where a week falls numerically within a year. | v6.5 |

WORKDAY | Returns a date that is a specified number of working days before or after a given date. | v6.5 |

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. | v8.0 |

YEAR | Returns the corresponding year as a serial number in the form of an integer. | v6.5 |

YEARFRAC | Calculates the fraction of the year between two dates. | v6.5 |

## Engineering Functions

BESSELI | Returns the BESSEL function in modified form for imaginary arguments. | v6.5 |

BESSELJ | Returns the actual BESSEL function. | v6.5 |

BESSELK | Returns the BESSEL function in modified form for imaginary arguments. | v6.5 |

BESSELY | Returns the BESSEL function, also known as the Weber or Neumann function. | v6.5 |

BIN2DEC | Converts a binary number to decimal form. | v6.5 |

BIN2HEX | Converts a binary number to a hexadecimal. | v6.5 |

BIN2OCT | Converts a binary number to octal form. | v6.5 |

BITAND | Returns the bitwise AND of the two specified numbers. | v9.0 |

BITLSHIFT | Returns the specified number shifted left by the specified amount. | v9.0 |

BITOR | Returns the bitwise OR of the two specified numbers. | v9.0 |

BITRSHIFT | Returns the specified number shifted right by the specified amount. | v9.0 |

BITXOR | Returns the bitwise XOR of the two specified numbers. | v9.0 |

COMPLEX | Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj. | v6.5 |

CONVERT | Interprets data from one measurement system to another. | v6.5 |

DEC2BIN | Converts decimal numbers to binary form. | v6.5 |

DEC2HEX | Converts decimal numbers to hexadecimal. | v6.5 |

DEC2OCT | Converts decimal numbers to octal. | v6.5 |

DELTA | Tests whether numbers or values are equal with a number result. Returns "0" for unequal, "1" for equal. | v6.5 |

ERF | Returns the integrated error function between a lower and upper limit. | v6.5 |

ERF.PRECISE | Returns the error function | v8.0 |

ERFC | Returns a complementary ERF function integrated between 'x' and infinity. | v6.5 |

ERFC.PRECISE | Returns the complementary ERF function integrated between x and infinity | v8.0 |

GESTEP | Returns the value 1 if the number is greater than or equal to a specified step value, otherwise it returns 0. | v6.5 |

HEX2BIN | Converts hexadecimal numbers to binary form. | v6.5 |

HEX2DEC | Converts hexadecimal numbers to decimal form. | v6.5 |

HEX2OCT | Converts hexadecimal numbers to octal form. | v6.5 |

IMABS | Returns the absolute value (modulus) of a complex number in x+yi or x+yj text format. | v6.5 |

IMAGINARY | Returns the coefficient of a complex number in x+yi or x+yj text format. | v6.5 |

IMARGUMENT | Returns the theta argument - an angle expressed in radians. | v6.5 |

IMCONJUGATE | Returns the complex conjugate of a complex number in x+yi or x+yj text format. | v6.5 |

IMCOS | Returns the cosine of a complex number in x+yi or x+yj text format. | v6.5 |

IMCOSH | Returns the hyperbolic cosine of the specified complex number. | v9.0 |

IMCOT | Returns the cotangent of the specified complex number. | v9.0 |

IMCSC | Returns the cosecant of the specified complex number. | v9.0 |

IMCSCH | Returns the hyperbolic cosecant of the specified complex number. | v9.0 |

IMDIV | Returns the quotient of complex numbers in x+yi or x+yj text format. | v6.5 |

IMEXP | Returns the exponential of a complex number in x+yi or x+yj text format. | v6.5 |

IMLN | Returns the natural logarithm of a complex number in x+yi or x+yj text format. | v6.5 |

IMLOG10 | Returns the common logarithm (Base 10) of a complex number in x+yi or x+yj text format. | v6.5 |

IMLOG2 | Returns the common logarithm (Base 2) of a complex number in x+yi or x+yj text format. | v6.5 |

IMPOWER | Returns a complex number raised to a power in x+yi or x+yj text format. | v6.5 |

IMPRODUCT | Returns the product from 2 to 29 complex numbers in x+yi or x+yj text format. | v6.5 |

IMREAL | Returns the real coefficient of a complex number in x+yi or x+yj text format. | v6.5 |

IMSEC | Returns the secant of the specified complex number. | v9.0 |

IMSECH | Returns the hyperbolic secant of the specified complex number. | v9.0 |

IMSIN | Returns the sine of a complex number in x+yi or x+yj text format. | v6.5 |

IMSINH | Returns the hyperbolic sine of the specified complex number. | v9.0 |

IMSQRT | Returns the square root of a complex number in x+yi or x+yj text format. | v6.5 |

IMSUB | Returns the difference of two complex numbers in x+yi or x+yj text format. | v6.5 |

IMSUM | Returns the sum of 2 to 29 complex numbers in x+yi or x+yj text format. | v6.5 |

IMTAN | Returns the tangent of the specified complex number. | v9.0 |

OCT2BIN | Converts an octal number to binary form. | v6.5 |

OCT2DEC | Converts an octal number to decimal form. | v6.5 |

OCT2HEX | Converts an octal number to hexadecimal form. | v6.5 |

## Financial Functions

ACCRINT | Returns accrued interest for securities that pay periodic interest. | v6.5 |

ACCRINTM | Returns the accrued interest for securities that pay interest at the maturity date. | v6.5 |

AMORDEGRC | Returns the depreciation for each accounting period within the formula. | v6.5 |

AMORLINC | Returns the depreciation for each accounting period. | v6.5 |

COUPDAYBS | Returns the number of days from the beginning of the period to the coupon-period settlement date. | v6.5 |

COUPDAYS | Returns the number of days in the period that contains the coupon period settlement date. | v6.5 |

COUPDAYSNC | Returns the number of days between the settlement date to the next coupon date. | v6.5 |

COUPNCD | Returns the next coupon date after the settlement date. | v6.5 |

COUPNUM | Returns the total number of coupons to be paid between the settlement and maturity dates, rounded up to the nearest whole coupon. | v6.5 |

COUPPCD | Returns the coupon date previous to the settlement date. | v6.5 |

CUMIPMT | Returns the cumulative interest on a loan between start and stop dates. | v6.5 |

CUMPRINC | Returns the cumulative principal amount between start and stop dates on a loan or mortgage. | v6.5 |

DB | Returns the asset depreciation for a period using the fixed declining balance method. | v6.5 |

DDB | Returns the asset depreciation for a period using the double-declining balance method or another specified method. | v6.5 |

DISC | Returns the security discount rate. | v6.5 |

DOLLARDE | Converts a fraction dollar price into a decimal dollar price. | v6.5 |

DOLLARFR | Converts a decimal dollar price into a fraction dollar price. | v6.5 |

DURATION | Returns the Macauley duration for an assumed par value. | v6.5 |

EFFECT | Returns the effective interest rate annually. This is based on the nominal annual interest rate and the number of compounding periods per year. | v6.5 |

FV | Returns the future value of an investment that makes payments as a lump sum or as a series of equal periodic payments. | v6.5 |

FVSCHEDULE | Returns the future value of a principal amount after applying several, or a series of compound interest rates. | v6.5 |

INTRATE | Returns the interest rate of a security that is fully invested. | v6.5 |

IPMT | Returns the interest for a period of time based on an investment with periodic constant payments and a constant interest rate. | v6.5 |

IRR | Returns the internal rate of return for a series of cash flows represented by numbers in the form of values. | v8.0 |

ISPMT | Calculates the interest paid during a defined period of an investment. | v6.5 |

MDURATION | Returns the modified duration of a security with a par value assumed to be $100. | v6.5 |

MIRR | Returns a modified internal rate of return for several periodic cash flows. | v6.5 |

NOMINAL | Returns the nominal annual interest rate given an effective rate and the total number of compounding periods for the year. | v6.5 |

NPER | Returns the total number of periods for an investment. This is based on a periodic constant payment and a constant interest rate. | v6.5 |

NPV | Calculates the net present value of an investment from the discount rate and several future payments and income. | v6.5 |

ODDFPRICE | Returns the value of a security based on a per $100 face value and an odd (short or long) first period. | v6.5 |

ODDFYIELD | Returns the security yield with an odd first period. | v6.5 |

ODDLPRICE | Returns the per $100 face value of a security having an odd last coupon period. | v6.5 |

ODDLYIELD | Returns the security yield that has an odd last period. | v6.5 |

PDURATION | Returns the number of periods for the specified present value to reach the specified future value given the specified interest rate. | v9.0 |

PMT | Calculates the loan payment for a loan based on constant payments and constant interest rates. | v6.5 |

PPMT | Returns the principal payment for a period of an investment based on periodic constant payments and a constant interest rate. | v6.5 |

PRICE | Returns the value of a security based on price per $100 face value and periodic interest payments. | v6.5 |

PRICEDISC | Returns the value of a discounted security based on a price per $100 face value. | v6.5 |

PRICEMAT | Returns the value of a security that pays interest at maturity and price per $100 face value. | v6.5 |

PV | Returns the present value based on an investment. | v6.5 |

RATE | Returns per period the interest of an annuity. | v6.5 |

RECEIVED | Based on a fully invested security, returns the amount received at maturity. | v6.5 |

RRI | Returns the effective interest rate required for the specified present value to reach the specified future value in the specified number of periods. | v9.0 |

SLN | Returns the straight-line depreciation on an asset. | v6.5 |

SYD | Based on a specified period, SYD returns the sum-of-years' digits depreciation of an asset. | v6.5 |

TBILLEQ | Returns the bond equivalent yield for a treasury bill. | v6.5 |

TBILLPRICE | Returns the price per $100 face value for a treasury bill. | v6.5 |

TBILLYIELD | Returns the yield of a treasury bill. | v6.5 |

VDB | For a period you specify, returns the depreciation of an asset. | v6.5 |

XIRR | Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. | v6.5 |

XNPV | Returns the net present value for a schedule of cash flows that is not necessarily periodic. | v6.5 |

YIELD | Based on a yield that pays periodic interest, returns the yeild of the security. | v6.5 |

YIELDDISC | Returns the annual yield for a discounted security. | v6.5 |

YIELDMAT | Returns the annual yield based on a security that pays interest at a maturity. | v6.5 |

## Information Functions

CELL | Returns information about a cell's location, formatting, or contents in the upper-left cell in a reference. | v8.0 |

ERROR.TYPE | Returns the corresponding number value associated with an error type in Microsoft Excel. | v6.5 |

INFO | Returns operating environment information. | v9.0 |

ISBLANK | Returns TRUE if the cell is empty, FALSE if it contains data. | v6.5 |

ISERR | Returns TRUE if value contains any error value except #N/A, FALSE if it does not. | v6.5 |

ISERROR | Returns TRUE if value contains any error value (including #N/A), FALSE if it does not. | v6.5 |

ISEVEN | Returns TRUE if value is an even number, FALSE if it is not. | v6.5 |

ISFORMULA | Returns TRUE if the specified cell contains a formula. | v9.0 |

ISLOGICAL | Returns TRUE if value is a logical value, FALSE if it is not. | v6.5 |

ISNA | Returns TRUE if value is #N/A, FALSE if it is not. | v6.5 |

ISNONTEXT | Returns TRUE if value is not text, FALSE if it is. | v6.5 |

ISNUMBER | Returns TRUE if value is a number, FALSE if it is not. | v6.5 |

ISODD | Returns TRUE if value is an odd number, FALSE if it is not. | v6.5 |

ISREF | Returns TRUE if value is a reference, FALSE if it is not. | v6.5 |

ISTEXT | Returns TRUE if value is text, FALSE if it is not. | v6.5 |

N | Returns a value converted to a number. | v6.5 |

NA | An alternative representation of the error value #N/A. | v6.5 |

SHEET | Returns the one based index of the specified sheet, or the index of the sheet containing the formula if no sheet is specified. | v9.0 |

SHEETS | Returns the number of sheets in a 3d cell reference, or the number of sheets in the workbook containing the formula if no reference is specified. | v9.0 |

TYPE | Determines the type of value in a cell. | v6.5 |

## Logical Functions

AND | Returns TRUE if all the arguments are TRUE in the formula, and FALSE if any one argument is FALSE. | v6.5 |

FALSE | Returns the value FALSE. May be typed directly into the cell as "FALSE". | v6.5 |

IF | Returns a value if one condition is TRUE and returns another value if the condition is FALSE. | v6.5 |

IFERROR | Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula | v6.5 |

IFNA | Returns the specified first argument unless it is #N/A, in which case it returns the specified second argument. | v9.0 |

NOT | Returns the reverse value of its arguments; TRUE becomes FALSE and FALSE becomes TRUE. | v6.5 |

OR | Returns FALSE if all arguments are FALSE, and TRUE if at least one argument is TRUE. | v6.5 |

TRUE | Returns the value TRUE. May be typed directly into the cell as "TRUE". | v6.5 |

XOR | Returns TRUE if the specified arguments contain an odd number of TRUE values, or FALSE if the values contain an even number of TRUE values. | v9.0 |

## Lookup and Reference Functions

ADDRESS | Given specified row and column numbers, creates a cell address as text. | v6.5 |

AREAS | Returns the number of areas based on a reference. | v6.5 |

CHOOSE | Returns an item from a list of values.. | v6.5 |

COLUMN | Returns the column number(s) based on a given reference. | v6.5 |

COLUMNS | Returns the number of columns based on an array or reference. | v6.5 |

HLOOKUP | Searches for a specified value in an array or a table's top row. | v6.5 |

HYPERLINK | Creates a shortcut to jump to a document stored on a network server. | v6.5 |

INDEX | Returns the value of an element selected by the row number and column letter indexes. | v6.5 |

INDIRECT | Returns the contents of a cell using its reference. | v6.5 |

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. | v6.5 |

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. | v6.5 |

OFFSET | Returns a reference to a range that is a specific number of rows and columns from a cell or range of cells. | v6.5 |

ROW | Returns the row number based on a reference. | v6.5 |

ROWS | Returns the number of rows in a reference or array. | v6.5 |

TRANSPOSE | Returns a horizontal range of cells as vertical or vice versa. | v6.5 |

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. | v6.5 |

## Math and Trigonometry Functions

ABS | Returns the absolute value of a number. | v6.5 |

ACOS | Returns the arccosine of a number in radians in the range 0 to pi. | v6.5 |

ACOSH | Returns the inverse hyperbolic cosine of a number. | v6.5 |

ACOT | Returns the inverse cotangent of the specified number. | v9.0 |

ACOTH | Returns the inverse hyperbolic cotangent of the specified number. | v9.0 |

AGGREGATE | Returns an aggregate in a list or database | v9.0 |

ARABIC | Converts the specified Roman numeral to a number. | v9.0 |

ASIN | Returns the arcsine of a number in radians in the range -pi/2 to pi/2. | v6.5 |

ASINH | Returns the inverse hyperbolic sine of a number. | v6.5 |

ATAN | Returns the arctangent of a number in radians in the range -pi/2 to pi/2 | v6.5 |

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. | v6.5 |

ATANH | Returns the inverse hyperbolic tangent of a number. | v6.5 |

BASE | Converts the specified number to text with the specified radix and minimum length. | v9.0 |

CEILING | Returns a number rounded up, away from zero, to the nearest multiple of significance. | v6.5 |

CEILING.MATH | Returns the specified number rounded up using the specified significance and mode. | v9.0 |

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. | v8.0 |

COMBIN | Returns the number of combinations for a given number of items. | v6.5 |

COMBINA | Returns the number of combinations with the specified number of items. | v9.0 |

COS | Returns the cosine of the given angle. | v6.5 |

COSH | Returns the hyperbolic cosine of a number. | v6.5 |

COT | Returns the cotangent of the specified angle. | v9.0 |

COTH | Returns the hyperbolic cotangent of the specified angle. | v9.0 |

CSC | Returns the cosecant of the specified angle. | v9.0 |

CSCH | Returns the hyperbolic cosecant of the specified angle. | v9.0 |

DECIMAL | Converts the specified text to a number using the specified radix. | v9.0 |

DEGREES | Converts radians into degrees. | v6.5 |

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. | v6.5 |

EXP | Returns e (2.71828182845804) raised to the power of a specified number. | v6.5 |

FACT | Returns the factorial of a number. | v6.5 |

FACTDOUBLE | Returns the double factorial of a number. | v6.5 |

FLOOR | Returns a number rounded down, toward zero, to the nearest multiple of significance. | v6.5 |

FLOOR.MATH | Returns the specified number rounded down using the specified significance and mode. | v9.0 |

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. | v8.0 |

GCD | Returns the greatest common divisor of two or more integers. | v6.5 |

INT | Rounds a number down to the nearest integer. | v6.5 |

ISO.CEILING | Returns the specified number rounded up using the specified significance. | v9.0 |

LCM | Returns the least common multiple of integers. | v6.5 |

LN | Returns the natural (base e) logarithm of a number. | v6.5 |

LOG | Returns the logarithm of a number of the base you specify. | v6.5 |

LOG10 | Returns the base-10 logarithm of a number. | v6.5 |

MDETERM | Returns the matrix determinant of an array. | v6.5 |

MINVERSE | Returns the inverse matrix for the matrix stored in an array. | v6.5 |

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. | v6.5 |

MOD | Returns the remainder of a division operation (modulus). | v6.5 |

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. | v6.5 |

MULTINOMIAL | Returns the ratio of the factorial of the sum of the values to the product of the factorials. | v6.5 |

MUNIT | Returns an identity matrix with the specified n by n dimension. | v9.0 |

ODD | Returns a number rounded up away from zero to the nearest odd integer. | v6.5 |

PI | Returns the approximate number 3.14159265358979, the mathematical constant pi, accurate to 15 digits. | v6.5 |

POWER | Returns the result of a specified number raised to a specified power. | v6.5 |

PRODUCT | Multiplies all the numbers given as arguments and returns the product. | v6.5 |

QUOTIENT | Returns the integer portion of a division. | v6.5 |

RADIANS | Converts degrees to radians. | v6.5 |

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. | v6.5 |

RANDBETWEEN | Returns a random integer between the integers you specify. A new random number is returned every time the worksheet is calculated. | v6.5 |

ROMAN | Converts an Arabic numeral to Roman, as text. | v6.5 |

ROUND | Round a number to a specified number of digits. | v6.5 |

ROUNDDOWN | Rounds a number down, towards zero. | v6.5 |

ROUNDUP | Rounds a number up, away from zero. | v6.5 |

SEC | Returns the secant of the specified angle. | v9.0 |

SECH | Returns the hyperbolic secant of the specified angle. | v9.0 |

SERIESSUM | Returns the sum of a power series. | v6.5 |

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. | v6.5 |

SIN | Returns the sine of a given angle. | v6.5 |

SINH | Returns the hyperbolic sine of a number. | v6.5 |

SQRT | Returns a positive square root. | v6.5 |

SQRTPI | Returns the square root of (NUMBER * Pi) | v6.5 |

SUBTOTAL | Returns a subtotal in a list or database. | v6.5 |

SUM | Adds all the numbers in a range of cells. | v6.5 |

SUMIF | Adds the cells specified by a certain criteria. | v6.5 |

SUMIFS | Adds the cells in a range that meet multiple criteria | v8.0 |

SUMPRODUCT | Multiplies corresponding components in the given arrays, and returns the sum of those products. | v6.5 |

SUMSQ | Returns the sum of the squares of the arguments. | v6.5 |

SUMX2MY2 | Returns the sum of the difference of squares of corresponding values in two arrays. | v6.5 |

SUMX2PY2 | Returns the sum of the sum of squares of corresponding values in two arrays. | v6.5 |

SUMXMY2 | Returns the sum of squares of differences of corresponding values in two arrays. | v6.5 |

TAN | Returns the tangent of the given angle. | v6.5 |

TANH | Returns the hyperbolic tangent of a number. | v6.5 |

TRUNC | Truncates a number to an integer by removing the fractional part of a number. | v6.5 |

## Pre-Excel 2010 Statistical Functions

BETADIST | Returns the cumulative beta probability density function. | v6.5 |

BETAINV | Returns the inverse of the cumulative beta probability density function. | v6.5 |

BINOMDIST | Returns the individual term binomial distribution probability. | v6.5 |

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. | v6.5 |

CHIINV | Returns the inverse of the one-tailed probability of the chi-squared (X^2) distribution. | v6.5 |

CHITEST | Returns the test for independence of the characteristics in a table. | v6.5 |

CONFIDENCE | Returns the confidence interval for a population mean. | v6.5 |

COVAR | Returns the covariance, the average of products of deviations, for each data point pair. | v6.5 |

EXPONDIST | Returns the exponential distribution. | v6.5 |

FDIST | Returns the F probability distribution. | v6.5 |

FINV | Returns the inverse of the F probability distribution. | v6.5 |

FTEST | Returns the result of an F-test. | v6.5 |

GAMMADIST | Returns the gamma distribution. | v6.5 |

GAMMAINV | Returns the inverse of the gamma cumulative distribution. | v6.5 |

LOGINV | Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard deviation. | v6.5 |

LOGNORMDIST | Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard deviation. | v6.5 |

MODE | Returns the most frequently occuring, or repetitive, number in an array or range of data. | v6.5 |

NEGBINOMDIST | Returns the negative binomial distribution. | v6.5 |

NORMDIST | Returns the normal cumulative distribution for the specified mean and standard deviation. | v6.5 |

NORMINV | Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. | v6.5 |

NORMSDIST | Returns the standard normal cumulative distribution function. | v6.5 |

PERCENTILE | Returns the k-th percentile of values in a range. | v6.5 |

PERCENTRANK | Returns the rank of a value in a data set set as a percentage of the data set. | v6.5 |

POISSON | Returns the Poisson distribution. | v6.5 |

QUARTILE | Returns the quartile of a data set. | v6.5 |

RANK | Returns the rank of a number in a list of numbers. | v6.5 |

STDEV | Estimates standard deviation based on a sample. | v6.5 |

STDEVP | Estimates standard deviation based on a sample assuming that the arguments represent the total population. | v6.5 |

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. | v6.5 |

TINV | Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. | v6.5 |

TTEST | The probability associated with t-test. | v6.5 |

VAR | Returns an estimate for the variance of a population based on a sample data set. | v6.5 |

VARP | Calculates variance based on the entire population. | v6.5 |

WEIBULL | Returns the Weibull distribution. | v6.5 |

ZTEST | Returns the two-tailed P-value of a z-test. | v6.5 |

## Statistical Functions

AVEDEV | Retuns the average of the absolute deviations of data points from their mean. | v6.5 |

AVERAGE | Returns the average of its arguments. | v6.5 |

AVERAGEA | Returns the average of the values in its list of arguments including text and logical values. | v6.5 |

AVERAGEIF | Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria | v8.0 |

AVERAGEIFS | Returns the average (arithmetic mean) of all cells that meet multiple criteria | v8.0 |

BETA.DIST | Returns the beta cumulative distribution function | v8.0 |

BETA.INV | Returns the inverse of the cumulative distribution function for a specified beta distribution | v8.0 |

BINOM.DIST | Returns the individual term binomial distribution probability | v8.0 |

BINOM.DIST.RANGE | Returns the probability of the specified trial using a binomial distribution. | v9.0 |

BINOM.INV | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value | v8.0 |

CHISQ.DIST | Returns the chi-squared distribution | v8.0 |

CHISQ.DIST.RT | Returns the one-tailed probability of the chi-squared distribution | v8.0 |

CHISQ.INV | Returns the inverse of the left-tailed probability of the chi-squared distribution | v8.0 |

CHISQ.INV.RT | Returns the inverse of the right-tailed probability of the chi-squared distribution | v8.0 |

CHISQ.TEST | Returns the test for independence. | v8.0 |

CONFIDENCE.NORM | Returns the confidence interval for a population mean. | v8.0 |

CONFIDENCE.T | Returns the confidence interval for a population mean, using a Student's t distribution | v8.0 |

CORREL | Returns the correlation coefficient between two data sets. | v6.5 |

COUNT | Counts the number of cells that contain numbers (including dates and formulas that evaluate to numbers) within the list of arguments. | v6.5 |

COUNTA | Counts the number of cells that are not empty. | v6.5 |

COUNTBLANK | Counts the empty cells in a specified range. | v6.5 |

COUNTIF | Counts the number of cells in a range that meet a given criteria. | v6.5 |

COUNTIFS | Counts the number of cells within a range that meet multiple criteria | v8.0 |

COVARIANCE.P | Returns covariance, the average of the products of paired deviations | v8.0 |

COVARIANCE.S | Returns the sample covariance, the average of the products deviations for each data point pair intwo data sets | v8.0 |

CRITBINOM | Returns the minimum number yields a binomial distribution less than or equal to the specified criteria | v6.5 |

DEVSQ | Returns the sum of the squares of deviations of a data set from their sample mean. | v6.5 |

EXPON.DIST | Returns the exponential distribution. | v8.0 |

F.DIST | Returns the F probability distribution. | v8.0 |

F.DIST.RT | Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets | v8.0 |

F.INV | Returns the inverse of the F probability distribution | v8.0 |

F.INV.RT | Returnd the inverse of the (right-tailed) F probability distribution | v8.0 |

F.TEST | Returns the result of an F-test. | v8.0 |

FISHER | Returns the Fisher transformation at x. | v6.5 |

FISHERINV | Returns the inverse of the Fisher transformation at y. | v6.5 |

FORECAST | Calculates or predicts a future value by using existing values. | v6.5 |

FREQUENCY | Calculates how often values occur within a range of values and then returns a vertical array of numbers. | v6.5 |

GAMMA | Returns the gamma funnction result for the specified number. | v9.0 |

GAMMA.DIST | Returns the gamma distribution. | v8.0 |

GAMMA.INV | Returns the inverse of the gamma cumulative distribution. | v8.0 |

GAMMALN | Returns the natural logarithm of the gamma function. | v6.5 |

GAMMALN.PRECISE | Returns the natural logarithm of the gamma function. | v8.0 |

GAUSS | Returns the probability that a number will fall between the mean and the specified standard deviation in a normal distribution. | v9.0 |

GEOMEAN | Returns the geometric mean of an array or range of positive data. | v6.5 |

GROWTH | Calculates predicted exponential growth by using existing data. | v6.5 |

HARMEAN | Returns the harmonic mean of a data set. | v6.5 |

HYPGEOM.DIST | Returns the hypergeometric distribution. | v8.0 |

HYPGEOMDIST | Returns the hypergeometric distribution. | v6.5 |

INTERCEPT | Calculates the point at which a line will intersect the y-axis by using existing x and y values. | v6.5 |

KURT | Returns the Kurtosis of a data set. | v6.5 |

LARGE | Returns the k-th largest value in a data set. | v6.5 |

LINEST | Calculates a straight line that best fits your data using the least squares method. | v6.5 |

LOGEST | Calculates an exponential curve that fits your data and returns an array of values that describes the curve. | v6.5 |

LOGNORM.DIST | Returns the lognormal distribution, of x, where ln(x) is normally distributed with mean and standard deviation. | v8.0 |

LOGNORM.INV | Returns the inverse of the lognormal cumulative distribution. | v8.0 |

MAX | Returns the largest value in a set of values. | v6.5 |

MAXA | Returns the largest value in a set of values including text and logical values. | v6.5 |

MEDIAN | Returns the median of the given numbers. | v6.5 |

MIN | Returns the smallest value in a set of values. | v6.5 |

MINA | Returns the smallest value in a set of values including text and logical values. | v6.5 |

MODE.MULT | Returns a vertical array of the most frequestly occurring, or repetitive values in an array or range of data. | v8.0 |

MODE.SNGL | Returns the most common value in a data set. | v8.0 |

NEGBINOM.DIST | Returns the negative binomial distribution. | v8.0 |

NORM.DIST | Returns the normal cumulative distribution. | v8.0 |

NORM.INV | Returns the inverse of the normal cumulative distribution. | v8.0 |

NORM.S.DIST | Return the standard normal cumulative distribution. | v8.0 |

NORM.S.INV | Returns the inverse of the standard normal cumulative distribution. | v8.0 |

NORMSINV | Returns the inverse of the standard normal cumulative distribution function. | v6.5 |

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. | v6.5 |

PERCENTILE.EXC | Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive | v8.0 |

PERCENTILE.INC | Returns the k-th percentile of values in a range. | v8.0 |

PERCENTRANK.EXC | Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set | v8.0 |

PERCENTRANK.INC | Returns the percentage rank of a value in a data set | v8.0 |

PERMUT | Returns the number of permutations for a given number of objects that can be selected from a range of numbers. | v6.5 |

PERMUTATIONA | Returns the number of permutations given the specified total number of items and the specified number of items chosen for each permutation. | v9.0 |

PHI | Returns the value of the probability density function of the specified number for the standard normal distribution. | v9.0 |

POISSON.DIST | Returns the Poisson distribution. | v8.0 |

PROB | Returns the probability that values in a range are between two specified limits. | v6.5 |

QUARTILE.EXC | Returns the quartile of the data set, based on percentile values fro 0..1, exclusive. | v8.0 |

QUARTILE.INC | Returns the quartile of a data set. | v8.0 |

RANK.AVG | Returns the rank of a number in a list of numbers. | v8.0 |

RANK.EQ | Returns the rank of a number in a list of numbers. | v8.0 |

RSQ | Returns the r^2 value of a linear regression line. | v6.5 |

SKEW | Returns the skew of a distribution. | v6.5 |

SKEW.P | Returns the population skewness of the specified distribution. | v9.0 |

SLOPE | Returns the slope of a regression line through data points in KNOWN_Y'S and KNOWN_X'S. | v6.5 |

SMALL | Returns the k-th smallest value in a data set. | v6.5 |

STANDARDIZE | Returns a normalized value from a distribution characterized by MEAN and STANDARD_DEV. | v6.5 |

STDEV.P | Calculates standard deviation based on the entire population | v8.0 |

STDEV.S | Estimates standard deviation based on a sample. | v8.0 |

STDEVA | Estimates standard deviation based on a sample. Includes text and logical values. | v6.5 |

STDEVPA | Estimates standard deviation based on a sample assuming that the arguments represent the total population. Includes text and logical values. | v6.5 |

STEYX | Returns the standard error of the predicted y value for each x in the regression. | v6.5 |

T.DIST | Returns the percentage points (probability) for the student t-distribution. | v8.0 |

T.DIST.2T | Returns the percentage points (probability) for the student t-distribution. | v8.0 |

T.DIST.RT | Returns the Student's t-distribution. | v8.0 |

T.INV | Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. | v8.0 |

T.INV.2T | Returns the inverse of the Student's t-distribution. | v8.0 |

T.TEST | Returns the probability associated with a Student's t-test. | v8.0 |

TREND | Returns the y-values along a linear trendline that best fits the values in a data set. | v6.5 |

TRIMMEAN | Returns the mean of the interior of a data set. | v6.5 |

VAR.P | Calculates variance based on the entire population | v8.0 |

VAR.S | Estimates variance based on a sample. | v8.0 |

VARA | Returns an estimate for the variance of a population based on a sample data set and may include text or logical values. | v6.5 |

VARPA | Calculates variance based on the entire population and may include text or logical values. | v6.5 |

WIEBULL.DIST | Returns the Weibull distribution. | v8.0 |

Z.TEST | Returns the one-tailed probability-value of a z-test. | v8.0 |

## Text Functions

CHAR | Returns the character specified by a number. | v6.5 |

CLEAN | Removes all nonprintable characters from text. | v6.5 |

CODE | Returns a numeric code from the first character in a text string. The opposite of the CHAR function. | v6.5 |

CONCATENATE | Joins several text strings into one text string. | v6.5 |

DOLLAR | Converts a number to text using Currency format, with the decimals rounded to the specified place. | v6.5 |

EXACT | Compares two text strings and returns TRUE if they are exactly the same, and FALSE otherwise. | v6.5 |

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. | v6.5 |

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. | v6.5 |

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. | v6.5 |

LEFT | Returns the first character(s) in a text string. | v6.5 |

LEFTB | Returns the first character(s) in a text string based on a specified number of bytes | v6.5 |

LEN | Returns the number of characters in a text string. | v6.5 |

LENB | Returns the number of characters in a text string expressed in bytes. | v6.5 |

LOWER | Converts all letters in a text string to lowercase. | v6.5 |

MID | Returns a specific number of characters from a text string starting at the position you specify. | v6.5 |

MIDB | Returns a group of characters based on a specified number of bytes from a text string starting at the position you specify. | v6.5 |

NUMBERVALUE | Converts the specified text to a number using the specified decimal seperator and thousands separator. | v9.0 |

PROPER | Capitalizes the first letter of each word in a text string or sentence. | v6.5 |

REPLACE | Replaces part of a text string with a different text string based on the number of characters you specify. | v6.5 |

REPLACEB | Replaces part of a text string with a different text string based on the number of characters you specify in terms of bytes. | v6.5 |

REPT | Repeats specified text a given number of times. | v6.5 |

RIGHT | Returns the last character(s) in a text string. | v6.5 |

RIGHTB | Returns the last character(s) in a text string based on a specified number of bytes. | v6.5 |

SEARCH | Returns the number of the character at which a specific character or text string is first found, reading from left to right. | v6.5 |

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. | v6.5 |

SUBSTITUTE | Substitutes NEW_TEXT for OLD_TEXT in a string. | v6.5 |

T | Returns the text referred to by a value. | v6.5 |

TEXT | Converts a value to text in a specific number format. | v6.5 |

TRIM | Removes all spaces from text except single spaces between words. | v6.5 |

UNICHAR | Convert the specified UTF-32 code point to text. | v9.0 |

UNICODE | Convert the first character in the specified text to a UTF-32 code point. | v9.0 |

UPPER | Converts text to uppercase. | v6.5 |

USDOLLAR | Converts a number to text using US Dollar format, with the decimals rounded to the specified place. | v6.5 |

VALUE | Converts a text string that represents a number to a number. | v6.5 |

## Web Functions

ENCODEURL | Returns the specified string as an encoded URL. | v9.0 |

FILTERXML | Returns the selected node(s) from the specified xml and xpath expression. | v9.0 |

WEBSERVICE | Returns the text result of an HTTP request from the specified URL. | v9.0 |