Supported Excel Formulae

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

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

See Also

• FluenceXL Formula Reference