VIEWS: 0 PAGES: 68 POSTED ON: 4/26/2013
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