Docstoc

OpenFormula-ISO29500-draft-comparison-Excel97 - Oasis

Document Sample
OpenFormula-ISO29500-draft-comparison-Excel97 - Oasis Powered By Docstoc
					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


ADDRESS      Returns a cell address (reference) as text




             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.
DEGREES    Convert radians to degrees.
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
EDATE          when MonthAdd months is added




               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
HYPERLINK      string to the IRI part of a hyperlink cell.
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.
RADIANS       Convert degrees to radians.
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
RECEIVED      of face value.
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 )
                                                           BETADIST(
            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 )
             Converts angle in degrees into radians.          RADIANS( Number N )
                                                              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.

                                                             RECEIVED( DateParam Settlement ;
                                                             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 ;
                                                            Number LifeTime
           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 ;
                                                           Number LifeTime ; Number Period
           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
RADIANS ( angle )                                           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

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:4/26/2013
language:English
pages:68
huangyuarong huangyuarong
About