Documents
User Generated
Resources
Learning Center

# OpenFormula-ISO29500-draft-comparison-Excel97 - Oasis

VIEWS: 0 PAGES: 68

• pg 1
```									Function     OpenFormula-Summary
ABS          Return the absolute (nonnegative) value.

Calculates the accrued interest for securities
ACCRINT      with periodic interest payments.

Calculates the accrued interest for securities
ACCRINTM     that pay at maturity.
ACOS         Return the arc cosine of a number. The angle is returned in radians.

ACOSH        Return the principal value of the inverse hyperbolic cosine
ACOT         Return the arc cotangent of a number. The angle is returned in radians.
ACOTH        Return the hyperbolic arc cotangent

Calculates the amortization value for the
French accounting system using degressive
AMORDEGRC    depreciation.
Calculates the amortization value for the
AMORLINC     French accounting system using linear
AND          Compute logical AND of all parameters.
ARABIC       Convert Roman numerals to Number.
Returns the number of areas in a given
AREAS        reference
ASC          Converts full-width to half-width ASCII and katakana characters.
ASIN         Return the arc sine of a number. The angle is returned in radians.
ASINH        Return the principal value of the inverse hyperbolic sine
ATAN         Return the arc tangent of a number. The angle is returned in radians.
ATAN2        Return the arc tangent given a coordinate of two numbers. The angle is retur
ATANH        Return the principal value of the inverse hyperbolic tangent

AVEDEV       Calculates the average of the absolute deviations of the values in list.
AVERAGE      Average the set of numbers
AVERAGEA     Average the set of numbers, including logical values inside a range

AVERAGEIF    Average the values of cells in a range that meet a criteria.

AVERAGEIFS   Average the values of cells that meet multiple criteria in multiple ranges.
B          Returns the probability of a trial result using binomial distribution.
BAHTTEXT
BASE       Converts a number into a text representation with the given base.

BESSELI    Returns the modified Bessel function of integer order In(x).

BESSELJ    Returns the Bessel function of integer order Jn(x) (cylinder function)

BESSELK    Returns the modified Bessel function of integer order Kn(x).

BESSELY    Returns the Bessel function of integer order Yn(x), also known as the Neuma
BETADIST   returns the value of the probability density function or the cumulative distrib

BETAINV    returns the inverse of BETADIST(x;a;b;a;b;TRUE()).
BIN2DEC    Converts a binary (base 2) number (up to 10 digits) to its decimal equivalent
th
BIN2HEX    Converts a binary (base 2) number (10 bit is sign) to its hexadecimal equiva
BIN2OCT    Converts a binary (base 2) number (10th bit is sign) to its octal (base 8) equiva
BINOMDIST        Returns the binomial distribution.
BITAND           Returns bitwise “and” of its parameters
BITLSHIFT        Returns left shift of value x by n bits (“<<”)
BITOR            Returns bitwise “or” of its parameters
BITRSHIFT        Returns right shift of value x by n bits (“>>”)
BITXOR           Returns bitwise “exclusive or” of its parameters
CEILING          Round a number N up to the nearest multiple of the second parameter, sign
CELL             Returns information about position, formatting or contents in a reference.
CHAR             Return character represented by the given numeric value
2
LEGACY.CHIDIST   returns the right-tail probability for the c -distribution.
CHIDIST
LEGACY.CHIINV    returns the inverse of LEGACY.CHIDIST(x; DegreesOfFreedom).
CHIINV
CHISQDIST        returns the value of the probability density function or the cumulative distrib
CHISQINV         returns the inverse of CHISQDIST(x; DegreesOfFreedom; TRUE()).
LEGACY.CHITEST   Returns some Chi square goodness-for-fit test.
CHITEST
CHOOSE        Uses an index to return a value from a list of values.
CLEAN         Remove all non-printable characters from the string and return the result.
CODE          Return numeric value corresponding to the first character of the text value.
COLUMN        Returns the column number(s) of a reference
COLUMNS       Returns the number of columns in a given range

COMBIN        Returns the number of different R-length sets that can be selected from N ite
COMBINA       Returns the number of combinations with repetitions.

COMPLEX       Creates a complex number from a given real coefficient and imaginary coeffi
CONCATENATE   Concatenate the text strings

CONFIDENCE    Returns the confidence interval for a population mean.
CONVERT       Returns a number converted from one unit system into another
CORREL       Calculates the correlation coefficient of values in N1 and N2.
COS          Return the cosine of an angle specified in radians.
COSH         Return the hyperbolic cosine of the given hyperbolic angle
COT          Return the cotangent of an angle specified in radians
COTH         Return the hyperbolic cotangent of the given hyperbolic angle
COUNT        Count the number of Numbers provided
COUNTA       Count the number of non-empty values
COUNTBLANK   Count the number of blank values
COUNTIF      Count the number of cells in a range that meet a criteria.

COUNTIFS     Count the number of cells that meet multiple criteria in multiple ranges.

Calculates the number of days between the
beginning of athe coupon period that contains
COUPDAYBS    the settlement date and the settlement date.

Calculates the number of days in a coupon
COUPDAYS     period that contains a settlement date.

Calculates the number of days between a
COUPDAYSNC   settlement date and the next coupon date.

Calculates the next coupon date following a
COUPNCD      settlement.

Calculates the number of outstanding coupons
COUPNUM      between settlement and maturity dates.

Calculates the next coupon date prior a
COUPPPCD     settlement.
COVAR                Calculates covariance of two cell ranges.
CRITBINOM            Returns the smallest value for which the cumulative binomial distribution is g
CSC                  Return the cosecant of an angle specified in radians.
CSCH                 Return the hyperbolic cosecant of the given angle specified in radians
CUBEKPIMEMBER
CUBEMEMBER
CUBEMEMBERPROPERTY
CUBERANKEDMEMBER
CUBESET
CUBESETCOUNT
CUBEVALUE

CUMIPMT              Calculates a cumulative interest payment.

CUMPRINC             Calculates a cumulative principal payment.
DATE                 Constructs a date from year, month, and day of month.
DATEDIF              Returns the difference in years, months, or days of two date numbers.
DATEVALUE            Returns the date serial number from given text.
Finds the average of values in a given field
from the records (rows) in a database that
DAVERAGE             match a search criteria.
DAY                  Returns the day from a date.
DAYS                 Returns the number of days between two dates
DAYS360              Returns the number of days between two dates using the 360-day year

Compute the depreciation allowance of an
DB                   asset.
DCOUNT               Counts the number of records (rows) in a database that match a search crite
DCOUNTA              Counts the number of records (rows) in a database that match a search crite

Compute the amount of depreciation at a
DDB                  given period of time.
DDE        Returns data from a DDE request
DEC2BIN    Converts a decimal number to base 2 (whose 10th bit is sign)
DEC2HEX    Converts a decimal number to base 16 (whose 40th bit is sign)
th
DEC2OCT    Converts a decimal number to base 8 (whose 30 bit is sign)
DECIMAL    Converts text representing a number in a given base into a base 10 number.
DELTA      Report if two numbers are equal, returns 1 if they are equal.

DEVSQ      Calculates sum of squares of deviations.
DGET       Gets the single value in the field from the single record (row) in a database th

DISC       Returns the discount rate of a security.
DMAX       Finds the maximum value in a given field from the records (rows) in a databa
DMIN       Finds the minimum value in a given field from the records (rows) in a databa
DOLLAR     Convert the parameters to Text formatted as currency.

Converts a fractional dollar representation into
DOLLARDE   a decimal representation.
Converts a decimal dollar representation into a
DOLLARFR   fractional representation.

DPRODUCT   Finds the product of values in a given field from the records (rows) in a datab
DSTDEV     Finds the sample standard deviation in a given field from the records (rows)
DSTDEVP    Finds the population standard deviation in a given field from the records (row
DSUM       Finds the sum of values in a given field from the records (rows) in a database
Returns the Macaulay duration of a fixed
DURATION       interest security in years
DVAR           Finds the sample variance in a given field from the records (rows) in a databa
DVARP          Finds the population variance in a given field from the records (rows) in a da
ECMA.CEILING
Returns the serial number of a given date

Returns the net annual interest rate for a
EFFECT         nominal interest rate.
EOMONTH        Returns the serial number of the end of a month, given date plus MonthAdd

ERF            Calculates the error function.
ERFC           Calculates the complementary error function.
ERROR.TYPE     Returns Number representing the specific error type.
EUROCONVERT    Converts a number from one to another Euro currency.
EVEN           Rounds a number up to the nearest even integer. Rounding is away from zer
EXACT          Report if two text values are exactly equal using a case-sensitive comparison
EXP            Returns e raised by the given number.
EXPONDIST      returns the value of the probability density function or the cumulative distrib
FACT           Return factorial (!).
FACTDOUBLE     Returns double factorial (!!).
FALSE          Returns constant FALSE
FDIST          returns the value of the probability density function or the cumulative distrib
LEGACY.FDIST   returns the area of the right tail of the probability density function for the F-d
FIND           Return the starting position of a given text.
FINDB          Returns the starting position of a given text, using byte positions.
FINV           returns the inverse of FDIST(x;r1;r2;TRUE()).
LEGACY.FINV    returns the inverse of LEGACY.FDIST(x;r1;r2).
FISHER         returns the Fisher transformation.
FISHERINV      returns the inverse Fisher transformation.
FIXED          Round the number to a specified number of decimals and format the result a
FLOOR          Round a number N down to the nearest multiple of the second parameter, s
FORECAST       Extrapolates future values based on existing x and y values.
FORMULA        Returns formula at given reference as text
FREQUENCY      Categorizes values into intervals and counts the number of values in each int
FTEST          Returns the result of an F test (the probability that two datasets have come f

Compute the future value (FV) of an
FV             investment.

Returns the accumulated value given starting
FVSCHEDULE     capital and a series of interest rates.
GAMMA          Return gamma function value.
GAMMADIST      returns the value of the probability density function or the cumulative distrib
GAMMAINV       returns the inverse of GAMMADIST(x;a; ;TRUE()).
GAMMALN        Returns the natural logarithm of the GAMMA function.
GAUSS          Returns 0.5 less than the standard normal cumulative distribution
GCD            Returns the greatest common divisor (GCD)
GEOMEAN        returns the geometric mean of a sequence
GESTEP         Returns 1 if a number is greater than or equal to another number, else return
GETPIVOTDATA   Return a value from a data pilot table.
GROWTH         Calculates a sequence of values based on a least squares exponential fit to kn
HARMEAN        returns the harmonic mean of a sequence
HEX2BIN        Converts a hexadecimal number (40th bit is sign) to base 2 (whose 10th bit is s
HEX2DEC        Converts a hexadecimal number (40th bit is sign) to decimal
th                              th
HEX2OCT        Converts a hexadecimal number (40 bit is sign) to base 8 (whose 30 bit is s
HLOOKUP        Look for a matching value in the first row of the given table, and return the v

HOUR           Extracts the hour (0 through 23) from a time.

Returns a Text or Number result and adds a
HYPGEOMDIST    The hypergeometric distribution returns the number of successes in a seque
IF             Return one of two values, depending on a condition
IFERROR        Return X unless it is an Error, in which case return an alternative value
IFNA           Return X unless it is an NA, in which case return an alternative value
Returns the absolute value of a complex
IMABS          number
IMAGINARY      Returns the imaginary coefficient of a complex number
IMARGUMENT     Returns the complex argument of a complex number
IMCONJUGATE    Returns the complex conjugate of a complex number
IMCOS          Returns the cosine of a complex number
IMCOT          Returns the cotangent of a complex number
IMCSC          Returns the cosecant of a complex number
IMCSCH        Returns the hyperbolic cosecant of a complex number
IMDIV         Divides the second number into the first.
IMEXP         Returns the exponent of e and a complex number.
IMLN          Returns the natural logarithm of a complex number.
IMLOG10       Returns the common logarithm of a complex number.
IMLOG2        Returns the binary logarithm of a complex number.
IMPOWER       Returns the power of N and a complex number.
IMPRODUCT     Returns the product of complex numbers.
IMREAL        Returns the real coefficient of a complex number
IMSEC         Returns the secant of a complex number
IMSECH        Returns the hyperbolic secant of a complex number
IMSIN         Returns the sine of a complex number
IMSQRT        Returns the square root of a complex number
IMSUB         Subtracts the second complex number from the first.
IMSUM         Sums (add) a set of complex numbers, including all numbers in ranges
IMTAN         Returns the tangent of a complex number
INDEX         Select a value using a row and column index value (and optionally an area ind
INDIRECT      Return a reference given a string representation of a reference

INFO          Returns information about the environment
INT           Rounds a number down to the nearest integer.
INTERCEPT     Calculates the point at which a line will intersect the y-values by using known

Computes the interest rate of a fully vested
INTRATE       security.

Returns the amount of an annuity payment
IPMT          going towards interest.
Compute the internal rate of return for a
IRR           series of cash flows.
ISBLANK       Return TRUE if the referenced cell is blank, else return FALSE
ISERR         Return True if the parameter has type Error and is not NA, else return False.
ISERROR       Return TRUE if the parameter has type Error, else return FALSE
ISEVEN        Return TRUE if the value is even, else return FALSE
ISFORMULA     Return TRUE if the reference refers to a formula, else return FALSE
ISLOGICAL     Return TRUE if the parameter has type Logical, else return FALSE
ISNA          Return True if the parameter is of type NA, else return False.
ISNONTEXT     Return TRUE if the parameter does not have type Text, else return FALSE
ISNUMBER      Return TRUE if the parameter has type Number, else return FALSE
ISO.CEILING
ISODD         Return TRUE if the value is even, else return FALSE
ISOWEEKNUM    Determines the ISO week number of the year for a given date.
Compute the interest payment of an
ISPMT         amortized investment for a given period.
ISREF         Return True if the parameter is of type reference, else return False.
ISTEXT        Return TRUE if the parameter has type Text, else return FALSE
JIS           Converts half-width to full-width ASCII and katakana characters.
KURT                  Return the kurtosis (“peakedness”) of a data set.
LARGE                 Finds the nth largest value in a list.
LCM                   Returns the least common multiplier
LEFT                  Return a selected number of text characters from the left.

Returns a selected number of text characters
LEFTB                 from the left, using a byte position.
LEN                   Return the length, in characters, of given text
LENB                  Returns the length of given text in units compatible with byte positions
LINEST                Returns the parameters of a linear trend best fitting the given data. This func
LN                    Return the natural logarithm of a number.
LOG                   Return the logarithm of a number in a specified base.
LOG10                 Return the base 10 logarithm of a number.
LOGEST                Returns the array of values for an exponential curve that best fits your data..
LOGINV                returns the inverse of LOGNORMDIST(x;Mean;StandardDeviation,TRUE()).
LOGNORMDIST           returns the value of the probability density function or the cumulative distrib
LOOKUP                Look for criterion in an already-sorted array, and return a corresponding resu
LOWER                 Return input string, but with all uppercase letters converted to lowercase let
MATCH                 Finds a Search item in a sequence, and returns its position (starting from 1).
MAX                   Return the maximum from a set of numbers.
MAXA                  Return the maximum from a set of numbers; logicals are always considered n
MDETERM               Calculates the determinant of a matrix.

Returns the modified Macaulay duration of a
MDURATION             fixed interest security in years
MEDIAN                Returns the median (middle) value in the list.
MID                   Returns extracted text, given an original text, starting position, and length.
MIDB                  Returns extracted text, given an original text, starting position using a byte p
MIN                   Return the minimum from a set of numbers.
MINA                  Return the minimum from a set of numbers; logicals are always considered n

MINUTE                Extracts the minute (0 through 59) from a time.
MINVERSE              Returns the inverse of the matrix.

Returns the modified internal rate of return
MIRR                  (IRR) of a series of periodic investments
MMULT                 Multiplies the matrices A and B .
MOD                   Return the remainder when one number is divided by another number.
MODE                  Returns the most common value in a data set.
MONTH                 Extracts the month from a date.
MROUND                Rounds the number to given multiple.
MUNIT                 Creates a unit matrix of a specified dimension N .
MULTINOMIAL           Returns the multinomial for the given values.
MULTIPLE.OPERATIONS   Executes a formula expression while substituting a row reference and a colum
N                     Return the number of a value.
NA                 Return the constant error value #N/A.
NEGBINOMDIST       Returns the negative binomial distribution.
NETWORKDAYS        Returns the whole number of work days between two dates.

NETWORKDAYS.INTL

NOMINAL            Compute the annual nominal interest rate.
NORMDIST           returns the value of the probability density function or the cumulative distrib
NORMINV            returns the inverse of NORMDIST(x;Mean;StandardDeviation,TRUE()).
LEGACY.NORMSDIST   returns the value of the cumulative distribution function for the standard no
NORMSDIST
LEGACY.NORMSINV    returns the inverse of LEGACY.NORMSDIST(x).
NORMSINV
NOT                Compute logical NOT
NOW                Returns the serial number of the current date and time.

Compute the number of payment periods for
NPER               an investment.
Compute the net present value (NPV) for a
NPV                series of periodic cash flows.
NUMBERVALUE        Convert text to number, in a locale-independent way
th                                th
OCT2BIN            Converts an octal number (30 bit is sign) to base 2 (whose 10 bit is sign)
OCT2DEC            OCT2DEC( TextOrNumber X )
OCT2HEX            Converts an octal number (30th bit is sign) to hexadecimal (whose 40th bit is s
ODD                Rounds a number up to the nearest odd integer, where "up" means "away fr

Compute the value of a security per 100
currency units of face value. The security has
ODDFPRICE          an irregular first interest date.

Compute the yield of a security per 100
currency units of face value. The security has
ODDFYIELD          an irregular first interest date.

Compute the value of a security per 100
currency units of face value. The security has
ODDLPRICE          an irregular last interest date.
Compute the yield of a security which has an
ODDLYIELD      irregular last interest date.
OFFSET         Modifies a reference's position and dimension.
OR             Compute logical OR of all parameters.
PEARSON        PEARSON returns the Pearson correlation coefficient of two data sets
PERCENTILE     Calculates the x-th sample percentile among the values in range.
PERCENTRANK    Returns the percentage rank of a value in a sample.
PERMUT         returns the number of permutations of k objects taken from n objects.
PERMUTATIONA   Returns the number of permutations for a given number of objects (repetitio
PHI            Returns the values of the distribution function for a standard normal distribu
PHONETIC
PI             Return the approximate value of Pi.

Returns the number of periods required by an
PDURATION      investment to realize a specified value.

Compute the payment made each period for
PMT            an investment.
POISSON        returns the probability or the cumulative distribution function for the Poisso
POWER          Return the value of one number raised to the power of another number.

Calculate the payment for a given period on
the principal for an investment at a given
PPMT           interest rate and a constant payments.

Calculates a quoted price for an interest
paying security, per 100 currency units of face
PRICE          value.

Calculate the price of a security with a
PRICEDISC      discount per 100 currency units of face value.

Calculate the price per 100 currency units of
face value of the security that pays interest on
PRICEMAT       the maturity date.
PROB           Returns the probability that values in a range are between two limits.
PRODUCT        Multiply the set of numbers, including all numbers inside ranges
PROPER         Return the input string with the first letter of each word converted to an upp

Compute the present value (PV) of an
PV             investment.
QUARTILE      Returns a quartile of a set of data points.
QUOTIENT      Return the integer portion of a division.
RAND          Return a random number between 0 (inclusive) and 1 (exclusive).
RANDBETWEEN   Return a random integer number between A and B.
RANK          R eturns the rank of a number in a list of numbers.

Compute the interest rate per period of an
RATE          investment.

Calculate the amount received at maturity for
a fixed interest security per 100 currency units
REPLACE       Returns text where an old text is substituted with a new text.

Returns text where an old text is replaced with
REPLACEB      a new text, using byte positions.
REPT          Return text repeated Count times.
RIGHT         Return a selected number of text characters from the right.
RIGHTB        Returns a selected number of text characters from the right, using byte posit
ROMAN         Convert to Roman numerals
ROUND         Rounds the value X to the nearest multiple of the power of 10 specified by D
ROUNDDOWN     Rounds the value X down to the nearest multiple of the power of 10 specifie
ROUNDUP       Rounds the value X up to the nearest multiple of the power of 10 specified b
ROW           Returns the row number(s) of a reference
ROWS          Returns the number of rows in a given range
Returns the interest rate resulting from the
RRI           profit (return) of an investment
RSQ           Returns the square of the Pearson product moment correlation coefficient th
RTD
SEARCH        Return the starting position of a given text.
Returns the starting position of a given text,
SEARCHB       using byte positions.
SEC           Return the secant of an angle specified in radians.
SECH          Return the hyperbolic secant of the given angle specified in radians
Extracts the second (the integer 0 through 59)
from a time. This function presumes that leap
SECOND        seconds never exist.

SERIESSUM     Returns the sum of a power series.
SHEET         Returns the sheet number of the reference or the string representing a shee
SHEETS        Returns the number of sheets in a reference or current document
SIGN          Return the sign of a number
SIN           Return the sine of an angle specified in radians
SINH          Return the hyperbolic sine of the given hyperbolic angle
SKEW          Estimates the skewness of a distribution using a sample set of numbers.
SKEWP         Calculates the skewness of a distribution using the population of a random v
Compute the amount of depreciation at a
given period of time using the straight-line
SLN           depreciation method.
SLOPE         Calculates the slope of the linear regression line.
SMALL         Finds the nth smallest value in a list.
SQRT          Return the square root of a number
SQRTPI        Return the square root of a number multiplied by pi.
STANDARDIZE   Calculates a normalized value of a random variable.
STDEV         Compute the sample standard deviation of a set of numbers.
STDEVA        Calculates the standard deviation using a sample set of numbers.
STDEVP        Compute the standard deviation of the set for a set of numbers.
STDEVPA       Calculates the standard deviation using the population of a random variable.
STEYX         Calculates the standard error of the predicted y value for each x in the regres
SUBSTITUTE    Returns text where an old text is substituted with a new text.
SUBTOTAL      Evaluates a function on a range.
SUM           Sum (add) the set of numbers, including all numbers in ranges
SUMIF         Sum the values of cells in a range that meet a criteria.
SUMIFS        Sum the values of cells in a range that meet multiple criteria in multiple rang
Returns the sum of the products of the matrix
SUMPRODUCT    elements.
SUMSQ         Sum (add) the set of squares of numbers, including all numbers in ranges
SUMX2MY2      Returns the sum of the difference between the squares of the matrices A an
SUMX2PY2      Returns the total sum of the squares of the matrices A and B .
SUMXMY2       Returns the sum of the squares of the differences between matrix A and B .
Compute the amount of depreciation at a
given period of time using the sum-of-years'
SYD           digits method.
T             Return the text (if text), else return 0-length Text value
TAN           Return the tangent of an angle specified in radians
TANH          Return the hyperbolic tangent of the given hyperbolic angle
Compute the bond-equivalent yield for a
TBILLEQ       treasury bill.
Compute the price per 100 face value for a
TBILLPRICE    treasury bill.

TBILLYIELD    Compute the yield for a treasury bill.
TDIST         Returns the t-distribution.
TEXT          Return the value converted to a text.
Constructs a time value from hours, minutes,
TIME          and seconds.
TIMEVALUE     Returns a time serial number from given text.
TINV          Calculates the inverse of the two-tailed t-distribution.
TODAY         Returns the serial number of today.
TRANSPOSE      Returns the transpose of a matrix.
TREND          Calculates a sequence of values based on a linear regression of known value
TRIM           Remove leading and trailing spaces, and replace all internal multiple spaces w
TRIMMEAN       Returns the mean of a data set, ignoring a proportion of high and low values
TRUE           Returns constant TRUE
TRUNC          Truncate a number to a specified number of digits.

TTEST          Calculates the probability of a t-test.
TYPE           Returns a number indicating the type of the provided value.
UNICHAR        Return character represented by the given numeric value according to the U
TM
UNICODE        Return the Unicode Standard / ISO 10646 code point corresponding to the
UPPER          Return input string, but with all lowercase letters converted to uppercase let
USDOLLAR
VALUE          Convert text to number
VAR            Compute the sample variance of a set of numbers.
VARA           Estimates the variance using a sample set of numbers.
VARP           Compute the variance of the set for a set of numbers.
VARPA          Calculates the variance using the population of the distribution.
Calculates the depreciation allowance of an
asset with an initial value, an expected useful
life, and a final value of salvage for a period
specified, using the variable-rate declining
VDB            balance method..
VLOOKUP        Look for a matching value in the first column of the given table, and return th

Extracts the day of the week from a date; if
WEEKDAY        text, uses current locale to convert to a date.
WEEKNUM        Determines the conventional non-ISO week number of the year for a given d
WEIBULL        Calculates the Weibull distribution.

WORKDAY        Returns the date serial number which is a specified number of days before o

WORKDAY.INTL

Compute the internal rate of return for a non-
XIRR           periodic series of cash flows.
Compute the net present value of a series of
XNPV           cash flows.
XOR            Compute a logical XOR of all parameters.
YEAR           Extracts the year from a date given in the current locale of the application.
YEARFRAC    Extracts the number of years (including fractional part) between two dates

Calculate the yield of the security that pays
YIELD       periodic interest.

Calculate the yield of a discounted security per
YIELDDISC   100 currency units of face value.

Calculate the yield of the security that pays
YIELDMAT    interest on the maturity date.
ZTEST       Calculates the probability of a z-test with normal distribution.
ISO/IEC 29500-Description                          OpenFormula-Syntax
Computes the absolute value of x.                  ABS( Number N )
ACCRINT( DateParam issue ; DateParam first ;
DateParam settlement ; Number coupon ;
Computes the accrued interest for a security       Number par ; Integer frequency [ ; Basis basis
that pays periodic interest.                       =0])
ACCRINT( DateParam issue ; DateParam
Computes the accrued interest for a security       settlement ; Number coupon ; Number par [ ;
that pays interest at maturity.                    Basis basis = 0 ] )
Computes the arc cosine of x.                      ACOS( Number N )

Computes the inverse hyperbolic cosine of x.      ACOSH( Number N )
er. The angle is returned in radians.                          ACOT( Number N )
ACOTH( Number N )

Creates a cell address, given the specified row
and column numbers.                                ADDRESS( Integer Row ; Integer Column [ ; Integer Abs = 4 [ ; Logical A1 = T
Computes the depreciation for each
accounting period. (This function is provided
for the French accounting system. If an asset is
purchased in the middle of the accounting
period, the prorated depreciation is taken into   AMORDEGRC( Number cost ; DateParam
account. The function is similar to AMORLINC      purchaseDate ; DateParam firstPeriodEndDate
(§18.17.7.7), except that a depreciation          ; Number salvage ; Integer period ; Number
coefficient is applied in the calculation         rate [ ; Basis basis = 0 ] )
AMORLINC( Number cost ; DateParam
purchaseDate ; DateParam firstPeriodEndDate
Computes the depreciation for each accounting period. (This function is provided for the French accounting system. If an asse
+
Tests if all arguments in argument-list are TRUE. AND( { Logical|NumberSequenceList L } ) to returning a value.
The function evaluates all arguments prior
ARABIC( Text X )

AREAS( ReferenceList R )
Finds the number of areas (§18.17.2.3) designated by reference.
converts T full-width (double-byte) characters to half-width (single-byte) ch
For double-byte character set (DBCS) languages, ASC( Textall )
Computes the arc sine of x.                     ASIN( Number N )
Computes the inverse hyperbolic cosine of x.    ASINH( Number N )
Computes the arc tangent of x.                  ATAN( Number N )
ATAN2(
Computes the arc tangent of the coordinates x and y. Number x ; Number y )
Computes the inverse hyperbolic tangent of x. ATANH( Number N )

+
AVEDEV( { data points from their } )
Computes the average of the absolute deviations of a set ofNumberSequenceList N mean. AVEDEV is a measure of the variabi
+
AVERAGE( arguments.
Computes the arithmetic mean of the numeric values of its { NumberSequence N } )
+
AVERAGEA( {
Computes the arithmetic mean of the values of its arguments.Any N } )

AVERAGEIF( Reference R ; Any C [ ; Reference in )
Applies selection criteria on the values in one range of cells and averages the values of the cells A ]a corresponding range.

AVERAGEIFS( Reference A ; Reference R1 ; Any C1 [ ; Reference R2 ; Any C2
The average of the values of all cells that meet multiple criteria.
ult using binomial distribution.                            B( Integer N ; Number P ; Integer S [ ; Integer S2 ] )
Produces a string containing number formatted according to the Thai convention.
sentation with the given base.                              BASE( Number X ; Number Radix [ ; Number MinimumLength ] )

BESSELI( the Bessel ; Number N )
The modified Bessel function In(x), which is equivalent to Number X function Jn(x) evaluated for purely imaginary arguments.

The Bessel function Jn(x).                       BESSELJ( Number X ; Number N )

BESSELK( using the Bessel function
The modified Bessel function Kn(x), which is equivalent to Number X ; Number N ) Jn(x) and Yn(x).

Weber's Bessel function Yn(x).                 BESSELY( Number X ; Number N )
Computes the cumulative beta probability density function.Number x ; Number a ; Number b [ ; Number a = 0 [ ; Number b

BETAINV( Number p ; Number a ; Number b Given a value 0 ; Number b =
Computes the inverse of the cumulative distribution function for a specified beta distribution. [ ; Number a =for[probability, B
Makes the decimal equivalent of number.        BIN2DEC( TextOrNumber X )
number, TextOrNumber X [ ; Number Digits ]
Makes the uppercase hexadecimal equivalent of BIN2HEX(with the result having num-hex-digits )digits.
BIN2OCT( TextOrNumber X ; Number Digits ] )
Makes the octal equivalent of number, with the result having num-oct-digits [digits.
BINOMDIST( Integer S ; Integer N ; Number P ; Logical Cumulative )
Computes the individual term binomial distribution probability.
BITAND( Number X ; Number Y )
BITLSHIFT( Number x ; Number n )
BITOR( Number X ; Number Y )
BITRSHIFT( Number x ; Number n )
BITXOR( Number X ; Number Y )
CEILING( Number N [ ; [ Number significance. Regardless mode sign
Computes a value that is x rounded-up, away from zero, to the nearest multiple ofsignificance ] [ ; Number of the ] ] ) of x, a v
CELL( Text Info_Type [ Reference R ] indicated by reference. category indic
Retrieves information about the formatting, location, or contents of the; upper-left cell )
Determines the character that is represented by CHAR( Number N ) On the Macintosh platform, the Macintosh character set
the value number.
2
he c -distribution.                                           LEGACY.CHIDIST( Number x ; Number DegreesOfFreedom )
Computes the one-tailed probability of the chi-squared distribution.
ST(x; DegreesOfFreedom).                                       LEGACY.CHIINV( Number p ; Number DegreesOfFreedom )
Computes the inverse of the one-tailed probability of the chi-squared distribution. Given a value for probability, CHIINV seeks
density function or the cumulative distribution function for the c2-distribution.
CHISQDIST( Number x ; Number DegreesOfFreedom [ ; Logical Cumulative =
DegreesOfFreedom; TRUE()).                                     CHISQINV( Number p ; Number DegreesOfFreedom )
LEGACY.CHITEST( Array A ; Array E )
Computes the test for independence. CHITEST returns the value from the chi-squared distribution for the statistic and the app
+
CHOOSE( position to index.
Selects the argument in argument-list that corresponds byInteger Index ; { Any Value } )
CLEAN( Text T )
Makes a string that is a copy of string with all so-called "non-printable" characters—those with internal values in the range U+
CODE( Text
Determines the numeric code of the first character in string. T )
COLUMN( [ Reference R ] )
Finds the number of the column(s) corresponding to reference.
Finds the number of columns corresponding to array. COLUMNS( Reference|Array R )

Computes the possible number of groups of size COMBIN( Number N ; Number R ) from number objects. [Note: A combina
number-chosen that can be formed
s with repetitions.                                         COMBINA( Integer N ; Integer M )

COMPLEX( the arguments.
Makes a complex number in x + yi or x + yj text format fromNumber Real ; Number Imaginary [ ; Text Suffix ] )
+
CONCATENATE( { Text to )
Makes a string that is the concatenation of all the strings correspondingT } the arguments in argument-list, taken left-to-right

CONFIDENCE( Number alpha ; Number stddev ; CONFIDENCE
Computes a value that can be used to construct a confidence interval for a population mean. TheNumber size ) function assum
CONVERT( Number N ; Text From ; Text Into )
Converts a number from one measurement system to another.
CORREL( ForceArray NumberSequence N1 ; ForceArray NumberSequence N
Computes the correlation coefficient of the two cell ranges designated by array-1 and array-2.
Computes the cosine of x.                       COS( Number N )
Computes the hyperbolic cosine of x.            COSH( Number N )
ecified in radians                                            COT( Number N )
he given hyperbolic angle                                    COTH( Number N )
+
COUNT( { NumberSequenceList number of cells referred to by arguments in
Counts the number of arguments in argument-list that contain numbers, and theN } )
+
COUNTA( { Any A } )
Counts the number of arguments that are not cell references, and the number of cells, referred to by arguments, which are n
COUNTBLANK( ReferenceList R )
Counts the number of cells in a specified range of cells, which are empty. A cell containing a formula that returns an empty st
COUNTIF( ReferenceList R Any C )
Counts the number of cells in a specified range of cells, whose values meet ;the specified criteria.

COUNTIFS( Reference
Counts the number of cells within a range that meet multiple criteria. R1 ; Any C1 [ ; Reference R2 ; Any C2 ]... )

COUPDAYBS( DateParam settlement ;
DateParam maturity ; Integer frequency [ ;
Basis basis = 0 ] )
Computes the depreciation for each accounting period. (This function is provided for the French accounting system. If an asse
Computes the number of days from the          COUPDAYS( DateParam settlement ;
beginning of the coupon period to the         DateParam maturity ; Integer frequency [ ;
settlement date.                              Basis basis = 0 ] )
COUPDAYNC( DateParam settlement ;
DateParam maturity ; Integer frequency [ ;
Basis basis = 0 ]
Computes the number of days in the coupon period that contains) the settlement date.
COUPNCD( DateParam settlement ;
DateParam maturity ; Integer frequency [ ;
Basis basis = 0 ] )
Computes the number of days from the settlement date to the next coupon date.
COUPNUM( DateParam settlement ;
DateParam maturity ; Integer frequency [ ;
Basis basis
Computes the next coupon date after the settlement date. = 0 ] )
COUPPCD( DateParam settlement ;
DateParam maturity ; Integer frequency [ ;
Basis basis = 0 ] )
Computes the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole
products of deviations for each data point ForceArray NumberSequence n2
Computes covariance; that is, the average of theCOVAR( ForceArray NumberSequence n1 ; pair in the two cell ranges designa
CRITBINOM( Number Trials ; greater SP ; or equal to a criterion value.
Computes the smallest value for which the cumulative binomial distribution isNumber than Number Alpha )
cified in radians.                                            CSC( Number N )
e given angle specified in radians                           CSCH( Number N )
Fetches from the OLAP cube on the OLAP server designated by connection, a Key Performance Indicator (KPI) name, property
Fetches from the OLAP cube on the OLAP server designated by connection, the member or tuple defined by member-express
Fetches a property of a member in the OLAP cube on an OLAP server. [Note: Use this function o ensure that a member name
Fetches the nth, or ranked, member in a set.
Fetches from the OLAP cube on the OLAP server designated by connection the set of members or tuples that is defined by se
Computes the number of items in a set.
Fetches from the OLAP cube on the OLAP server designated by connection, the aggregated value defined by a series of memb
CUMIPMT( Number rate ; Number periods ;
Number value ; Integer start ; Integer end ;
Integer type )
Computes the previous coupon date before the settlement date.
CUMPRINC( Number rate ; Number periods ;
Number value ; Integer start ; Integer end ;
Computes the cumulative interest paid on a loanInteger type )
between start-period and end-period.
Computes the serial value for the given date.   DATE( Integer Year ; Integer Month ; Integer Day )
between DateParam
Calculates the number of days, months, or years DATEDIF( two dates. StartDate ; DateParam EndDate ; Text Format )
DATEVALUE( Text D )
Computes the serial value of the date represented by the string date-time-string, taking into account the current date base va

DAVERAGE( Database D ; Field F ; Criteria C )
Averages the values in a column of a list or database that match the specified criteria.
DAY( DateParam [ISO
Computes the numeric day of the month in the Gregorian calendarDate )8601 §3.2.1] for the date and/or time having the give
DAYS( DateParam EndDate ; DateParam StartDate )
DAYS360( DateParam StartDate ; (twelve 30-day months).
Computes the signed number of days between two dates based on a 360-day year DateParam EndDate [ ; Integer Method =

DB( Number cost ; Number salvage ; Integer
lifeTime ; Number period [ ; Number month =
Computes the cumulative principal paid on a loan between start-period and end-period.
12 ] )
or database that match the F ; Criteria C )
Counts the number of values in a column of a listDCOUNT( Database D ; Field specified criteria. (See the DAVERAGE function §
DCOUNTA( database D ; Field F Criteria C )
Counts the number of non-blank cells in a column of a list orDatabase that match;the specified criteria. (See the DAVERAGE f
DDB( Number cost ; Number salvage ; Integer
lifeTime ; Number period [ ; Number
declinationFactor the )
Computes the depreciation of an asset for a specified period using = 2 ]fixed-declining balance method.
DDE( Text server ; Text topic ; Text item [ ; Integer Mode = 0 ] )
DEC2BIN( TextOrNumber X [ Number Digits ] )
Makes the binary equivalent of number, with the result having num-bin-digits;digits.
DEC2HEX( TextOrNumber X [ ; Number Digits ] )
Makes the hexadecimal equivalent of number, with the result having num-hex-digits digits.
DEC2OCT( TextOrNumber X [ ; Number Digits ] )
Makes the octal equivalent of number, with the result having num-oct-digits digits.
r in a given base into a base 10 number.                     DECIMAL( Text X ; Integer Radix )
Converts angle in radians into degrees.        DEGREES( Number N )
Compares two numbers for equality.             DELTA( Number X [ ; Number Y = 0 ] )

+
DEVSQ( { from their sample mean.
Computes the sum of squares of deviations of data points NumberSequence n } )
DGET( Database D ; Field F ; Criteria C )
Extracts a single value from a column of a list that matches the specified criteria. (See the DAVERAGE function §18.17.7.77.)

DISC( DateParam settlement ; DateParam
maturity ; Number price ; Number
redemption using the double-declining balance or some other specified meth
Computes the depreciation of an asset for a specified period [ ; Basis basis = 0 ] )
DMAX( Database D ; Field F ; Criteria C )
Computes the maximum value of the cells in a column of a list or database that match the specified criteria. (See the DAVERA
DMIN( Database D ; Field F ; Criteria C )
Computes the minimum value of the cells in a column of a list or database that match the specified criteria. (See the DAVERA
num-decimal decimal Integer D )
Produces a string containing number rounded toDOLLAR( Number N [ ; places. The] formatting applied to the string for the tho

DOLLARDE( Number fractional ; Integer
Computes the discount rate for a security.          denominator )
DOLLARFR( Number decimal ; Integer
denominator )
Converts a fractional dollar price into a dollar price expressed as a decimal number. [Note: Fractional dollar numbers are som

DPRODUCT( Database D ; Field that match )
Computes the product of the values of the cells in a column of a list or databaseF ; Criteria Cthe specified criteria. (See the DA
based on a sample by Field F ; numbers in
Estimates the standard deviation of a populationDSTDEV( Database D ; using theCriteria C ) a column of a list or database th
DSTDEVP( the entire population Criteria the
Computes the standard deviation of a population based on Database D ; Field F ; by using C ) numbers in a column of a list o
list or Database D ; Field F ; Criteria C )
Computes the sum of the values in a column of aDSUM(database that match the specified criteria. (See the DAVERAGE functio
DURATION( Date Settlement ; Date Maturity ;
Number Coupon ; Number Yield ; Number
Frequency of 100. Basis = 0 ] defined as the weighted average term to matu
Computes the Macaulay duration for an assumed par value [ ; Basis Duration is )
Estimates the variance of a population based on DVAR( Database D ; Field F ; Criteria C ) of a list or database that match t
a sample by using the numbers in a column
Calculates the variance of a population based onDVARP( Database D ; Field F ; Criteria C ) in a column of a list or database
the entire population by using the numbers
Computes a value that is x rounded-up, away from zero, to the nearest multiple of significance. Regardless of the sign of x, a v

EDATE( DateParam StartDate ; Number MonthAdd )
Computes the serial value of the date that is month-offset months from the date specified by the date date-string, taking into

EFFECT( Number rate interest payments )
Computes the effective annual interest rate, given the nominal annual ; Integerrate and the number of compounding periods
EOMONTH( DateParam StartDate ; Integer MonthAdd )
Computes the serial value of the last day of the month for the date that is month-offset months from the date specified by th

ERF( Number and Number z1 ]
Computes the error function integrated between lower-boundz0 [ ;upper-bound.)
ERFC( Number z
Computes the complementary error function integrated between)lower-bound and ∞.
ERROR.TYPE(
Determines the kind of the error value designated by value. Error E )
ther Euro currency.                                         EUROCONVERT( Number N ; Text From ; Text To [ ; Logical FullPrecision = F
EVEN( from zero.
Computes x rounded to the nearest even integer, awayNumber N )Regardless of the sign of x, a value is rounded up when adj
EXACT( Text t1 ; Text t2 )
Performs a case-sensitive, character-by-character, lexical comparison of string-1 and string-2.
Returns e raised by the
Computes ex, where the constant e is the base of the natural logarithm. given number.
Computes the exponential distribution.          EXPONDIST( Number x ; Number l [; Logical Cumulative = TRUE() ] )
Computes the factorial of x.                    FACT( Integer F )
Computes the double factorial of n.             FACTDOUBLE( Integer F )
FALSE()
Computes the value FALSE. (A call to function FALSE is equivalent to using the logical-constant FALSE.)
Computes the F probability distribution.        FDIST( Number x ; Number r1 ; Number r2 [ ; Logical Cumulative = TRUE() ] )
he probability density function for the F-distribution.        LEGACY.FDIST( Number x ; Number r1 ; Number r2 )
FIND( Text Search ; Text T [ ; Integer Start = ] string-2, starting at characte
Performs a case-sensitive search using a lexical comparison for the first occurrence of string-11in )
FINDB( Text Search ; Text T [ ; BytePosition Start ] )
Performs a case-sensitive search using a lexical comparison for the first occurrence of string-1 in string-2, starting at byte pos
FINV( Given a p ; Number r1 ; Number r )
Computes the inverse of the F probability distribution. Number value for probability, FINV 2seeks that value x such that FDIST(x
LEGACY.FINV( Number p ; Number r1 ; Number r2 )
Computes the Fisher transformation at x.           FISHER( Number r )
Computes the inverse of the Fisher transformation. FISHERINV( Number r )
num-decimal decimal places, = 2 [ ; Logical rounding algorithm as ROUND
Produces a string containing number rounded toFIXED( Number N [ ; Integer Dusing the same OmitSeparators = FALSE() ] ] )
FLOOR( Number N [ ; [ Number significance ] the sign of mode ] ]
Computes x rounded down, toward zero, to the nearest multiple of significance. Regardless of [ ; Number x, a value)is rounde
FORECAST( Number Value ; ForceArray NumberSequence Data_Y ; ForceArr
Calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value. The known
FORMULA( Reference X )
of values. A NumberSequenceList data an array formula.
Calculates how often values occur within a rangeFREQUENCY(call to FREQUENCY shall be ; NumberSequenceList bins )
Computes the result of an F-test.                  FTEST( ForceArray NumberSequence Data_1 ; ForceArray NumberSequence
FV( Number Rate ; Number Nper ; Number
Payment [ ; Number Pv = 0 [ ; Number
PayType = 0 ] ] constant payments and a constant interest rate.
Computes the future value of an investment based on periodic, )

FVSCHEDULE( Number Principal ;
NumberSequence Schedule )
Computes the future value of an initial principal after applying a series of compound interest rates. [Note: This function can b
GAMMA( Number N )
Computes the gamma distribution.                  GAMMADIST( Number x ; Number a ; Number [ ; Logical Cumulative = TR
GAMMAINV( Number p ; Number a ; Number that value x such that GAM
Computes the inverse of the gamma distribution. Given a value for probability, GAMMAINV seeks )
GAMMALN( Number X )
Computes the natural logarithm of the gamma function.
ormal cumulative distribution                                GAUSS( Number x )
+
GCD( { NumberSequenceList X } by
Computes the greatest common divisor of the one or more numbers, designated ) arguments in argument-list.
GEOMEAN( { NumberSequenceList N }+ )
Computes the geometric mean of an array or range of positive data.
GESTEP( Number X
Tests if the value of number is greater than or equal to that of step. [ ; Number Step = 0 ] )
GETPIVOTDATA( Text DataField ; calculations are included in GETPIVOTDAT
Retrieves data stored in a PivotTable report. Calculated fields or items and customReference Table { ; Text Field ; Scalar Mem
GROWTH( NumberSequence knownY [ [ NumberSequence existing x-values
Computes predicted exponential growth by using existing data. GROWTH can also fit an ;exponential curve to knownX ] [ ; [ Nu
+
Computes the harmonic mean of a data set.          HARMEAN( { NumberSequenceList N } )
HEX2BIN( TextOrNumber X [ Number Digits ] )
Makes the binary equivalent of number, with the result having num-bin-digits;digits.
Makes the decimal equivalent of number.        HEX2DEC( TextOrNumber X )
HEX2OCT( TextOrNumber X [ ; Number Digits ] )
Makes the octal equivalent of number, with the result having num-oct-digits digits.
HLOOKUP( Any or an array, noting the column in which the matching ; Logic
Performs a horizontal search for a value in the top row of a tableLookup ; Reference|Array DataSource ; Integer Row [ value

HOUR( given time-value.
Computes the hour for the date and/or time having the TimeParam T )

HYPERLINK( Text IRI [ Text|Number FunctionResult ] )
Creates a shortcut that opens a document stored on a network server, ;an intranet, or the Internet. When the cell that contain
is, the probability of a given number n Number M ; Number N [ ; sample s
Computes the hypergeometric distribution; that HYPGEOMDIST( Number x ; Number of ;sample successes, given theLogical C
is Logical Condition [ ; [ Any IfTrue ] ; [ Any IfFalse evaluated and returned
Tests logical-value, and if it is TRUE, value-if-trueIF( evaluated and returned; otherwise,[ value-iffalse is ] ] ] )
IFERROR( handling errors. It allows
Provides a simpler and more efficient way of trapping and Any X ; Any Alternative ) the generation of user-defined error text
case return an alternative value                                 IFNA( Any X ; Any Alternative )

Computes the absolute value of complex-number.IMABS( Complex X )
IMAGINARY( Complex X )
Computes the imaginary coefficient of complex-number.
radians, such that for a X )
Computes the argument θ, an angle expressed inIMARGUMENT( Complexcomplex number complexnumber having the form x
IMCONJUGATE( Complex X
Computes the complex conjugate of the complex number complex-number.)
IMCOS( Complex
Computes the cosine of the complex number complex-number. X )
IMCOT(Complex N)
IMCSC(Complex N)
complex number                                             CSCH( Number N )
IMDIV( Complex X ; Complex Y )
Computes the quotient from dividing two complex numbers.
IMEXP( Complex X )
Computes the exponential of the complex number complex-number.
IMLN(
Computes the natural logarithm of complex-number. Complex X )
Computes the base-10 logarithm of complex-number.IMLOG10( Complex X )
Computes the base-2 logarithm of complex-number. IMLOG2( Complex X )
IMPOWER( Complex y.
Computes the complex number complex-number raised to the power X ; Number n )
IMPRODUCT( { ComplexSequence N }+ )
Multiplies the values of its complex number arguments.
Computes the real coefficient of complex-number. IMREAL( Complex N )
IMSEC(Complex N)
omplex number                                               IMSECH( Number N )
IMSIN( Complex N )
Computes the sine of the complex number complex-number.
IMSQRT( Complex N
Computes the square root of the complex number complex-number. )
Computes the difference of two complex numbers.  IMSUB( Complex X ; Complex Y )
Adds the values of its arguments.                IMSUM( { ComplexSequence N }+ )
IMTAN(Complex N)
within ReferenceList |Array DataSource ; [ Integer Row ] function: the array
Locates a value or the reference to a value from INDEX(a table or range. There are two forms of the INDEX [ ; [ Integer Colum
INDIRECT( Text Ref [ ; Logical A1 = underlying
Locates the reference specified by ref-text and evaluates that reference to get to its TRUE() ] ) value. [Note: This function sh

INFO( Text Category )
Retrieves the operating environment value that corresponds to category.
Computes x rounded down to an integer.             INT( Number N )
INTERCEPT( existing x-values and y-values. The intercept point is based o
Computes the point at which a line intersects the y-axis by usingForceArray NumberSequence Data_Y ; ForceArray Nu
INTRATE( Date Settlement ; Date Maturity ;
Number Investment ; Number Redemption [ ;
Basis Basis = 0 ] )
Computes the interest rate for a fully invested security.
IPMT( Number Rate ; Number Period ;
Number Nper ; Number PV [ ; Number FV = 0
[ Number Type = 0 ] ] )
Computes the interest payment for a given period; for an investment based on periodic, constant payments and a constant in
IRR( NumberSequence Values [ ; Number
of cash 0.1 ]
Computes the internal rate of return for a series Guess = flows )represented by the numbers in values. (These cash flows do no
Determines if value refers to an empty cell.       ISBLANK( Scalar X )
ISERR( Scalar
Determines if value is any of the error values other than #N/A. X )
Determines if value is any of the error values. ISERROR( Scalar X )
ISEVEN( Number X )
Determines if value is an even number or refers to a cell containing an even number.
o a formula, else return FALSE                                 ISFORMULA( Reference X )
ISLOGICAL( containing
Determines if value contains a logical value or refers to a cellScalar X ) a logical value.
Determines if value is the error value #N/A.       ISERR( Scalar X )
ISNONTEXT( a cell X )
Determines if value does not contain text or does not refer toScalar containing text. An empty cell is not text.
ISNUMBER( contains
Determines if value contains a number or refers to a cell thatScalar X ) a number.
Computes a value that is x rounded-up, to the nearest multiple of significance. Regardless of the sign of x, a value is rounded
ISODD( Number X )
Determines if value is an odd number or refers to a cell containing an odd number.
the year for a given date.                                     ISOWEEKNUM( DateParam Date [ ; Integer Mode = 2 ] )
ISPMT( Number Rate ; Number Period ;
Number Nper ; Number Pv )
Computes the interest paid during a specific period of an investment.
Determines if value is a cell reference.           ISREF( Any X )
ISTEXT( Scalar X )
Determines if value contains text or refers to a cell containing text.
JIS( Text T )
Creates a string that is the conversion of half-width (single-byte) letters within string to full-width (double-byte) characters.
+
KURT( { NumberSequenceList X }
Computes the kurtosis of a data set. Kurtosis characterizes the relative peakedness) or flatness of a distribution compared wit
Computes the kth largest value in a data set.    LARGE( NumberSequenceList List ; Number|Array N )
+
Computes the least common multiple of the oneLCM( { NumberSequenceList X } )
or more arguments in argument-list.
LEFT( Text (LEFT is intended for use
Extracts the left-most number-chars characters from string. T [ ; Integer Length ] ) with languages that use the single-byte

LEFTB( Text T [ ; ByteLength Length ] )
Extracts the left-most number-bytes-worth of characters from string. (LEFTB is intended for use with languages that use the d
LEN( Text T )
Determines the number of characters in string. (LEN is intended for use with languages that use the single-byte character set
Determines the number of bytes in string. (LENB LENB( Text T ) use with languages that use the double-byte character set (D
is intended for
LINEST( Array knownY [ ; [ Array a straight line that Const TRUE() [ ; Logic
Calculates the statistics for a line by using the "least squares" method to calculate knownX ] [ ; Logicalbest fits=the data, and re
Computes the natural logarithm of x.                 LN( Number X )
Computes the logarithm of x to the base base. LOG( Number N [ ; Number Base = 10 ] )
Computes the base-10 logarithm of x.                 LOG10( Number N )
LOGEST( Array knownY ; [ Array knownX ] [ Logical Const = TRUE() [ ; Log
Calculates an exponential curve that fits the data, and returns an array of[ values that describes; the curve.
LOGINV( Number p [ ; Number Mean = [ ; Number StandardDeviation = 1
Calculates the inverse of the lognormal cumulative distribution function of x, where ln(x)0is normally distributed with parame]
of x, where ln(x) is normally Number m = 0 parameters mean Logical Cum
Calculates the cumulative lognormal distributionLOGNORMDIST( Number x [ ;distributed with [ ; Number s = 1 [ ;and standard
LOOKUP( value from the same Reference|Array Searched The array form lo
The vector form looks in a vector for a value, and returns aAny Find ; ForceArray position in a second vector. [ ; ForceArray Re
LOWER( Text T )
Makes a lowercase version of string by doing a character-by-character conversion of string to lowercase, except as noted belo
MATCH( Scalar Search ; Reference|Array SearchRegion shall not distinguish
Locates the relative position of an array item that matches a specified value in a specified order. MATCH [ ; Integer MatchTyp
Computes the largest of a set of numbers.         MAX( { NumberSequenceList N }+ )
+
Computes the largest of a set of numbers.     MAXA( { Any N } )
of numbers designated Array matrix )
Computes the determinant of the square matrix MDETERM( ForceArray by array. The determinant is calculated with an accur

MDURATION( Date Settlement ; Date
Maturity ; Number Coupon ; Number Yield ;
security Frequency [ ; Basis Basis = 0 )
Computes the modified Macaulay duration for a Number with an assumed par value of]100.
MEDIAN( { NumberSequenceList X}+ )
Computes the median of the numeric values of its arguments. The median of a set of values is the value for which half the nu
MID( at character position ; Integer (MID is
Extracts number-chars characters from string, startingText T ; Integer Start start-pos.Length ) intended for use with language
string, starting at character Start ; ByteLength Length )
Extracts number-bytes-worth of characters fromMIDB( Text T ; BytePosition position start-pos. (MIDB is intended for use wit
Computes the smallest of a set of numbers.      MIN( { NumberSequenceList N }+ )
+
Computes the smallest of a set of numbers.        MINA( { Any N } )

MINUTE( given time-value.
Computes the minute for the date and/or time having the TimeParam T )
MINVERSE( ForceArray Array matrix )
Computes the inverse of the square matrix of numbers designated by array. The inverse matrix is calculated with an accuracy

MIRR( Array Values ; Number Investment ;
Number of periodic cash
Computes the modified internal rate of return for a seriesReinvestRate ) flows. (Both the cost of the investment and the int
MMULT( ForceArray Array A ; ForceArray Array B )
Computes the product of the matrices of numbers designated by array-1 and array-2.
The result has a ; Number b )
Computes the remainder when x is divided by y. MOD( Numberthe same sign as y.
MODE( values of its NumberSequence N of values contains more than one m
Computes the most frequently occurring of the numeric { ForceArray arguments. If the set }+ )
MONTH( DateParam Date )
Computes the numeric month in the Gregorian calendar [ISO 8601 §3.2.1] for the date and/or time having the given date-valu
MROUND( up if the remainder b )
Computes x rounded to multiple, away from zero. It rounds Number a ; Number of dividing x by multiple is greater than or eq
imension N .                                               MUNIT( Integer N )
+
Computes the ratio of the factorial of the sum ofMULTINOMIAL( { NumberSequence A } ) of the factorials.
the values in argument-list to the product
substituting a row reference and a column reference.          MULTIPLE.OPERATIONS( Reference FormulaCell ; Reference RowCell ; Refere
N( Any a )
Converts value to a number or, if value is a reference to X single cell, converts the value of that cell to a number.
Gets the error value #N/A. (The error value #N/ANA() be used instead of a call to this function; the result is the same.)
can
NEGBINOMDIST( Integer probability ; Number p )
Computes the negative binomial distribution. NEGBINOMDIST returns the x ; Integer rthat there are number-failures failures
NETWORKDAYS( and end-date. Weekend days (Saturday, [ DateSequence
Computes the number of whole working days between start-dateDateParam Date1 ; DateParam Date2 [ ;Sunday) and any h

Computes the number of whole working days between start-date and end-date. Weekend days and any holidays specified by
NOMINAL( Number EffectiveRate ; Integer
CompoundingPeriods )
Computes the nominal annual interest rate, given the effective rate and the number of compounding periods per year.
NORMDIST( standard ; Number
Computes the normal distribution for the specified mean andNumber x deviation. Mean ; Number StandardDeviation [ ; Logic
for the specified mean Number Mean ; Number
Computes the inverse of the normal distribution NORMINV( Number p ; and standard deviation. StandardDeviation )
distribution function for the standard normal distribution. LEGACY.NORMSDIST( Number x )
Computes the standard normal distribution for the specified mean and standard deviation.
LEGACY.NORMSINV( Number p )
Computes the inverse of the standard normal distribution. The distribution has a mean of zero and a standard deviation of 1.
Computes the logical negation of logical-value. NOT( Logical L )
NOW()
Computes the serial value of the current date and time, taking into account the current date base value.
NPER( Number Rate ; Number Payment ;
Number Pv [ ; Number Fv [ ; Number PayType
]]
Computes the number of periods for an investment) based on periodic, constant payments and a constant interest rate.
NPV( Number Rate ; { NumberSequenceList
Value }+ )
Calculates the net present value of an investment by using a discount rate and a series of future payments and income.
ndependent way                                                NUMBERVALUE( Text X ; Text DecimalPoint )
OCT2BIN( TextOrNumber X [ Number Digits ] )
Makes the binary equivalent of number, with the result having num-bin-digits ;digits.
Makes the decimal equivalent of number.        Converts an octal number (30th bit is sign) to decimal
OCT2HEX( TextOrNumber X [ ; Number Digits ] )
Makes the hexadecimal equivalent of number, with the result having num-hex-digits digits.
Computes x rounded to the nearest odd integer, ODD( Number N )
away from zero. Regardless of the sign of x, a value is rounded up when adju
ODDFPRICE( DateParam Settlement ;
DateParam Maturity ; DateParam Issue ;
DateParam First ; Number Rate ; Number
Yield ; Number Redemption ; Number
Frequency ; Basis Basis or ] )
Computes the price per \$100 face value of a security having[an odd (short= 0 long) first period.
ODDFYIELD( DateParam Settlement ;
DateParam Maturity ; DateParam Issue ;
DateParam First ; Number Rate ; Number
Price ; Number Redemption ; Number
Computes the yield of a security that has an odd Frequency [ ; Basis Basis = 0 ] )
(short or long) first period.
ODDLPRICE( DateParam Settlement ;
DateParam Maturity ; DateParam Last ;
Number Rate ; Number AnnualYield ; Number
Redemption ; Number Frequency [ ; Basis
Basis = 0 ] )
Computes the price per \$100 face value of a security having an odd (short or long) last coupon period.
ODDLYIELD( DateParam Settlement ;
DateParam Maturity ; DateParam Last ;
Number Rate ; Number Price ; Number
Redemption ; Number Frequency [ ; Basis
(short 0 )
Computes the yield of a security that has an odd Basis = or]long) last period.
OFFSET( Reference reference ; a cell or range of ; Integer columnOffset is
Gets a reference to a range that is a specified number of rows and columns fromInteger rowOffsetcells. The reference that [ ;
+
OR( { Logical|NumberSequenceList L )
Tests if any one or more arguments in argument-list are TRUE. The function evaluates }all arguments prior to returning a value
PEARSON( ForceArray Array independent_Values ; ForceArray Array depen
Computes the Pearson product moment correlation coefficient, a dimensionless index that ranges from -1.0 to 1.0, inclusive,
Computes the kth percentile of a set of values in PERCENTILE( NumberSequenceList Data ; Number x )
a range.
PERCENTRANK( data set.
Computes the rank of a value in a data set as a percentage of theNumberSequenceList Data ; Number X [ ; Integer Significanc
PERMUT( Integer n ; Integer k
Computes the number of permutations for number-chosen objects that can be)selected from number objects. [Note: A perm
s for a given number of objects (repetition allowed).           PERMUTATIONA( Integer Total ; Integer Chosen )
n function for a standard normal distribution.                  PHI( Number N )
Extracts the phonetic (furigana) characters from string. [Note: Furigana are aids used to indicate correct pronunciation of Japa
Computes the value π.                             PI()

PDURATION( Number rate ; Number
currentValue ; Number specifiedValue )
PMT( Number Rate ; Integer Nper ; Number
Pv [ ; Number Fv = 0 [ ; Number PayType = 0 ]
])
Computes the payment for a loan based on constant payments and a constant interest rate.
Computes the Poisson distribution.           POISSON( Integer x ; Number l [ ; Logical Cumulative = TRUE() ] )
Computes x raised to the power y.            POWER( Number a ; Number b )

PPMT( Number Rate ; Integer Period ; Integer
nPer ; Number Present [ ; Number Future = 0 [
; Number Type 0 ] ] )
Computes the payment on the principal for a given period for an=investment based on periodic, constant payments and a con

PRICE( DateParam Settlement ; DateParam
Maturity ; Number Rate ; Number AnnualYield
; Number Redemption ; Number Frequency [ ;
Basis Basis = ] )
Computes the price per \$100 face value of a security that pays0periodic interest.

PRICEDISC( DateParam Settlement ;
DateParam Maturity ; Number Discount ;
Number Redemption [ ; Basis Basis = 0 ] )
Computes the price per \$100 face value of a discounted security.
PRICEMAT( DateParam Settlement ;
DateParam Maturity ; Number Issue ;
Number Rate ; Number AnnualYield [ ; Basis
Basis = 0 pays
Computes the price per \$100 face value of a security that ] ) interest at maturity.
PROB( ForceArray Array
Computes the probability that values in a range are between two limits. Data ; ForceArray Array Probability ; Number Start
+
PRODUCT( {
Multiplies the numeric values of arguments in argument-list. NumberSequence N } )
PROPER( Text T string and any other letters in string that immediately follow
Makes a lowercase version of string except that the first letter in )
PV( Number Rate ; Number Nper ; Number
Payment [ ; Number Fv = 0 [ ; Number
PayType = ] ] )
Computes the present value of an investment. (The present0value is the total amount that a series of future payments is wort
Computes the quartile of a data set.             QUARTILE( NumberSequence Data ; Integer Quart )
QUOTIENT( Number
Computes the integer portion of the division of dividend by divisor. A ; Number B )
RAND()
Computes an evenly distributed random real number greater than or equal to 0 and less than 1. A new random real number i
RANDBETWEEN( Integer A ; Integer B )
Computes a random integer number in the range lower-bound–upper-bound. A new random integer number is returned ever
RANK( Number duplicate numbers the same Data However, Order = 0 ]
Computes the rank of a number in a list of numbers. RANK gives Value ; NumberSequenceList rank. [ ; Numberthe presence) of
RATE( Number Nper ; Number Payment ;
Number Pv [ ; Number Fv = 0 [ ; Number
PayType = 0 [ ; Number Guess = 0.1 ] )
Computes the interest rate per period of an annuity, using iteration, which can result]in]zero or more solutions.

DateParam Maturity ; Number Investment ;
Computes the amount received at maturity for aNumber Discount [ ; Basis Basis = 0 ] )
fully invested security.
REPLACE( Text T ; Number at position start-pos, ; Text New )
Produces a new string that is string-1 with number-chars characters starting Start ; Number Countreplaced by string-2. (REPLA

REPLACEB( Text T ; BytePosition start-pos, replaced by Text New )
Produces a new string that is string-1 with number-bytes bytes starting at positionStart ; ByteLength Len ;string-2. (REPLACEB
of occurrences of Count )
Creates a string that is replication-count numberT( Text T ; Integer string concatenated together.
from string. T [ ; Integer Length ] )
Extracts the right-most number-chars charactersRIGHT( Text (RIGHT is intended for use with languages that use the single-by
RIGHTB( Text T [ ; ByteLength is intended
Extracts the right-most number-bytes-worth of characters from string. (RIGHTB Length ] ) for use with languages that use th
ROMAN( Number N to form.
Converts the Arabic number, number, to a Roman number according [ ; Number Format = 0 ] )
ROUND( Number X [ ; Number Digits = 0 ] )
Rounds x to the number of digits specified by number-digits.
ROUNDDOWN( specified [ Number Digits = 0 ] )
Computes x rounded down, toward zero, to the number of digitsNumber Xby; number-digits. [Note: ROUNDDOWN behaves li
number of Number X [ ; Number Digits = 0 )
Computes x rounded up, away from zero, to the ROUNDUP(digits specified by number-digits.][Note: ROUNDUP behaves like R
Finds the number of the row(s) corresponding toROW( [ Reference R ] )
reference.
Finds the number of rows corresponding to array. ROWS( Reference|Array R )

RRI( Number P ; Number Pv ; Number Fv )
RSQ( correlation coefficient ; ForceArray Array in known
Computes the square of the Pearson product momentForceArray Array arrayYthrough data pointsarrayX ) ys and known xs.
Retrieves data from a program in real-time. Periodically, this function returns new values and causes recalculation of the expr
SEARCH( Text Search ; Text T [ ; Number Start = 1 )
Performs a case-insensitive search, using a lexical comparison, for the first occurrence of string-1 in ]string-2, starting at chara

SEARCHB( Text Search ; Text T [ ; BytePosition Start ] )
Performs a case-insensitive search, using a lexical comparison, for the first occurrence of string-1 in string-2, starting at byte p
ed in radians.                                                 SEC( Number N )
given angle specified in radians                               SECH( Number N )

SECOND( given time-value.
Computes the second for the date and/or time having the TimeParam T )

SERIESSUM( Number X ; Number N ; Number
Computes the sum of a power series.                 M ; NumberSequence Coefficients )
erence or the string representing a sheet name.                 SHEET( [ Text|Reference R ] )
ference or current document                                     SHEETS( [ Reference R ] )
Determines the sign of x.                           SIGN( Number N )
Computes the sine of x.                             SIN( Number N )
Computes the hyperbolic sine of x.                  SINH( Number N )
+
Computes the skewness of a distribution. [Note: SKEW( { NumberSequenceList sample } )
Skewness characterizes the degree of asymmetry of a distribution around its
+
tion using the population of a random variable.             SKEWP( { NumberSequence population } )

DDB( Number Cost ; Number Salvage ;
Computes the straight-line depreciation of an asset for one period.)
SLOPE( data points in known ys and y ; ForceArray NumberSequence dista
Computes the slope of the linear regression line throughForceArray NumberSequenceknown xs. The slope is the vertical x )
Computes the kth smallest value in a data set. SMALL( NumberSequenceList List ; Number|Array N )
Computes the positive square root of x.          SQRT( Number N )
Computes the positive square root of x × π.      SQRTPI( Number N )
characterized Number value ; Number mean ; Number sigma )
Computes a normalized value from a distributionSTANDARDIZE( by mean and standard-dev.
+
STDEV( NumberSequenceList N } )
Makes an estimate of the standard deviation based on a{sample, using the "unbiased" or "n-1" method. [Note: STDEV assume
+
STDEVA( { Any sample } )
Makes an estimate of the standard deviation based on a sample, using the "unbiased" or "n-1" method. [Note: STDEVA assum
+
STDEVP( NumberSequence N "n"
Computes the standard deviation of an entire population,{using the "biased" or } ) method. [Note: STDEVP assumes that its a
+
STDEVPA( { Any sample } )
Computes the standard deviation of an entire population, using the "biased" or "n" method. [Note: STDEVPA assumes that its
STEYX( ForceArray NumberSequence standard error is a measure of the amo
Computes the standard error of the predicted y-value for each x in the regression. The measuredY ; ForceArray NumberSeque
SUBSTITUTE( Text T ; Text replaced New [ ; Number
Produces a new string that is string with one or all occurrences of old-string Old ; Textby new-string. Which ] )
Computes a value using the function designated SUBTOTAL( Integer function ; NumberSequence sequence )
by function-number, using the arguments in argument-list.
+
SUM( {
Adds the numeric values of arguments in argument-list. NumberSequenceList N } )
SUMIF( ReferenceList|Reference R ; Any C ; a corresponding
Applies selection criteria on the values in one range of cells and sums the values of the cells [in Reference S ] ) range.
SUMIFS( Reference R ; Reference R1 ; Any C1 [ ; Reference R2 ; Any C2 ]... )
Adds the cells in a range that meet multiple criteria.

+
SUMPRODUCT( ForceArray Array A } )
Multiplies the corresponding elements in the array arguments in{argument-list, and returns the sum of those products. An arr
+
Adds the squares of arguments in argument-list. SUMSQ( { NumberSequence N } )
SUMX2MY2( ForceArray Array A ; ForceArray Array B )
Computes the sum of the difference of squares of the corresponding numerical elements in two arrays designated by array-1
SUMX2PY2( ForceArray Array A ; ForceArray Array designated by array-1 an
Computes the sum of the sum of the squares of the corresponding numerical elements in two arrays B )
SUMXMY2( corresponding numerical elements in two
Computes the sum of the squares of the difference betweenForceArray Array A ; ForceArray Array B )arrays designated by a

SYD( Number Cost ; Number Salvage ;
Computes the sum-of-years' digits depreciation of an asset for a specified period. )
Retrieves the text referencedby value.          T( Any X )
Computes the tangent of x.                      TAN( Number N )
Computes the hyperbolic tangent of x.           TANH( Number N )
TBILLEQ( DateParam Settlement ; DateParam
Maturity ;
Computes the bond-equivalent yield for a U.S. Treasury bill.Number Discount )
TBILLPRICE( DateParam Settlement ;
DateParam Maturity ; Number Discount )
Computes the price per \$100 face value for a U.S. Treasury bill.
TBILLYIELD( DateParam Settlement ;
Computes the yield for a U.S. Treasury bill.    DateParam Maturity ; Number Price )
TDIST( Number value ; Integer degreeOfFreedom Integer mode )
Computes the Percentage Points (probability) for the Student t-distribution where a numeric value,; x, is a calculated value of
TEXT( Scalar X ; Text FormatCode )
Produces a string containing value formatted according to format.

Computes the serial value for the given time. TIME( Number hours ; Number minutes ; Number seconds )
TIMEVALUE( Text T )
Computes the serial value of the time represented by the string date-time-string.
TINV( a function of the probability degreeOfFreedom )
Computes the t-value of the Student's t-distribution as Number probability ; Integer and the degrees of freedom.
TODAY()
Computes the serial value of the current date, taking into account the current date base value.
TRANSPOSE( by copying
Creates a new array that is the transpose of an existing array, Array A ) the first row of the existing array to the first column
TREND( NumberSequence of least [ ; [ NumberSequence knownX ] [ ; [ know
Computes values along a linear trend. Fits a straight line (using the method knownY squares) to the arrays known-ys and Num
TRIM( Text T )
Makes a string that is a copy of string with the leading and trailing space characters removed, and each sequence of embedde
TRIMMEAN( NumberSequenceList dataSet ; Number and bottom tails
Computes the mean of the interior of a data set by excluding a percentage of data points from the topcutOffFraction ) of a d
TRUE()
Computes the value TRUE. (A call to function TRUE is equivalent to using the logical-constant TRUE.)
Truncates x to the number of fractional digits by TRUNC( Number a ; Number b )
number-digits.
TTEST( ForceArray NumberSequence X1 ;
ForceArray NumberSequence X2 ; Integer
mode ; Integer
Computes the probability associated with a Student's t-Test. type )
TYPE( Any value )
Computes the type of value or, if value is a reference to a single cell, the type of the value in that cell.
given numeric value according to the UnicodeTM Standard / ISO 10646.Number N )
UNICHAR(
UNICODE( Text T )
O 10646 code point corresponding to the first character of the text value.
Makes an uppercase version of string.             UPPER( Text T )
Produces a string containing number rounded to num-decimal decimal places. The thousands separator is the comma, the rad
Converts string to a number.                      VALUE( Text X )
+
VAR( NumberSequence N } )
Makes an estimate of the variance based on a sample.{ [Note: VAR assumes that its arguments are a sample of the population
+
VARA( { Any VARA assumes that its arguments are a sample of the populatio
Makes an estimate of the variance based on a sample. [Note: sample } )
+
VARP( { NumberSequence N arguments are the total population. If the data
Computes the variance of an entire population. [Note: VARP assumes that its } )
+
VARPA( { assumes that )
Makes the variance of an entire population. [Note: VARPAAny sample } its arguments are the total population. If the data re

VDB( Number cost ; Number salvage ;
Number life ; Number start-period ; Number
end-period [ ; Number depreciation-factor = 2
[ ; Logical switch = FALSE() ] ] )
Computes the depreciation of an asset for the period specified, including partial periods, using the double-declining balance o
VLOOKUP( Any Lookup ; an array, noting DataSource ; Integer Column ; Lo
Performs a vertical search for a value in the left-most column of a table orReference|Array the row in which the matching[ val

WEEKDAY( DateParam Date [ ; Integer Type the )
Computes the weekday number for the date having the given serial-value, taking into account= 1 ] current date base value an
WEEKNUM( DateParam Date [ ; Number two = 1 ] )
Computes the week number of the date corresponding to serial-value. The function allowsType number systems: System 1: T
Computes the Weibull distribution.               WEIBULL( Number value ; Number alpha ; Number beta ; Logical cumulativ
WORKDAY( DateParam Date ; Number Offset [
; [ DateSequence Holidays ] [ ; LogicalSequence
Workdays ] ] )
Computes the serial value of the date that is day-offset working days offset from start-date. Weekend days (Saturday and Sun

Computes the serial value of the date that is day-offset working days offset from start-date. Weekend days and any holidays

XIRR( NumberSequence Values ;
DateSequence Dates [ Number Guess = 0.1 ] )
Computes the internal rate of return for a schedule of cash flows that is; not necessarily periodic. XIRR uses an iterative calcul
XNPV( Number Rate ; NumberSequence
Values ; DateSequence Dates )
Computes the net present value for a schedule of cash flows that is not necessarily periodic.
XOR( { Logical L }+ )
YEAR( DateParam D )
Computes the numeric year in the Gregorian calendar [ISO 8601 §3.2.1] for the date and/or time having the given date-value
YEARFRAC( DateParam StartDate ; between twodates, start-date and = 0 ]
Computes the fractional number of years represented by the number of whole days DateParam EndDate [ ; Basis Basisend-d)
YIELD( DateParam Settlement ; DateParam
Maturity ; Number Rate ; Number Price ;
Number Redemption ; Number Frequency [ ;
Basis Basis
Computes the yield on a security that pays periodic interest.= 0 ] )
YIELDDISC( DateParam Settlement ;
DateParam Maturity ; Number Price ;
Number Redemption [ ; Basis Basis = 0 ] )
Computes the annual yield for a discounted security.
YIELDMAT( DateParam Settlement ;
DateParam Maturity ; DateParam Issue ;
Number Rate ; Number Price [ ; Basis Basis =
0])
Computes the annual yield of a security that pays interest at maturity.
ZTEST( NumberSequenceList sample ; Number mean [ ; Number sigma ] )
Computes the one-tailed probability-value of a z-test. For a given hypothesized population mean, test-value, ZTEST returns th
ISO/IEC 29500-Syntax                                 OpenFormula-Class
ABS ( x )                                            Mathematical

ACCRINT ( issue , first-interest , settlement ,
rate , [ par ] , frequency [ , [ basis ] ] )         Financial

ACCRINTM ( issue , settlement , rate , [ [ par ] [
, [ basis ] ] ] )                                  Financial
ACOS ( x )                                         Mathematical

ACOSH ( x )                                          Mathematical
Mathematical
Mathematical
ADDRESS ( row-number , col-number [ , [ ref-
type ] [ , [ A1-ref-style-flag ] [ , sheet-name ] ] ]
)                                                     Lookup

AMORDEGRC ( cost , date-purchased , first-
period , salvage , period , rate [ , [ basis ] ] )   Financial
AMORLINC ( cost , date-purchased , first-
period , salvage , period , rate [ , [ basis ] ] )   Financial
AND ( argument-list )                                Logical
Number Representation Conversion

AREAS ( reference )                                  Information
ASC ( string )                                       Text
ASIN ( x )                                           Mathematical
ASINH ( x )                                          Mathematical
ATAN ( x )                                           Mathematical
ATAN2 ( x , y )                                      Mathematical
ATANH ( x )                                          Mathematical

AVEDEV ( argument-list )                             Statistical
AVERAGE ( argument-list )                            Statistical
AVERAGEA ( argument-list )                           Statistical
AVERAGEIF ( cell-range , selection-criteria [ ,
average-range ] )                                    Statistical
AVERAGEIFS ( average-range , cell-range-1 ,
selection-criteria-1 [ , cell-range-2 , selection-
criteria-2 [ , … ] ] )                               Statistical
; Integer S2 ] )                                                   Statistical
BAHTTEXT ( number )
Number MinimumLength ] )                                           Number Representation Conversion

BESSELI ( x , n )                                      Mathematical

BESSELJ ( x , n )                                      Mathematical

BESSELK ( x , n )                                      Mathematical

BESSELY ( x , n )                                      Mathematical
BETADIST ( x , alpha , beta [ , [ A ] , [ B ] ] )      Statistical
BETAINV ( probability , alpha , beta [ , [ A ] , [ B
]])                                                    Statistical
BIN2DEC ( number )                                     Number Representation Conversion
BIN2HEX ( number [ , num-hex-digits ] )                Number Representation Conversion
BIN2OCT ( number [ , num-oct-digits ] )                Number Representation Conversion
BINOMDIST ( number-successes , number-
trials , success-probability , cumulative-flag )   Statistical
Bit operation
Bit operation
Bit operation
Bit operation
Bit operation
CEILING ( x , significance )                       Rounding
CELL ( category [ , reference ] )                  Information
CHAR ( x )                                         Text
er DegreesOfFreedom )                                          Statistical
CHIDIST ( x , degrees-freedom )
r DegreesOfFreedom )                                           Statistical
CHIINV ( probability , degrees-freedom )            Statistical
greesOfFreedom [ ; Logical Cumulative = TRUE() ] )             Statistical
reesOfFreedom )                                                Statistical
Statistical
CHITEST ( actual-range , expected-range )
CHOOSE ( index , argument-list )               Lookup
CLEAN ( string )                               Text
CODE ( string )                                Text
COLUMN ( [ reference ] )                       Information
COLUMNS ( array )                              Information

COMBIN ( number , number-chosen )              Mathematical
Mathematical
COMPLEX ( real-number , imaginary-number [ ,
suffix ] )
CONCATENATE ( argument-list )                  Text

CONFIDENCE ( alpha , standard-dev , size )     Statistical
CONVERT ( number , from-unit , to-unit )       Mathematical
CORREL ( array-1 , array-2 )                         Statistical
COS ( x )                                            Mathematical
COSH ( x )                                           Mathematical
Mathematical
Mathematical
COUNT ( argument-list )                              Information
COUNTA ( argument-list )                             Information
COUNTBLANK ( cell-range )                            Information
COUNTIF ( cell-range , selection-criteria )          Information
COUNTIFS ( count-range , cell-range-1 ,
selection-criteria-1 [ , cell-range-2 , selection-
criteria-2 [ , … ] ] )                               Information

COUPDAYBS ( settlement , maturity ,
frequency [ , [ basis ] ] )                          Financial

[ basis ]
COUPDAYS ( settlement , maturity , frequency [ ,Financial] )

[ , [ basis
COUPDAYSNC ( settlement , maturity , frequencyFinancial ] ] )

Financial
COUPNCD ( settlement , maturity , frequency [ , [ basis ] ] )

[ basis ]
COUPNUM ( settlement , maturity , frequency [ ,Financial] )

basis ] ]
COUPPCD ( settlement , maturity , frequency [ , [Financial )
COVAR ( array-1 , array-2 )                       Statistical
, alpha )
CRITBINOM ( number-trials , success-probability Statistical
Mathematical
Mathematical
CUBEKPIMEMBER ( connection , kpi-name , kpi-property [ , [ caption ] ] )
CUBEMEMBER ( connection , member-expression , [ , [ caption ] ] )
CUBEMEMBERPROPERTY ( connection , member-expression , property )
CUBERANKEDMEMBER ( connection , set-expression , rank [ , caption ] )
CUBESET ( connection , set-expression [ , [ caption ] [ , [ sort-order ] [ , [ sort-by ] ] ] ] )
CUBESETCOUNT ( set )
CUBEVALUE ( connection , argument-list )

Financial
CUMIPMT ( rate , nper , pv , start-period , end-period , type )

Financial
CUMPRINC ( rate , nper , pv , start-period , end-period , type )
DATE ( year , month , day )                       Date and Time
DATEDIF ( start-date , end-date , unit )          Date and Time
DATEVALUE ( date-time-string )                    Date and Time

DAVERAGE ( database , field , criteria )          Database
DAY ( date-value )                                Date and Time
ram StartDate )                                             Date and Time
)
DAYS360 ( start-date , end-date [ , method-flag ] Date and Time

DB ( cost , salvage , life , period [ , [ month ] ] ) Financial
DCOUNT ( database , field , criteria )                Database
DCOUNTA ( database , field , criteria )               Database

DDB ( cost , salvage , life , period [ , factor ] )   Financial
item [ ; Integer Mode = 0 ] )                                    External Access
DEC2BIN ( number [ , num-bin-digits ] )              Number Representation Conversion
DEC2HEX ( number [ , num-hex-digits ] )              Number Representation Conversion
DEC2OCT ( number [ , num-oct-digits ] )              Number Representation Conversion
Number Representation Conversion
DEGREES ( angle )                                    Mathematical
DELTA ( number-1 [ , number-2 ] )                    Mathematical

DEVSQ ( argument-list )                              Statistical
DGET ( database , field , criteria )                 Database

Financial
DISC ( settlement , maturity , pr , redemption [ , [ basis ] ] )
DMAX ( database , field , criteria )               Database
DMIN ( database , field , criteria )               Database
DOLLAR ( number [ , num-decimal ] )                Text

DOLLARDE ( fractional-dollar , fraction )            Financial

DOLLARFR ( decimal-dollar , fraction )               Financial

DPRODUCT ( database , field , criteria )             Database
DSTDEV ( database , field , criteria )               Database
DSTDEVP ( database , field , criteria )              Database
DSUM ( database , field , criteria )                 Database
, frequency
DURATION ( settlement , maturity , coupon , yld Financial [ , [ basis ] ] )
DVAR ( database , field , criteria )            Database
DVARP ( database , field , criteria )           Database
ECMA.CEILING ( x , significance )

EDATE ( start-date , month-offset )               Date and Time

EFFECT ( nominal-rate , npery )                   Financial
EOMONTH ( start-date , month-offset )             Date and Time

ERF ( lower-bound [ , upper-bound ] )                Mathematical
ERFC ( lower-bound )                                 Mathematical
ERROR.TYPE ( value )                                 Information
om ; Text To [ ; Logical FullPrecision = FALSE() [ ; Integer TriangulationPrecision ] ] )
Mathematical
EVEN ( x )                                           Mathematical
EXACT ( string-1 , string-2 )                        Text
EXP ( x )                                            Mathematical
EXPONDIST ( x , lambda , cumulative-flag )           Statistical
FACT ( x )                                           Mathematical
FACTDOUBLE ( n )                                     Mathematical
FALSE ( )                                            Logical
FDIST ( x , degrees-freedom-1 , degrees-freedom-2 )  Statistical
r1 ; Number r2 )                                              Statistical
FIND ( string-1 , string-2 [ , start-pos ] )    Text
FINDB ( string-1 , string-2 , [ start-pos ] )   Byte-postion text
Statistical
FINV ( probability , degrees-freedom-1 , degrees-freedom-2 )
1   ; Number r2 )                                               Statistical
FISHER ( x )                                     Statistical
FISHERINV ( y )                                  Statistical
Text
FIXED ( number [ , [ num-decimal ] [ , suppress-commas-flag ] ] )
FLOOR ( x , significance )                       Rounding
FORECAST ( x , known-ys , known-xs )             Statistical
Information
FREQUENCY ( data-array , bins-array )            Statistical
FTEST ( array-1 , array-2 )                      Statistical

FV ( rate , nper , pmt [ , [ pv ] [ , [ type ] ] ] )   Financial

FVSCHEDULE ( principal , schedule )              Financial
Mathematical
GAMMADIST ( x , alpha , beta , cumulative-flag ) Statistical
GAMMAINV ( probability , alpha , beta )          Statistical
GAMMALN ( x )                                    Mathematical
Statistical
GCD ( argument-list )                                  Mathematical
GEOMEAN ( argument-list )                              Statistical
GESTEP ( number [ , step ] )                           Mathematical
Lookup
GETPIVOTDATA ( data-field , pivot-table , field-1 , item-1 [ , field-2 , item-2 [ , … ] ] )
[ , const-flag ] ] )
GROWTH ( known-ys [ , [ known-xs ] [ , [ new-xs ]Statistical
HARMEAN ( argument-list )                              Statistical
HEX2BIN ( number [ , num-bin-digits ] )                Number Representation Conversion
HEX2DEC ( number )                                     Number Representation Conversion
HEX2OCT ( number [ , num-oct-digits ] )        Number Representation Conversion
Lookup
HLOOKUP ( lookup-value , table-array , row-index-num [ , [ range-lookup-flag ] ] )

HOUR ( time-value )                                    Date and Time

HYPERLINK ( link-location [ , [ friendly-name ] ] ) External Access
Statistical
HYPGEOMDIST ( sample-successes , number-sample , population-successes , number-population )
Logical
IF ( logical-value , [ value-if-true ] [ , [ value-if-false ] ] )
IFERROR ( value , value-if-error )                        Logical
Logical

IMABS ( complex-number )                               Complex Number
IMAGINARY ( complex-number )                           Complex Number
IMARGUMENT ( complex-number )                          Complex Number
IMCONJUGATE ( complex-number )                         Complex Number
IMCOS ( complex-number )                               Complex Number
Complex Number
Complex Number
Complex Number
)
IMDIV ( complex-number-1 , complex-number-2 Complex Number
IMEXP ( complex-number )                           Complex Number
IMLN ( complex-number )                            Complex Number
IMLOG10 ( complex-number )                         Complex Number
IMLOG2 ( complex-number )                          Complex Number
IMPOWER ( complex-number , y )                     Complex Number
IMPRODUCT ( argument-list )                        Complex Number
IMREAL ( complex-number )                          Complex Number
Complex Number
Complex Number
IMSIN ( complex-number )                           Complex Number
IMSQRT ( complex-number )                          Complex Number
)
IMSUB ( complex-number-1 , complex-number-2Complex Number
IMSUM ( argument-list )                            Complex Number
Complex Number
Lookup
array form: INDEX ( array , [ row-number ] [ , [ column-number ] ] ) reference form: INDEX ( reference [ , [ row-number ] [ , [ c
INDIRECT ( ref-text [ , [ A1-ref-style-flag ] ] )  Lookup

INFO ( category )                                        Information
INT ( x )                                                Rounding
INTERCEPT ( known-ys , known-xs )                        Statistical

Financial
INTRATE ( settlement , maturity , investment , redemption [ , [ basis ] ] )

IPMT ( rate , per, nper , pv , [ fv ] [ , [ type ] ] )   Financial

IRR ( values [ , [ guess ] ] )                           Financial
ISBLANK ( value )                                        Information
ISERR ( value )                                          Information
ISERROR ( value )                                        Information
ISEVEN ( value )                                         Information
Information
ISLOGICAL ( value )                                        Information
ISNA ( value )                                             Information
ISNONTEXT ( value )                                        Information
ISNUMBER ( value )                                         Information
ISO.CEILING ( x , [ significance ] )
ISODD ( value )                                            Information
Integer Mode = 2 ] )                                                  Date and Time

ISPMT ( rate , per, nper , pv )                          Financial
ISREF ( value )                                          Information
ISTEXT ( value )                                         Information
JIS ( string )                                           Text
KURT ( argument-list )                            Statistical
LARGE ( array , k )                               Statistical
LCM ( argument-list )                             Mathematical
LEFT ( string [ , number-chars ] )                Text

LEFTB ( string [ , number-bytes ] )                  Byte-postion text
LEN ( string )                                       Text
LENB ( string )                                      Byte-postion text
[ , stats-flag
LINEST ( known-ys [ , [ known-xs ] [ , [ const-flag ]Statistical ] ] )
LN ( x )                                             Mathematical
LOG ( x [ , base ] )                                 Mathematical
LOG10 ( x )                                          Mathematical
] [ , stats-flag ] ] )
LOGEST ( known-ys [ , [ known-xs ] [ , [ const-flagStatistical
LOGINV ( probability , mean , standard-dev )         Statistical
LOGNORMDIST ( x , mean , standard-dev )              Statistical
Lookup
vector form: LOOKUP ( lookup-value , lookup-vector , result-vector ) array form: LOOKUP ( lookup-value , array )
LOWER ( string )                                     Text
Lookup
MATCH ( lookup-value , lookup-array [ , [ match-type ] ] )
MAX ( argument-list )                             Statistical
MAXA ( argument-list )                            Statistical
MDETERM ( array )                                 Array/matrix

Financial
MDURATION ( settlement , maturity , coupon , yld , frequency [ , [ basis ] ] )
MEDIAN ( argument-list )                      Statistical
MID ( string , start-pos , number-chars )     Text
MIDB ( string , start-pos , number-bytes )    Byte-postion text
MIN ( argument-list )                             Statistical
MINA ( argument-list )                            Statistical

MINUTE ( time-value )                             Date and Time
MINVERSE ( array )                                Array/matrix

MIRR ( values , finance-rate , reinvest-rate )    Financial
MMULT ( array-1 , array-2 )                       Array/matrix
MOD ( x , y )                                     Mathematical
MODE ( argument-list )                            Statistical
MONTH ( date-value )                              Date and Time
MROUND ( x , multiple)                            Rounding
Array/matrix
MULTINOMIAL ( argument-list )               Mathematical
FormulaCell ; Reference RowCell ; Reference RowReplacement [ ; Reference ColumnCell ; Reference ColumnReplacement ] )
Lookup
N ( value )                                 Information
NA ( )                                         Information
Statistical
NEGBINOMDIST ( number-failures , number-successes , success-probability )
Date
NETWORKDAYS ( start-date , end-date [ , holidays ] ) and Time

Number form: NETWORKDAYS.INTL ( start-
date , end-date [ , [ weekend-number ][ ,
holidays ]] )
String form: NETWORKDAYS.INTL ( start-date ,
end-date [ , [ weekend-string ][ , holidays ]] )

NOMINAL ( effect-rate , npery )                Financial
Statistical
NORMDIST ( x , mean , standard-deviation , cumulative-flag )
Statistical
NORMINV ( probability , mean , standard-deviation )
Statistical
NORMSDIST ( z )
Statistical
NORMSINV ( probability )
NOT ( logical-value )                          Logical
NOW ( )                                        Date and Time

NPER ( rate , pmt , pv [ , [ fv ] [ , [ type ] ] ] )   Financial

NPV ( rate , argument-list )                           Financial
Information
OCT2BIN ( number [ , num-bin-digits ] )                Number Representation Conversion
OCT2DEC ( number )                                     Number Representation Conversion
OCT2HEX ( number [ , num-hex-digits ] )                Number Representation Conversion
ODD ( x )                                              Mathematical

Financial
ODDFPRICE ( settlement , maturity , issue , first-coupon , rate , yld , redemption , frequency [ , [ basis ] ] )

Financial
ODDFYIELD ( settlement , maturity , issue , first-coupon , rate , pr , redemption , frequency [ , [ basis ] ] )

, rate , yld
ODDLPRICE ( settlement , maturity , last-interestFinancial , redemption , frequency [ , [ basis ] ] )
, rate , pr
ODDLYIELD ( settlement , maturity , last-interest Financial , redemption , frequency [ , [ basis ] ] )
Lookup
OFFSET ( reference , rows , cols [ , [ height ] [ , [ width ] ] ] )
OR ( argument-list )                                      Logical
PEARSON ( array-1 , array-2 )                             Statistical
PERCENTILE ( array , k )                                  Statistical
PERCENTRANK ( array , x [ , significance ] )              Statistical
PERMUT ( number , number-chosen )                         Statistical
eger Chosen )                                                        Statistical
Statistical
PHONETIC ( string )
PI ( )                                                   Mathematical

Financial

PMT ( rate , nper , pv [ , [ fv ] [ , [ type ] ] ] )     Financial
POISSON ( x , mean , cumulative-flag )                   Statistical
POWER ( x , y )                                          Mathematical

F
PPMT ( rate , per , nper , pv [ , [ fv ] [ , [ type ] ] ] ) inancial

Financial
PRICE ( settlement , maturity , rate , yld , redemption , frequency [ , [ basis ] ] )

Financial
PRICEDISC ( settlement , maturity , discount , redemption [ , [ basis ] ] )

Financial
PRICEMAT ( settlement , maturity , issue , rate , yld [ , [ basis ] ] )
, upper-limit
PROB ( x-range , probability-range , lower-limit [ Statistical ] )
PRODUCT ( argument-list )
PROPER ( string )                                        Text

PV ( rate , nper , pmt [ , [ fv ] [ , [ type ] ] ] )     Financial
QUARTILE ( array , result-category )                        Statistical
QUOTIENT ( dividend , divisor )                             Mathematical
RAND ( )                                                    Mathematical
RANDBETWEEN ( lower-bound , upper-bound )                   Mathematical
RANK ( number , number-list [ , order ] )                   Statistical

Financial
RATE ( nper , pmt , pv [ , [ [ fv ] [ , [ [ type ] [ , [ guess ] ] ] ] ] ] )

Financial
RECEIVED ( settlement , maturity , investment , discount [ , [ basis ] ] )
Text
REPLACE ( string-1 , start-pos , number-chars , string-2 )

Byte-postion text
REPLACEB ( string-1 , start-pos , number-bytes , string-2 )
REPT ( string , replication-count )               Text
RIGHT ( string [ , number-chars ] )               Text
RIGHTB ( string , [ number-bytes ] )              Byte-postion text
ROMAN ( number , form )                           Number Representation Conversion
ROUND ( x , number-digits )                       Rounding
ROUNDDOWN ( x , number-digits )                   Rounding
ROUNDUP ( x , number-digits )                     Rounding
ROW ( [ reference ] )                             Information
ROWS ( array )                                    Information

Financial
RSQ ( known-ys , known-xs )                                 Statistical
RTD ( progID , [ rtd-server ] , argument-list )
SEARCH ( string-1 , string-2 [ , start-pos ] )              Text

SEARCHB ( string-1 , string-2 [ , start-pos ] )             Byte-postion text
Mathematical
Mathematical

SECOND ( time-value )                                       Date and Time

Mathematical
SERIESSUM ( input-value , initial-power , step , coefficients )
Information
Information
SIGN ( x )                                        Mathematical
SIN ( x )                                         Mathematical
SINH ( x )                                        Mathematical
SKEW ( argument-list )                               Statistical
Statistical

SLN ( cost , salvage , life )                        Financial
SLOPE ( known-ys , known-xs )                        Statistical
SMALL ( array , k )                                  Statistical
SQRT ( x )                                           Mathematical
SQRTPI ( x )                                         Mathematical
STANDARDIZE ( x , mean , standard-dev )              Statistical
STDEV ( argument-list )                              Statistical
STDEVA ( argument-list )                             Statistical
STDEVP ( argument-list )                             Statistical
STDEVPA ( argument-list )                           Statistical
STEYX ( known-ys , known-xs )                       Statistical
Text
SUBSTITUTE ( string , old-string , new-string [ , occurence ] )
SUBTOTAL ( function-number , argument-list ) Mathematical
SUM ( argument-list )                              Mathematical
Mathematical
SUMIF ( cell-range , selection-criteria [ , sum-range ] )
Mathematical
SUMIFS ( sum-range , cell-range-1 , selection-criteria-1 [ , cell-range-2 , selection-criteria-2 [ , … ] ] )

SUMPRODUCT ( argument-list )                         Array/matrix
SUMSQ ( argument-list )                              Mathematical
SUMX2MY2 ( array-1 , array-2 )                       Array/matrix
SUMX2PY2 ( array-1 , array-2 )                       Array/matrix
SUMXMY2 ( array-1 , array-2 )                        Array/matrix

SYD ( cost , salvage , life , per )                  Financial
T ( value )                                          Text
TAN ( x )                                            Mathematical
TANH ( x )                                           Mathematical

TBILLEQ ( settlement , maturity , discount )         Financial

TBILLPRICE ( settlement , maturity , discount )      Financial

TBILLYIELD ( settlement , maturity , pr )          Financial
TDIST ( x , degrees-freedom , distribution-tails ) Statistical
TEXT ( value , format )                            Text

TIME ( hour , minute , second )                      Date and Time
TIMEVALUE ( date-time-string )                       Date and Time
TINV ( probability , degrees-freedom )               Statistical
TODAY ( )                                            Date and Time
TRANSPOSE ( array )                                 Array/matrix
const-flag
TREND ( known-ys [ , [ known-xs ] [ , [ new-xs ] [ ,Statistical ] ] )
TRIM ( string )                                     Text
TRIMMEAN ( array , percent )                        Statistical
TRUE ( )                                            Logical
TRUNC ( x [ , number-digits ] )                     Rounding

Statistical
TTEST ( array-1 , array-2 , distribution-tails , test-type )
TYPE ( value )                                        Information
Text
Text
UPPER ( string )                                        Text
USDOLLAR ( number [ , num-decimal ] )
VALUE ( string )                                        Information
VAR ( argument-list )                                   Statistical
VARA ( argument-list )                                  Statistical
VARP ( argument-list )                                  Statistical
VARPA ( argument-list )                                 Statistical

Financial
VDB ( cost , salvage , life , start-period , end-period [ , [ [ factor ] [ , [ no-switch-flag ] ] ] ] ] )
Lookup
VLOOKUP ( lookup-value , table-array , col-index-num [ , [ range-lookup-flag ] ] )

WEEKDAY ( serial-value [ , weekday-start-flag ] ) Date and Time
WEEKNUM ( serial-value [ , weekday-start-flag ] )Date and Time
WEIBULL ( x , alpha , beta , cumulative-flag )    Statistical

WORKDAY ( start-date , day-offset [ , holidays ] ) Date and Time

Number form: WORKDAY.INTL ( start-date ,
day-offset [ ,[ weekend-number ] [ , holidays ]]
)
String form: WORKDAY.INTL ( start-date , day-
offset [ , [ weekend-string ] [ , holidays ]] )

XIRR ( values , dates [ , [ guess ] ] )                 Financial

XNPV ( rate , values , dates )                          Financial
Logical
YEAR ( date-value )                                     Date and Time
YEARFRAC ( start-date , end-date [ , basis ] )       Date and Time

Financial
YIELD ( settlement , maturity , rate , pr , redemption , frequency [ , [ basis ] ] )

Financial
YIELDDISC ( settlement , maturity , pr , redemption [ , [ basis ] ] )

Financial
YIELDMAT ( settlement , maturity , issue , rate , pr [ , [ basis ] ] )
ZTEST ( array , test-value [ , sigma ] )           Statistical
ISO/IEC 29500-Class
Math and Trig

Financial

Financial
Math and Trig

Math and Trig

Lookup and Reference

Financial

Financial
Logical

Lookup and Reference
Text and Data

Math and Trig
Math and Trig
Math and Trig

Statistical
Statistical
Statistical

Statistical

Statistical
Text and Data

Engineering

Engineering

Engineering

Engineering
Statistical

Statistical
Engineering
Engineering
Engineering
Statistical

Math and Trig
Information
Text and Data

Statistical

Statistical
Statistical
Lookup and Reference
Text and Data
Text and Data
Lookup and Reference
Lookup and Reference

Math and Trig

Engineering
Text and Data

Statistical
Statistical
Math and Trig
Math and Trig

Statistical
Statistical
Statistical
Statistical

Statistical

Financial

Financial

Financial

Financial

Financial

Financial
Statistical
Statistical

Cube
Cube
Cube
Cube
Cube

Financial

Financial
Date and Time
Date and Time
Date and Time

Database
Date and Time

Date and Time

Financial
Database
Database

Financial
Engineering
Engineering
Engineering

Math and Trig
Engineering

Statistical
Database

Financial
Database
Database
Text and Data

Financial

Financial

Database
Database
Database
Database
Financial
Database
Database
Math and Trig

Date and Time

Financial
Date and Time

Engineering
Engineering
Information

Math and Trig
Text and Data
Math and Trig
Statistical
Math and Trig
Math and Trig
Logical
Statistical

Text and Data
Text and Data
Statistical
Statistical
Statistical
Text and Data
Math and Trig
Statistical

Statistical
Statistical

Financial

Financial

Statistical
Statistical
Statistical

Math and Trig
Statistical
Engineering
Lookup and Reference
Statistical
Statistical
Engineering
Engineering
Engineering
Lookup and Reference

Date and Time

Lookup and Reference
Statistical
Logical
Logical

Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering

Engineering
Engineering
Engineering
Engineering

Lookup and Reference
Lookup and Reference

Information
Math and Trig
Statistical

Financial

Financial

Financial
Information
Information
Information
Information

Information
Information
Information
Information
Math and Trig

Financial
Information
Information
Text and Data
Statistical
Statistical
Math and Trig
Text and Data

Text and Data
Text and Data
Text and Data
Statistical
Math and Trig
Math and Trig
Math and Trig
Statistical
Statistical
Statistical
Lookup and Reference
Text and Data
Lookup and Reference
Statistical
Statistical
Math and Trig

Financial
Statistical
Text and Data
Text and Data
Statistical
Statistical

Date and Time
Math and Trig

Financial
Math and Trig
Math and Trig
Statistical
Date and Time
Math and Trig

Math and Trig

Information
Information
Statistical
Date and Time

Date and Time

Financial
Statistical
Statistical

Statistical

Statistical
Logical
Date and Time

Financial

Financial

Engineering
Engineering
Engineering
Math and Trig

Financial

Financial

Financial
Financial
Lookup and Reference
Logical
Statistical
Statistical
Statistical
Statistical

Text and Data
Math and Trig

Financial

Financial
Statistical
Math and Trig

Financial

Financial

Financial

Financial
Statistical
Math and Trig
Text and Data

Financial
Statistical
Math and Trig
Math and Trig
Math and Trig
Math and Trig
Statistical

Financial

Financial
Text and Data

Text and Data
Text and Data
Text and Data
Text and Data
Math and Trig
Math and Trig
Math and Trig
Math and Trig
Lookup and Reference
Lookup and Reference

Financial
Statistical
Lookup and Reference
Text and Data

Text and Data

Date and Time

Math and Trig

Math and Trig
Math and Trig
Math and Trig
Statistical

Financial
Statistical
Statistical
Math and Trig
Math and Trig
Statistical
Statistical
Statistical
Statistical
Statistical
Statistical
Text and Data
Math and Trig
Math and Trig
Math and Trig
Math and Trig

Math and Trig
Math and Trig
Math and Trig
Math and Trig
Math and Trig

Financial
Text and Data
Math and Trig
Math and Trig

Financial

Financial

Financial
Statistical
Text and Data

Date and Time
Date and Time
Statistical
Date and Time
Lookup and Reference
Statistical
Text and Data
Statistical
Logical
Math and Trig

Statistical
Information

Text and Data

Text and Data
Statistical
Statistical
Statistical
Statistical

Financial
Lookup and Reference

Date and Time
Date and Time
Statistical

Date and Time

Date and Time

Financial

Financial

Date and Time
Date and Time

Financial

Financial

Financial
Statistical

```
To top