# User:Devon McCormick/ExcelFnsHelp

From J Wiki

All functions in Excel 2014 along with the help text for each. Some - those whose names are preceded by a star - are apparently internal functions. This page is intended to help guide the population of this page, to provide examples of how common Excel functions would be implemented in J.

Name Explanation Argument(s) ABS Returns the absolute value of a number, a number without its sign!is the real number for which you want the absolute value number ACCRINTM Returns the accrued interest for a security that pays interest at maturity!is the security's issue date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the security's annual coupon rate!is the security's par value!is the type of day count basis to use start_date,days,holidays ACCRINT Returns the accrued interest for a security that pays periodic interest.!is the security's issue date, expressed as a serial date number!is the security's first interest date, expressed as a serial date number!is the security's settlement date, expressed as a serial date number!is the security's annual coupon rate!is the security's par value!is the number of coupon payments per year!is the type of day count basis to use!is a logical value: to accrued interest from issue date = TRUE or omitted; to calculate from last coupon payment date = FALSE issue,settlement,rate,par,basis ACOSH Returns the inverse hyperbolic cosine of a number!is any real number equal to or greater than 1 number ACOS Returns the arccosine of a number, in radians in the range 0 to Pi. The arccosine is the angle whose cosine is Number!is the cosine of the angle you want and must be from -1 to 1 index_num,value1,value2,... ADDRESS Creates a cell reference as text, given specified row and column numbers!is the row number to use in the cell reference: Row_number = 1 for row 1!is the column number to use in the cell reference. For example, Column_number = 4 for column D!specifies the reference type: absolute = 1; absolute row/relative column = 2; relative row/absolute column = 3; relative = 4!is a logical value that specifies the reference style: A1 style = 1 or TRUE; R1C1 style = 0 or FALSE!is text specifying the name of the worksheet to be used as the external reference start_date,end_date,method AGGREGATE Returns an aggregate in a list or database!is the number 1 to 19 that specifies the summary function for the aggregate.!is the number 0 to 7 that specifies the values to ignore for the aggregate!is the array or range of numerical data on which to calculate the aggregate!indicates the position in the array; it is k-th largest, k-th smallest, k-th percentile, or k-th quartile.!is the number 1 to 19 that specifies the summary function for the aggregate.!is the number 0 to 7 that specifies the values to ignore for the aggregate!are 1 to 253 ranges or references for which you want the aggregate number_s,trials,probability_s,cumulative AMORDEGRC Returns the prorated linear depreciation of an asset for each accounting period.!is the cost of the asset!is the date the asset is purchased!is the date of the end of the first period!is the salvage value at the end of life of the asset.!is the period!is the rate of depreciation!year_basis : 0 for year of 360 days, 1 for actual, 3 for year of 365 days. cost,date_purchased,first_period,salvage,period,rate,basis AMORLINC Returns the prorated linear depreciation of an asset for each accounting period.!is the cost of the asset!is the date the asset is purchased!is the date of the end of the first period!is the salvage value at the end of life of the asset.!is the period!is the rate of depreciation!year_basis : 0 for year of 360 days, 1 for actual, 3 for year of 365 days. number,from_unit,to_unit AND Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE!are 1 to 255 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references logical1,logical2,... AREAS Returns the current date and time formatted as a date and time. reference ASC Changes full-width (double-byte) characters to half-width (single-byte) characters. Use with double-byte character sets (DBCS)!is a text, or a reference to a cell containing a text text ASINH Returns the inverse hyperbolic sine of a number!is any real number equal to or greater than 1 number ASIN Returns the arcsine of a number in radians, in the range -Pi/2 to Pi/2!is the sine of the angle you want and must be from -1 to 1 number ATAN2 Returns the arctangent of the specified x- and y- coordinates, in radians between -Pi and Pi, excluding -Pi!is the x-coordinate of the point!is the y-coordinate of the point number ATANH Returns the inverse hyperbolic tangent of a number!is any real number between -1 and 1 excluding -1 and 1 database,field,criteria ATAN Returns the arctangent of a number in radians, in the range -Pi/2 to Pi/2!is the tangent of the angle you want AVEDEV Returns the average of the absolute deviations of data points from their mean. Arguments can be numbers or names, arrays, or references that contain numbers!are 1 to 255 arguments for which you want the average of the absolute deviations x,alpha,beta,A,B AVERAGEA Returns the average (arithmetic mean) of its arguments, evaluating text and FALSE in arguments as 0; TRUE evaluates as 1. Arguments can be numbers, names, arrays, or references!are 1 to 255 arguments for which you want the average value1,value2,... AVERAGEIFS Finds average(arithmetic mean) for the cells specified by a given set of conditions or criteria!are the actual cells to be used to find the average.!is the range of cells you want evaluated for the particular condition!is the condition or criteria in the form of a number, expression, or text that defines which cells will be used to find the average function_num,options,array,k!function_num,options,ref1,... AVERAGEIF Finds average(arithmetic mean) for the cells specified by a given condition or criteria!is the range of cells you want evaluated!is the condition or criteria in the form of a number, expression, or text that defines which cells will be used to find the average!are the actual cells to be used to find the average. If omitted, the cells in range are used average_range,criteria_range,criteria,... AVERAGE Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references that contain numbers!are 1 to 255 numeric arguments for which you want the average number1,number2,... BAHTTEXT Converts a number to text (baht)!is a number that you want to convert number BESSELI Returns the modified Bessel function In(x)!is the value at which to evaluate the function!is the order of the Bessel function values,dates,guess BESSELJ Returns the Bessel function Jn(x)!is the value at which to evaluate the function!is the order of the Bessel function x,n BESSELK Returns the modified Bessel function Kn(x)!is the value at which to evaluate the function!is the order of the function x,n BESSELY Returns the Bessel function Yn(x)!is the value at which to evaluate the function!is the order of the function x,n BETA.DIST Returns the beta probability distribution function!is the value between A and B at which to evaluate the function!is a parameter to the distribution and must be greater than 0!is a parameter to the distribution and must be greater than 0!is a logical value: for the cumulative distribution function, use TRUE; for the probability density function, use FALSE!is an optional lower bound to the interval of x. If omitted, A = 0!is an optional upper bound to the interval of x. If omitted, B = 1 probability,alpha,beta,A,B BETA.INV Returns the inverse of the cumulative beta probability density function (BETA.DIST)!is a probability associated with the beta distribution!is a parameter to the distribution and must be greater than 0!is a parameter to the distribution and must be greater than 0!is an optional lower bound to the interval of x. If omitted, A = 0!is an optional upper bound to the interval of x. If omitted, B = 1 x,deg_freedom,cumulative BETADIST Returns the cumulative beta probability density function!is the value between A and B at which to evaluate the function!is a parameter to the distribution and must be greater than 0!is a parameter to the distribution and must be greater than 0!is an optional lower bound to the interval of x. If omitted, A = 0!is an optional upper bound to the interval of x. If omitted, B = 1 x BETAINV This function is available for compatibility with Excel 2007 and earlier. Returns the inverse of the cumulative beta probability density function (BETADIST)!is a probability associated with the beta distribution!is a parameter to the distribution and must be greater than 0!is a parameter to the distribution and must be greater than 0!is an optional lower bound to the interval of x. If omitted, A = 0!is an optional upper bound to the interval of x. If omitted, B = 1 BIN2DEC Converts a binary number to decimal!is the binary number you want to convert number,places BIN2HEX Converts a binary number to hexadecimal!is the binary number you want to convert!is the number of characters to use inumber1,inumber2 BIN2OCT Converts a binary number to octal!is the binary number you want to convert!is the number of characters to use number,places BINOM.DIST Returns the individual term binomial distribution probability!is the number of successes in trials!is the number of independent trials!is the probability of success on each trial!is a logical value: for the cumulative distribution function, use TRUE; for the probability mass function, use FALSE trials,probability_s,alpha BINOM.INV Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value!is the number of Bernoulli trials!is the probability of success on each trial, a number between 0 and 1 inclusive!is the criterion value, a number between 0 and 1 inclusive alpha,standard_dev,size BINOMDIST This function is available for compatibility with Excel 2007 and earlier. Returns the individual term binomial distribution probability!is the number of successes in trials!is the number of independent trials!is the probability of success on each trial!is a logical value: for the cumulative distribution function, use TRUE; for the probability mass function, use FALSE x,deg_freedom CEILING.PRECISE Rounds a number up, to the nearest integer or to the nearest multiple of significance!is the value you want to round!is the multiple to which you want to round number,significance CEILING Rounds a number up, to the nearest multiple of significance!is the value you want to round!is the multiple to which you want to round sample_s,number_sample,population_s,number_pop CELL Returns information about the formatting, location, or contents of the first cell, according to the sheet's reading order, in a reference.!is a text value that specifies what type of cell information you want.!is the cell that you want information about value CHAR Returns the character specified by the code number from the character set for your computer!is a number between 1 and 255 specifying which character you want text CHIDIST This function is available for compatibility with Excel 2007 and earlier. Returns the right-tailed probability of the chi-squared distribution!is the value at which you want to evaluate the distribution, a nonnegative number!is the number of degrees of freedom, a number between 1 and 10^10, excluding 10^10 probability,deg_freedom CHIINV This function is available for compatibility with Excel 2007 and earlier. Returns the inverse of the right-tailed probability of the chi-squared distribution!is a probability associated with the chi-squared distribution, a value between 0 and 1 inclusive!is the number of degrees of freedom, a number between 1 and 10^10, excluding 10^10 number,number_chosen CHISQ.DIST.RT Returns the right-tailed probability of the chi-squared distribution!is the value at which you want to evaluate the distribution, a nonnegative number!is the number of degrees of freedom, a number between 1 and 10^10, excluding 10^10 probability,deg_freedom CHISQ.DIST Returns the left-tailed probability of the chi-squared distribution!is the value at which you want to evaluate the distribution, a nonnegative number!is the number of degrees of freedom, a number between 1 and 10^10, excluding 10^10!is a logical value for the function to return: the cumulative distribution function = TRUE; the probability density function = FALSE x,deg_freedom CHISQ.INV.RT Returns the inverse of the right-tailed probability of the chi-squared distribution!is a probability associated with the chi-squared distribution, a value between 0 and 1 inclusive!is the number of degrees of freedom, a number between 1 and 10^10, excluding 10^10 x,deg_freedom1,deg_freedom2,cumulative CHISQ.INV Returns the inverse of the left-tailed probability of the chi-squared distribution!is a probability associated with the chi-squared distribution, a value between 0 and 1 inclusive!is the number of degrees of freedom, a number between 1 and 10^10, excluding 10^10 probability,deg_freedom CHISQ.TEST Returns the test for independence: the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom!is the range of data that contains observations to test against expected values!is the range of data that contains the ratio of the product of row totals and column totals to the grand total array1,array2 CHITEST This function is available for compatibility with Excel 2007 and earlier. Returns the test for independence: the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom!is the range of data that contains observations to test against expected values!is the range of data that contains the ratio of the product of row totals and column totals to the grand total array1,array2 CHOOSE Chooses a value or action to perform from a list of values, based on an index number!specifies which value argument is selected. Index_num must be between 1 and 254, or a formula or a reference to a number between 1 and 254!are 1 to 254 numbers, cell references, defined names, formulas, functions, or text arguments from which CHOOSE selects lookup_value,table_array,row_index_num,range_lookup CLEAN Removes all nonprintable characters from text!is any worksheet information from which you want to remove nonprintable characters array CODE Returns a numeric code for the first character in a text string, in the character set used by your computer!is the text for which you want the code of the first character document_text,type_num,match_text COLUMNS Returns the number of rows in a reference or array!is an array, an array formula, or a reference to a range of cells for which you want the number of rows array COLUMN Returns the column number of a reference!is the cell or range of contiguous cells for which you want the column number. If omitted, the cell containing the COLUMN function is used COMBIN Returns the number of combinations for a given number of items!is the total number of items!is the number of items in each combination alpha,standard_dev,size COMPLEX Converts real and imaginary coefficients into a complex number!is the real coefficient of the complex number!is the imaginary coefficient of the complex number!is the suffix for the imaginary component of the complex number inumber1,inumber2,... CONCATENATE Joins several text strings into one text string!are 1 to 255 text strings to be joined into a single text string and can be text strings, numbers, or single-cell references number,power CONFIDENCE.NORM Returns the confidence interval for a population mean, using a normal distribution!is the significance level used to compute the confidence level, a number greater than 0 and less than 1!is the population standard deviation for the data range and is assumed to be known. Standard_dev must be greater than 0!is the sample size alpha,standard_dev,size CONFIDENCE.T Returns the confidence interval for a population mean, using a Student's T distribution!is the significance level used to compute the confidence level, a number greater than 0 and less than 1!is the population standard deviation for the data range and is assumed to be known. Standard_dev must be greater than 0!is the sample size actual_range,expected_range CONFIDENCE This function is available for compatibility with Excel 2007 and earlier. Returns the confidence interval for a population mean, using a normal distribution!is the significance level used to compute the confidence level, a number greater than 0 and less than 1!is the population standard deviation for the data range and is assumed to be known. Standard_dev must be greater than 0!is the sample size trials,probability_s,alpha CONVERT Converts a number from one measurement system to another!is the value in from_units to convert!is the units for number!is the units for the result issue, first_interest, settlement, rate, par, frequency, basis, calc_method CORREL Returns the correlation coefficient between two data sets!is a cell range of values. The values should be numbers, names, arrays, or references that contain numbers!is a second cell range of values. The values should be numbers, names, arrays, or references that contain numbers array1,array2 COSH Returns the hyperbolic cosine of a number!is any real number number COS Returns the cosine of an angle!is the angle in radians for which you want the cosine number COUNTA Counts the number of cells in a range that are not empty!are 1 to 255 arguments representing the values and cells you want to count. Values can be any type of information enable,macro_ref COUNTBLANK Counts the number of empty cells in a specified range of cells!is the range from which you want to count the empty cells type_num,scen_name COUNTIFS Counts the number of cells specified by a given set of conditions or criteria!is the range of cells you want evaluated for the particular condition!is the condition in the form of a number, expression, or text that defines which cells will be counted sum_range,criteria_range,criteria,... COUNTIF Counts the number of cells within a range that meet the given condition!is the range of cells from which you want to count nonblank cells!is the condition in the form of a number, expression, or text that defines which cells will be counted range COUNT Counts the number of cells in a range that contain numbers!are 1 to 255 arguments that can contain or refer to a variety of different types of data, but only numbers are counted logical_test,value_if_true,value_if_false!logical_test COUPDAYBS Returns the number of days from the beginning of the coupon period to the settlement date!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the number of coupon payments per year!is the type of day count basis to use settlement,maturity,frequency,basis COUPDAYSNC Returns the number of days from the settlement date to the next coupon date!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the number of coupon payments per year!is the type of day count basis to use settlement,maturity,frequency,basis COUPDAYS Returns the number of days in the coupon period that contains the settlement date!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the number of coupon payments per year!is the type of day count basis to use settlement,maturity,frequency,basis COUPNCD Returns the next coupon date after the settlement date!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the number of coupon payments per year!is the type of day count basis to use settlement,maturity,frequency,basis COUPNUM Returns the number of coupons payable between the settlement date and maturity date!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the number of coupon payments per year!is the type of day count basis to use settlement,maturity,frequency,basis COUPPCD Returns the previous coupon date before the settlement date!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the number of coupon payments per year!is the type of day count basis to use settlement,maturity,coupon,yld,frequency,basis COVARIANCE.P Returns population covariance, the average of the products of deviations for each data point pair in two data sets!is the first cell range of integers and must be numbers, arrays, or references that contain numbers!is the second cell range of integers and must be numbers, arrays, or references that contain numbers array1,array2 COVARIANCE.S Returns sample covariance, the average of the products of deviations for each data point pair in two data sets!is the first cell range of integers and must be numbers, arrays, or references that contain numbers!is the second cell range of integers and must be numbers, arrays, or references that contain numbers x,lambda,cumulative COVAR This function is available for compatibility with Excel 2007 and earlier. Returns covariance, the average of the products of deviations for each data point pair in two data sets!is the first cell range of integers and must be numbers, arrays, or references that contain numbers!is the second cell range of integers and must be numbers, arrays, or references that contain numbers x,known_y's,known_x's CRITBINOM This function is available for compatibility with Excel 2007 and earlier. Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value!is the number of Bernoulli trials!is the probability of success on each trial, a number between 0 and 1 inclusive!is the criterion value, a number between 0 and 1 inclusive number CUBEKPIMEMBER Returns a key performance indicator (KPI) property and displays the KPI name in the cell.!is the name of a connection to an OLAP cube!is the KPI name!is the KPI property!is the caption to be displayed in the cell connection,set_expression,caption,sort_order,sort_by CUBEMEMBERPROPERTY Returns the value of a member property from the cube.!is the name of a connection to an OLAP cube!is the expression representing the name of a member in the OLAP cube!is the property name connection,set_expression,rank,caption CUBEMEMBER Returns a member or tuple from the cube.!is the name of a connection to an OLAP cube!is the expression representing the name of a member or tuple in the OLAP cube!is the caption to be displayed in the cell connection,member_expression,property CUBERANKEDMEMBER Returns the nth, or ranked, member in a set.!is the name of a connection to an OLAP cube!is the set from which the element is to be retrieved!is the rank of the element to be retrieved!is the caption to be displayed in the cell number,places CUBESETCOUNT Returns the number of items in a set.!is the set whose elements are to be counted value,value_if_error CUBESET Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Excel.!is the name of a connection to an OLAP cube!is the expression for the set!is the caption to be displayed in the cell!is the sort order!is the sort by set CUBEVALUE Returns an aggregated value from the cube.!is the name of a connection to an OLAP cube!is a slicer that determines the portion of the OLAP cube for which the aggregated value is to be retrieved connection,member_expression,caption CUMIPMT Returns the cumulative interest paid between two periods!is the interest rate!is the total number of payment periods!is the present value!is the first period in the calculation!is the last period in the calculation!is the timing of the payment start_date,months CUMPRINC Returns the cumulative principal paid on a loan between two periods!is the interest rate!is the total number of payment periods!is the present value!is the first period in the calculation!is the last period in the calculation!is the timing of the payment rate,nper,pv,start_period,end_period,type DATEVALUE Converts a date in the form of text to a number that represents the date in Microsoft Excel date-time code!is text that represents a date in a Microsoft Excel date format, between 1/1/1900 (Windows) or 1/1/1904 (Macintosh) and 12/31/9999 time_text DATE Returns the relative position of an item in an array that matches a specified value in a specified order!is the value you use to find the value you want in the array, a number, text, or logical value, or a reference to one of these!is a contiguous range of cells containing possible lookup values, an array of values, or a reference to an array!is a number 1, 0, or -1 indicating which value to return. year,month,day DAVERAGE Averages the values in a column in a list or database that match conditions you specify!is the range of cells that makes up the list or database. A database is a list of related data!is either the label of the column in double quotation marks or a number that represents the column's position in the list!is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition database,field,criteria DAYS360 Returns the number of days between two dates based on a 360-day year (twelve 30-day months)!start_date and end_date are the two dates between which you want to know the number of days!start_date and end_date are the two dates between which you want to know the number of days!is a logical value specifying the calculation method: U.S. (NASD) = FALSE or omitted; European = TRUE. DAY Converts hours, minutes, and seconds given as numbers to an Excel serial number, formatted with a time format!is a number from 0 to 23 representing the hour!is a number from 0 to 59 representing the minute!is a number from 0 to 59 representing the second serial_number DBCS Changes half-width (single-byte) characters within a character string to full-width (double-byte) characters. Use with double-byte character sets (DBCS)!is a text, or a reference to a cell containing a text number,ref,order DB Returns the depreciation of an asset for a specified period using the fixed-declining balance method!is the initial cost of the asset!is the salvage value at the end of the life of the asset!is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset)!is the period for which you want to calculate the depreciation. Period must use the same units as Life!is the number of months in the first year. If month is omitted, it is assumed to be 12 no_tool DCOUNTA Counts nonblank cells in the field (column) of records in the database that match the conditions you specify!is the range of cells that makes up the list or database. A database is a list of related data!is either the label of the column in double quotation marks or a number that represents the column's position in the list!is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition bar_num DCOUNT Counts the cells containing numbers in the field (column) of records in the database that match the conditions you specify!is the range of cells that makes up the list or database. A database is a list of related data!is either the label of the column in double quotation marks or a number that represents the column's position in the list!is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition database,field,criteria DDB Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify!is the initial cost of the asset!is the salvage value at the end of the life of the asset!is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset)!is the period for which you want to calculate the depreciation. Period must use the same units as Life!is the rate at which the balance declines. If Factor is omitted, it is assumed to be 2 (the double-declining balance method) def_text,document_text,type_num DEC2BIN Converts a decimal number to binary!is the decimal integer you want to convert!is the number of characters to use number,places DEC2HEX Converts a decimal number to hexadecimal!is the decimal integer you want to convert!is the number of characters to use number,places DEC2OCT Converts a decimal number to octal!is the decimal integer you want to convert!is the number of characters to use number,places DEGREES Converts radians to degrees!is the angle in radians that you want to convert function_num,ref1,... DELTA Tests whether two numbers are equal!is the first number!is the second number number,step DEVSQ Returns the sum of squares of deviations of data points from their sample mean!are 1 to 255 arguments, or an array or array reference, on which you want DEVSQ to calculate number1,number2,... DGET Extracts from a database a single record that matches the conditions you specify!is the range of cells that makes up the list or database. A database is a list of related data!is either the label of the column in double quotation marks or a number that represents the column's position in the list!is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition obj_type, ref1, x_offset1, y_offset1, ref2, x_offset2, y_offset2, text, fill, editable!obj_type, ref1, x_offset1, y_offset1, ref2, x_offset2, y_offset2, array, fill!obj_type, ref1, x_offset1, y_offset1, ref2, x_offset2, y_offset2, xy_series, fill, gallery_num, type_num, plot_visible DISC Returns the discount rate for a security!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the security's price per $100 face value!is the security's redemption value per $100 face value!is the type of day count basis to use settlement,maturity,discount,redemption,basis DMAX Returns the largest number in the field (column) of records in the database that match the conditions you specify!is the range of cells that makes up the list or database. A database is a list of related data!is either the label of the column in double quotation marks or a number that represents the column's position in the list!is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition database,field,criteria DMIN Returns the smallest number in the field (column) of records in the database that match the conditions you specify!is the range of cells that makes up the list or database. A database is a list of related data!is either the label of the column in double quotation marks or a number that represents the column's position in the list!is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition database,field,criteria DOLLARDE Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number!is a number expressed as a fraction!is the integer to use in the denominator of the fraction decimal_dollar,fraction DOLLARFR Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction!is a decimal number!is the integer to use in the denominator of a fraction effect_rate,npery DOLLAR Converts a number to text, using currency format!is a number, a reference to a cell containing a number, or a formula that evaluates to a number!is the number of digits to the right of the decimal point. The number is rounded as necessary; if omitted, Decimals = 2 number,decimals,no_commas DPRODUCT Multiplies the values in the field (column) of records in the database that match the conditions you specify!is the range of cells that makes up the list or database. A database is a list of related data!is either the label of the column in double quotation marks or a number that represents the column's position in the list!is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition value DSTDEVP Calculates the standard deviation based on the entire population of selected database entries!is the range of cells that makes up the list or database. A database is a list of related data!is either the label of the column in double quotation marks or a number that represents the column's position in the list!is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition database,field,criteria DSTDEV Estimates the standard deviation based on a sample from selected database entries!is the range of cells that makes up the list or database. A database is a list of related data!is either the label of the column in double quotation marks or a number that represents the column's position in the list!is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition number1,number2,... DSUM Adds the numbers in the field (column) of records in the database that match the conditions you specify!is the range of cells that makes up the list or database. A database is a list of related data!is either the label of the column in double quotation marks or a number that represents the column's position in the list!is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition database,field,criteria DURATION Returns the annual duration of a security with periodic interest payments!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the security's annual coupon rate!is the security's annual yield!is the number of coupon payments per year!is the type of day count basis to use settlement,maturity,coupon,yld,frequency,basis DVARP Calculates variance based on the entire population of selected database entries!is the range of cells that makes up the list or database. A database is a list of related data!is either the label of the column in double quotation marks or a number that represents the column's position in the list!is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition number,num_digits DVAR Estimates variance based on a sample from selected database entries!is the range of cells that makes up the list or database. A database is a list of related data!is either the label of the column in double quotation marks or a number that represents the column's position in the list!is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition value,format_text EDATE Returns the serial number of the date that is the indicated number of months before or after the start date!is a serial date number that represents the start date!is the number of months before or after start_date start_date,months EFFECT Returns the effective annual interest rate!is the nominal interest rate!is the number of compounding periods per year rate,nper,pv,start_period,end_period,type EOMONTH Returns the serial number of the last day of the month before or after a specified number of months!is a serial date number that represents the start date!is the number of months before or after the start_date start_date,end_date,basis ERF.PRECISE Returns the error function!is the lower bound for integrating ERF.PRECISE X ERFC.PRECISE Returns the complementary error function!is the lower bound for integrating ERFC.PRECISE x ERFC Returns the complementary error function!is the lower bound for integrating ERF x,n ERF Returns the error function!is the lower bound for integrating ERF!is the upper bound for integrating ERF x EVEN Rounds a positive number up and negative number down to the nearest even integer!is the value to round x,lambda,cumulative EXACT Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive!is the first text string!is the second text string text EXPON.DIST Returns the exponential distribution!is the value of the function, a nonnegative number!is the parameter value, a positive number!is a logical value for the function to return: the cumulative distribution function = TRUE; the probability density function = FALSE x,alpha,beta,cumulative EXPONDIST This function is available for compatibility with Excel 2007 and earlier. Returns the exponential distribution!is the value of the function, a nonnegative number!is the parameter value, a positive number!is a logical value for the function to return: the cumulative distribution function = TRUE; the probability density function = FALSE x,deg_freedom1,deg_freedom2 EXP Returns e raised to the power of a given number!is the exponent applied to the base e. The constant e equals 2.71828182845904, the base of the natural logarithm number F.DIST.RT Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets!is the value at which to evaluate the function, a nonnegative number!is the numerator degrees of freedom, a number between 1 and 10^10, excluding 10^10!is the denominator degrees of freedom, a number between 1 and 10^10, excluding 10^10 probability,deg_freedom1,deg_freedom2 F.DIST Returns the (left-tailed) F probability distribution (degree of diversity) for two data sets!is the value at which to evaluate the function, a nonnegative number!is the numerator degrees of freedom, a number between 1 and 10^10, excluding 10^10!is the denominator degrees of freedom, a number between 1 and 10^10, excluding 10^10!is a logical value for the function to return: the cumulative distribution function = TRUE; the probability density function = FALSE x,deg_freedom1,deg_freedom2 F.INV.RT Returns the inverse of the (right-tailed) F probability distribution: if p = F.DIST.RT(x,...), then F.INV.RT(p,...) = x!is a probability associated with the F cumulative distribution, a number between 0 and 1 inclusive!is the numerator degrees of freedom, a number between 1 and 10^10, excluding 10^10!is the denominator degrees of freedom, a number between 1 and 10^10, excluding 10^10 sample_s,number_sample,population_s,number_pop,cumulative F.INV Returns the inverse of the (left-tailed) F probability distribution: if p = F.DIST(x,...), then F.INV(p,...) = x!is a probability associated with the F cumulative distribution, a number between 0 and 1 inclusive!is the numerator degrees of freedom, a number between 1 and 10^10, excluding 10^10!is the denominator degrees of freedom, a number between 1 and 10^10, excluding 10^10 probability,deg_freedom1,deg_freedom2 F.TEST Returns the result of an F-test, the two-tailed probability that the variances in Array1 and Array2 are not significantly different!is the first array or range of data and can be numbers or names, arrays, or references that contain numbers (blanks are ignored)!is the second array or range of data and can be numbers or names, arrays, or references that contain numbers (blanks are ignored) array1,array2 FACTDOUBLE Returns the double factorial of a number!is the value for which to return the double factorial number FACT Returns the factorial of a number, equal to 1*2*3*...* Number!is the nonnegative number you want the factorial of type_num,reference FALSE Returns the logical value FALSE logical1,logical2,... FDIST This function is available for compatibility with Excel 2007 and earlier. Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets!is the value at which to evaluate the function, a nonnegative number!is the numerator degrees of freedom, a number between 1 and 10^10, excluding 10^10!is the denominator degrees of freedom, a number between 1 and 10^10, excluding 10^10 probability,deg_freedom1,deg_freedom2 FINDB Finds the starting position of one text string within another text string. FINDB is case-sensitive. Use with double-byte character sets (DBCS)!is the text you want to find!is the text containing the text you want to find!specifies the character at which to start the search find_text,within_text,start_num FIND Returns the starting position of one text string within another text string. FIND is case-sensitive!is the text you want to find. Use double quotes (empty text) to match the first character in Within_text; wildcard characters not allowed!is the text containing the text you want to find!specifies the character at which to start the search. The first character in Within_text is character number 1. If omitted, Start_num = 1 info_type,reference FINV This function is available for compatibility with Excel 2007 and earlier. Returns the inverse of the (right-tailed) F probability distribution: if p = FDIST(x,...), then FINV(p,...) = x!is a probability associated with the F cumulative distribution, a number between 0 and 1 inclusive!is the numerator degrees of freedom, a number between 1 and 10^10, excluding 10^10!is the denominator degrees of freedom, a number between 1 and 10^10, excluding 10^10 x FISHERINV Returns the inverse of the Fisher transformation: if y = FISHER(x), then FISHERINV(y) = x!is the value for which you want to perform the inverse of the transformation number,significance FISHER Returns the Fisher transformation!is the value for which you want the transformation, a number between -1 and 1, excluding -1 and 1 y FIXED Rounds a number to the specified number of decimals and returns the result as text with or without commas!is the number you want to round and convert to text!is the number of digits to the right of the decimal point. If omitted, Decimals = 2!is a logical value: do not display commas in the returned text = TRUE; do display commas in the returned text = FALSE or omitted number FLOOR.PRECISE Rounds a number down, to the nearest integer or to the nearest multiple of significance!is the numeric value you want to round!is the multiple to which you want to round. FLOOR Rounds a number down to the nearest multiple of significance!is the numeric value you want to round!is the multiple to which you want to round. Number and Significance must either both be positive or both be negative x,alpha,beta,cumulative FORECAST Calculates, or predicts, a future value along a linear trend by using existing values!is the data point for which you want to predict a value and must be a numeric value!is the dependent array or range of numeric data!is the independent array or range of numeric data. The variance of Known_x's must not be zero array1,array2 FREQUENCY Calculates how often values occur within a range of values and then returns a vertical array of numbers having one more element than Bins_array!is an array of or reference to a set of values for which you want to count frequencies (blanks and text are ignored)!is an array of or reference to intervals into which you want to group the values in data_array bar_name,tool_ref FTEST This function is available for compatibility with Excel 2007 and earlier. Returns the result of an F-test, the two-tailed probability that the variances in Array1 and Array2 are not significantly different!is the first array or range of data and can be numbers or names, arrays, or references that contain numbers (blanks are ignored)!is the second array or range of data and can be numbers or names, arrays, or references that contain numbers (blanks are ignored) known_y's,known_x's FVSCHEDULE Returns the future value of an initial principal after applying a series of compound interest rates!is the present value!is an array of interest rates to apply connection,kpi_name,kpi_property,caption FV Returns the future value of an investment based on periodic, constant payments and a constant interest rate!is the interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR!is the total number of payment periods in the investment!is the payment made each period; it cannot change over the life of the investment!is the present value, or the lump-sum amount that a series of future payments is worth now. If omitted, Pv = 0!is a value representing the timing of payment: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted rate,pmt,pv,fv,type GAMMA.DIST Returns the gamma distribution!is the value at which you want to evaluate the distribution, a nonnegative number!is a parameter to the distribution, a positive number!is a parameter to the distribution, a positive number. If beta = 1, GAMMA.DIST returns the standard gamma distribution!is a logical value: return the cumulative distribution function = TRUE; return the probability mass function = FALSE or omitted probability,alpha,beta GAMMA.INV Returns the inverse of the gamma cumulative distribution: if p = GAMMA.DIST(x,...), then GAMMA.INV(p,...) = x!is the probability associated with the gamma distribution, a number between 0 and 1, inclusive!is a parameter to the distribution, a positive number!is a parameter to the distribution, a positive number. If beta = 1, GAMMA.INV returns the inverse of the standard gamma distribution number1,number2,... GAMMADIST This function is available for compatibility with Excel 2007 and earlier. Returns the gamma distribution!is the value at which you want to evaluate the distribution, a nonnegative number!is a parameter to the distribution, a positive number!is a parameter to the distribution, a positive number. If beta = 1, GAMMADIST returns the standard gamma distribution!is a logical value: return the cumulative distribution function = TRUE; return the probability mass function = FALSE or omitted probability,alpha,beta GAMMAINV This function is available for compatibility with Excel 2007 and earlier. Returns the inverse of the gamma cumulative distribution: if p = GAMMADIST(x,...), then GAMMAINV(p,...) = x!is the probability associated with the gamma distribution, a number between 0 and 1, inclusive!is a parameter to the distribution, a positive number!is a parameter to the distribution, a positive number. If beta = 1, GAMMAINV returns the inverse of the standard gamma distribution number,significance GAMMALN.PRECISE Returns the natural logarithm of the gamma function!is the value for which you want to calculate GAMMALN.PRECISE, a positive number number,significance GAMMALN Returns the natural logarithm of the gamma function!is the value for which you want to calculate GAMMALN, a positive number probability,alpha,beta,A,B GCD Returns the greatest common divisor!are 1 to 255 values number1,number2,... GEOMEAN Returns the geometric mean of an array or range of positive numeric data!are 1 to 255 numbers or names, arrays, or references that contain numbers for which you want the mean number1,number2,... GESTEP Tests whether a number is greater than a threshold value!is the value to test against step!is the threshold value number GETPIVOTDATA Extracts data stored in a PivotTable.!is the name of the data field to extract data from!is a reference to a cell or range of cells in the PivotTable that contains the data you want to retrieve!field to refer to!field item to refer to link_location,friendly_name GROWTH Returns numbers in an exponential growth trend matching known data points!is the set of y-values you already know in the relationship `y = b*m^x`, an array or range of positive numbers!is an optional set of x-values that you may already know in the relationship`y = b*m^x`, an array or range the same size as Known_y's!are new x-values for which you want GROWTH to return corresponding y-values!is a logical value: the constant b is calculated normally if Const = TRUE; b is set equal to 1 if Const = FALSE or omittedreference HARMEAN Returns the harmonic mean of a data set of positive numbers: the reciprocal of the arithmetic mean of reciprocals!are 1 to 255 numbers or names, arrays, or references that contain numbers for which you want the harmonic mean number1,number2,... HEX2BIN Converts a Hexadecimal number to binary!is the hexadecimal number you want to convert!is the number of characters to use number HEX2DEC Converts a hexadecimal number to decimal!is the hexadecimal number you want to convert number,places HEX2OCT Converts a hexadecimal number to octal!is the hexadecimal number you want to convert!is the number of characters to use number,places HLOOKUP Looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify!is the value to be found in the first row of the table and can be a value, a reference, or a text string!is a table of text, numbers, or logical values in which data is looked up. Table_array can be a reference to a range or a range name!is the row number in table_array from which the matching value should be returned. The first row of values in the table is row 1!is a logical value: to find the closest match in the top row (sorted in ascending order) = TRUE or omitted; find an exact match = FALSE lookup_value,table_array,col_index_num,range_lookup HOUR Returns a number from 1 to 7 identifying the day of the week of a date.!is a number that represents a date!is a number: for Sunday=1 through Saturday=7, use 1; for Monday=1 through Sunday=7, use 2; for Monday=0 through Sunday=6, use 3 serial_number HYPERLINK Creates a shortcut or jump that opens a document stored on your hard drive, a network server, or on the Internet!is the text giving the path and file name to the document to be opened, a hard drive location, UNC address, or URL path!is text or a number that is displayed in the cell. If omitted, the cell displays the Link_location text reference HYPGEOM.DIST Returns the hypergeometric distribution!is the number of successes in the sample!is the size of the sample!is the number of successes in the population!is the population size!is a logical value: for the cumulative distribution function, use TRUE; for the probability density function, use FALSE x,mean,standard_dev,cumulative HYPGEOMDIST This function is available for compatibility with Excel 2007 and earlier. Returns the hypergeometric distribution!is the number of successes in the sample!is the size of the sample!is the number of successes in the population!is the population size x,mean,standard_dev IFERROR Returns value_if_error if expression is an error and the value of the expression itself otherwise!is any value or expression or reference!is any value or expression or reference criteria_range,criteria,... IF Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE!is any value or expression that can be evaluated to TRUE or FALSE!is the value that is returned if Logical_test is TRUE. If omitted, TRUE is returned. You can nest up to seven IF functions!is the value that is returned if Logical_test is FALSE. If omitted, FALSE is returned value IMABS Returns the absolute value (modulus) of a complex number!is a complex number for which you want the absolute value inumber IMAGINARY Returns the imaginary coefficient of a complex number!is a complex number for which you want the imaginary coefficient inumber IMARGUMENT Returns the argument q, an angle expressed in radians!is a complex number for which you want the argument inumber IMCONJUGATE Returns the complex conjugate of a complex number!is a complex number for which you want the conjugate inumber IMCOS Returns the cosine of a complex number!is a complex number for which you want the cosine inumber IMDIV Returns the quotient of two complex numbers!is the complex numerator or dividend!is the complex denominator or divisor inumber,number IMEXP Returns the exponential of a complex number!is a complex number for which you want the exponential inumber IMLN Returns the natural logarithm of a complex number!is a complex number for which you want the natural logarithm inumber IMLOG10 Returns the base-10 logarithm of a complex number!is a complex number for which you want the common logarithm inumber IMLOG2 Returns the base-2 logarithm of a complex number!is a complex number for which you want the base-2 logarithm inumber IMPOWER Returns a complex number raised to an integer power!is a complex number you want to raise to a power!is the power to which you want to raise the complex number inumber IMPRODUCT Returns the product of 1 to 255 complex numbers!Inumber1, Inumber2,... are from 1 to 255 complex numbers to multiply. x,n,m,coefficients IMREAL Returns the real coefficient of a complex number!is a complex number for which you want the real coefficient real_num,i_num,suffix IMSIN Returns the sine of a complex number!is a complex number for which you want the sine inumber IMSQRT Returns the square root of a complex number!is a complex number for which you want the square root inumber IMSUB Returns the difference of two complex numbers!is the complex number from which to subtract inumber2!is the complex number to subtract from inumber1 inumber1,inumber2 IMSUM Returns the sum of complex numbers!are from 1 to 255 complex numbers to add inumber1,inumber2,... INDEX Returns a value or reference of the cell at the intersection of a particular row and column, in a given range!is a range of cells or an array constant.!selects the row in Array or Reference from which to return a value. If omitted, Column_num is required!selects the column in Array or Reference from which to return a value. If omitted, Row_num is required!is a reference to one or more cell ranges!selects the row in Array or Reference from which to return a value. If omitted, Column_num is required!selects the column in Array or Reference from which to return a value. If omitted, Row_num is required!selects a range in Reference from which to return a value. The first area selected or entered is area 1, the second area is area 2, and so on text,number_times INDIRECT Returns the reference specified by a text string!is a reference to a cell that contains an A1- or R1C1-style reference, a name defined as a reference, or a reference to a cell as a text string!is a logical value that specifies the type of reference in Ref_text: R1C1-style = FALSE; A1-style = TRUE or omitted module_text, procedure, type_text, function_text, argument_text, macro_type, category, shortcut_text, help_topic, function_help, argument_help1, ... INFO Returns information about the current operating environment!is text specifying what type of information you want returned. INTERCEPT Calculates the point at which a line will intersect the y-axis by using a best-fit regression line plotted through the known x-values and y-values!is the dependent set of observations or data and can be numbers or names, arrays, or references that contain numbers!is the independent set of observations or data and can be numbers or names, arrays, or references that contain numbers array1,array2 INTRATE Returns the interest rate for a fully invested security!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the amount invested in the security!is the amount to be received at maturity!is the type of day count basis to use settlement,maturity,investment,discount,basis INT Rounds a number down to the nearest integer!is the real number you want to round down to an integer number IPMT Returns the interest payment for a given period for an investment, based on periodic, constant payments and a constant interest rate!is the interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR!is the period for which you want to find the interest and must be in the range 1 to Nper!is the total number of payment periods in an investment!is the present value, or the lump-sum amount that a series of future payments is worth now!is the future value, or a cash balance you want to attain after the last payment is made. If omitted, Fv = 0!is a logical value representing the timing of payment: at the end of the period = 0 or omitted, at the beginning of the period = 1 rate,per,nper,pv,fv,type IRR Returns the internal rate of return for a series of periodic cash flows, considering both cost of investment and interest on reinvestment of cash!is an array or a reference to cells that contain numbers that represent a series of payments (negative) and income (positive) at regular periods!is the interest rate you pay on the money used in the cash flows!is the interest rate you receive on the cash flows as you reinvest them values,guess ISBLANK Checks whether a reference is to an empty cell, and returns TRUE or FALSE!is the cell or a name that refers to the cell you want to test value ISERROR Checks whether a value is an error (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value number1,number2,... ISERR Checks whether a value is an error (#VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) excluding #N/A, and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value value ISEVEN Returns TRUE if the number is even!is the value to test number ISLOGICAL Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value database,field,criteria ISNA Checks whether a value is #N/A, and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value value ISNONTEXT Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE!is the value you want tested: a cell; a formula; or a name referring to a cell, formula, or value cell_ref,start_char,num_chars ISNUMBER Checks whether a value is a number, and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value value ISODD Returns TRUE if the number is odd!is the value to test number,multiple ISPMT Returns the interest paid during a specific period of an investment!interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR!period for which you want to find the interest!number of payment periods in an investment!lump sum amount that a series of future payments is right now ISREF Checks whether a value is a reference, and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value reference ISTEXT Checks whether a value is text, and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value value ISTHAIDIGIT Returns TRUE if all characters are Thai digits!is text that you want to check number KURT Returns the kurtosis of a data set!are 1 to 255 numbers or names, arrays, or references that contain numbers for which you want the kurtosis number1,number2,... LARGE Returns the k-th largest value in a data set. For example, the fifth largest number!is the array or range of data for which you want to determine the k-th largest value!is the position (from the largest) in the array or cell range of the value to return array,k LCM Returns the least common multiple!are 1 to 255 values for which you want the least common multiple principal,schedule LEFTB Returns the specified number of characters from the start of a text string. Use with double-byte character sets (DBCS)!is the text string containing the characters you want to extract!specifies how many characters you want LEFT to return text,num_bytes LEFT Returns the specified number of characters from the start of a text string!is the text string containing the characters you want to extract!specifies how many characters you want LEFT to extract; 1 if omitted text,num_chars LENB Returns the number of characters in a text string. Use with double-byte character sets (DBCS)!is the text whose length you want to find number,num_digits LEN Returns the number of characters in a text string!is the text whose length you want to find. Spaces count as characters text LINEST Returns statistics that describe a linear trend matching known data points, by fitting a straight line using the least squares method!is the set of y-values you already know in the relationship y = mx + b!is an optional set of x-values that you may already know in the relationship y = mx + b!is a logical value: the constant b is calculated normally if Const = TRUE or omitted; b is set equal to 0 if Const = FALSE!is a logical value: return additional regression statistics = TRUE; return m-coefficients and the constant b = FALSE or omitted known_y's,known_x's,new_x's,const LN Returns the natural logarithm of a number!is the positive real number for which you want the natural logarithm number LOG10 Returns the base-10 logarithm of a number!is the positive real number for which you want the base-10 logarithm number LOGEST Returns statistics that describe an exponential curve matching known data points!is the set of y-values you already know in the relationship `y = b*m^x`!is an optional set of x-values that you may already know in the relationship`y = b*m^x`!is a logical value: the constant b is calculated normally if Const = TRUE or omitted; b is set equal to 1 if Const = FALSE!is a logical value: return additional regression statistics = TRUE; return m-coefficients and the constant b = FALSE or omittedknown_y's,known_x's,new_x's,const LOGINV This function is available for compatibility with Excel 2007 and earlier. Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev!is a probability associated with the lognormal distribution, a number between 0 and 1, inclusive!is the mean of ln(x)!is the standard deviation of ln(x), a positive number number_f,number_s,probability_s LOGNORM.DIST Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev!is the value at which to evaluate the function, a positive number!is the mean of ln(x)!is the standard deviation of ln(x), a positive number!is a logical value: for the cumulative distribution function, use TRUE; for the probability density function, use FALSE probability,mean,standard_dev LOGNORM.INV Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev!is a probability associated with the lognormal distribution, a number between 0 and 1, inclusive!is the mean of ln(x)!is the standard deviation of ln(x), a positive number number_f,number_s,probability_s,cumulative LOGNORMDIST This function is available for compatibility with Excel 2007 and earlier. Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev!is the value at which to evaluate the function, a positive number!is the mean of ln(x)!is the standard deviation of ln(x), a positive number probability,mean,standard_dev LOG Returns the logarithm of a number to the base you specify!is the positive real number for which you want the logarithm!is the base of the logarithm; 10 if omitted program_text,window_num LOOKUP Looks up a value either from a one-row or one-column range or from an array. Provided for backward compatibility!is a value that LOOKUP searches for in Lookup_vector and can be a number, text, a logical value, or a name or reference to a value!is a range that contains only one row or one column of text, numbers, or logical values, placed in ascending order!is a range that contains only one row or column, the same size as Lookup_vector!is a value that LOOKUP searches for in Array and can be a number, text, a logical value, or a name or reference to a value!is a range of cells that contain text, number, or logical values that you want to compare with Lookup_value array,row_num,column_num!reference,row_num,column_num,area_num LOWER Converts all letters in a text string to lowercase!is the text you want to convert to lowercase. Characters in Text that are not letters are not changed text MATCH Returns a random number greater than or equal to 0 and less than 1, evenly distributed (changes on recalculation) lookup_value,lookup_array,match_type MAXA Returns the largest value in a set of values. Does not ignore logical values and text!are 1 to 255 numbers, empty cells, logical values, or text numbers for which you want the maximum value1,value2,... MAX Returns the largest value in a set of values. Ignores logical values and text!are 1 to 255 numbers, empty cells, logical values, or text numbers for which you want the maximum reference MDETERM Returns the matrix determinant of an array!is a numeric array with an equal number of rows and columns, either a cell range or an array constant array MDURATION Returns the Macauley modified duration for a security with an assumed par value of $100!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the security's annual coupon rate!is the security's annual yield!is the number of coupon payments per year!is the type of day count basis to use settlement, maturity, last_interest, rate, yld, redemption, frequency, basis MEDIAN Returns the median, or the number in the middle of the set of given numbers!are 1 to 255 numbers or names, arrays, or references that contain numbers for which you want the median array1,array2,array3,... MIDB Returns characters from the middle of a text string, given a starting position and length. Use with double-byte character sets (DBCS)!is the text string containing the characters you want to extract!is the position of the first character you want to extract in text!specifies how many characters to return from text text MID Returns the characters from the middle of a text string, given a starting position and length!is the text string from which you want to extract the characters!is the position of the first character you want to extract. The first character in Text is 1!specifies how many characters to return from Text text MINA Returns the smallest value in a set of values. Does not ignore logical values and text!are 1 to 255 numbers, empty cells, logical values, or text numbers for which you want the minimum value1,value2,... MINUTE Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).!is a number in the date-time code used by Microsoft Excel, or text in time format, such as 16:48:00 or 4:48:00 PM serial_number MINVERSE Returns the inverse matrix for the matrix stored in an array!is a numeric array with an equal number of rows and columns, either a cell range or an array constant array1,array2 MIN Returns the smallest number in a set of values. Ignores logical values and text!are 1 to 255 numbers, empty cells, logical values, or text numbers for which you want the minimum number1,number2,... MIRR Returns the interest rate per period of a loan or an investment. For example, use 6%/4 for quarterly payments at 6% APR!is the total number of payment periods for the loan or investment!is the payment made each period and cannot change over the life of the loan or investment!is the present value: the total amount that a series of future payments is worth now!is the future value, or a cash balance you want to attain after the last payment is made. If omitted, uses Fv = 0!is a logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted!is your guess for what the rate will be; if omitted, Guess = 0.1 (10 percent) values,finance_rate,reinvest_rate MMULT Returns the matrix product of two arrays, an array with the same number of rows as array1 and columns as array2!is the first array of numbers to multiply and must have the same number of columns as Array2 has rows directory_text MODE.MULT Returns a vertical array of the most frequently occurring, or repetitive, values in an array or range of data. For a horizontal array, use =TRANSPOSE(MODE.MULT(number1,number2,...))!are 1 to 255 numbers, or names, arrays, or references that contain numbers for which you want the mode number1,number2,... MODE.SNGL Returns the most frequently occurring, or repetitive, value in an array or range of data!are 1 to 255 numbers, or names, arrays, or references that contain numbers for which you want the mode x,mean,standard_dev,cumulative MODE Returns the mean of the interior portion of a set of data values!is the range or array of values to trim and average!is the fractional number of data points to exclude from the top and bottom of the data set probability,deg_freedom MOD Returns the remainder after a number is divided by a divisor!is the number for which you want to find the remainder after the division is performed!is the number by which you want to divide Number database,field,criteria MONTH Returns the day of the month, a number from 1 to 31.!is a number in the date-time code used by Microsoft Excel serial_number MROUND Returns a number rounded to the desired multiple!is the value to round!is the multiple to which you want to round number lower_limit,upper_limit MULTINOMIAL Returns the multinomial of a set of numbers!are 1 to 255 values for which you want the multinomial number1,number2,... NA Returns the error value #N/A (value not available) rate,value1,value2,... NEGBINOM.DIST Returns the negative binomial distribution, the probability that there will be Number_f failures before the Number_s-th success, with Probability_s probability of a success!is the number of failures!is the threshold number of successes!is the probability of a success; a number between 0 and 1!is a logical value: for the cumulative distribution function, use TRUE; for the probability mass function, use FALSE z,cumulative NEGBINOMDIST This function is available for compatibility with Excel 2007 and earlier. Returns the negative binomial distribution, the probability that there will be Number_f failures before the Number_s-th success, with Probability_s probability of a success!is the number of failures!is the threshold number of successes!is the probability of a success; a number between 0 and 1 x,mean,standard_dev,cumulative NETWORKDAYS.INTL Returns the number of whole workdays between two dates with custom weekend parameters!is a serial date number that represents the start date!is a serial date number that represents the end date!is a number or string specifying when weekends occur!is an optional set of one or more serial date numbers to exclude from the working calendar, such as state and federal holidays and floating holidays start_date,days,weekend,holidays NETWORKDAYS Returns the number of whole workdays between two dates!is a serial date number that represents the start date!is a serial date number that represents the end date!is an optional set of one or more serial date numbers to exclude from the working calendar, such as state and federal holidays and floating holidays number1,number2,... NOMINAL Returns the annual nominal interest rate!is the effective interest rate!is the number of compounding periods per year nominal_rate,npery NORM.DIST Returns the normal distribution for the specified mean and standard deviation!is the value for which you want the distribution!is the arithmetic mean of the distribution!is the standard deviation of the distribution, a positive number!is a logical value: for the cumulative distribution function, use TRUE; for the probability density function, use FALSE probability,mean,standard_dev NORM.INV Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation!is a probability corresponding to the normal distribution, a number between 0 and 1 inclusive!is the arithmetic mean of the distribution!is the standard deviation of the distribution, a positive number array,k NORM.S.DIST Returns the standard normal distribution (has a mean of zero and a standard deviation of one)!is the value for which you want the distribution!is a logical value for the function to return: the cumulative distribution function = TRUE; the probability density function = FALSE probability NORM.S.INV Returns the inverse of the standard normal cumulative distribution (has a mean of zero and a standard deviation of one)!is a probability corresponding to the normal distribution, a number between 0 and 1 inclusive array1,array2,tails,type NORMDIST This function is available for compatibility with Excel 2007 and earlier. Returns the normal cumulative distribution for the specified mean and standard deviation!is the value for which you want the distribution!is the arithmetic mean of the distribution!is the standard deviation of the distribution, a positive number!is a logical value: for the cumulative distribution function, use TRUE; for the probability density function, use FALSE z NORMINV This function is available for compatibility with Excel 2007 and earlier. Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation!is a probability corresponding to the normal distribution, a number between 0 and 1 inclusive!is the arithmetic mean of the distribution!is the standard deviation of the distribution, a positive number probability NORMSDIST This function is available for compatibility with Excel 2007 and earlier. Returns the standard normal cumulative distribution (has a mean of zero and a standard deviation of one)!is the value for which you want the distribution probability,mean,standard_dev NORMSINV This function is available for compatibility with Excel 2007 and earlier. Returns the inverse of the standard normal cumulative distribution (has a mean of zero and a standard deviation of one)!is a probability corresponding to the normal distribution, a number between 0 and 1 inclusive x,mean,standard_dev NOT Changes FALSE to TRUE, or TRUE to FALSE!is a value or expression that can be evaluated to TRUE or FALSE number,divisor NOW Returns the second, a number from 0 to 59.!is a number in the date-time code used by Microsoft Excel or text in time format, such as 16:48:23 or 4:48:47 PM NPER Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate!is the interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR!is the payment made each period; it cannot change over the life of the investment!is the present value, or the lump-sum amount that a series of future payments is worth now!is the future value, or a cash balance you want to attain after the last payment is made. If omitted, zero is used!is a logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted rate,nper,pv,fv,type NPV Returns the net present value of an investment based on a discount rate and a series of future payments (negative values) and income (positive values)!is the rate of discount over the length of one period!are 1 to 254 payments and income, equally spaced in time and occurring at the end of each period number1,number2,... N Converts non-number value to a number, dates to serial numbers, TRUE to 1, anything else to 0 (zero)!is the value you want converted file_text,access_num OCT2BIN Converts an octal number to binary!is the octal number you want to convert!is the number of characters to use number,places OCT2DEC Converts an octal number to decimal!is the octal number you want to convert number OCT2HEX Converts an octal number to hexadecimal!is the octal number you want to convert!is the number of characters to use number ODDFPRICE Returns the price per $100 face value of a security with an odd first period!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the security's issue date, expressed as a serial date number!is the security's first coupon date, expressed as a serial date number!is the security's interest rate!is the security's annual yield!is the security's redemption value per $100 face value!is the number of coupon payments per year!is the type of day count basis to use settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, basis ODDFYIELD Returns the yield of a security with an odd first period!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the security's issue date, expressed as a serial date number!is the security's first coupon date, expressed as a serial date number!is the security's interest rate!is the security's price!is the security's redemption value per $100 face value!is the number of coupon payments per year!is the type of day count basis to use bottom,top ODDLPRICE Returns the price per $100 face value of a security with an odd last period!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the security's last coupon date, expressed as a serial date number!is the security's interest rate!is the security's annual yield!is the security's redemption value per $100 face value!is the number of coupon payments per year!is the type of day count basis to use settlement, maturity, last_interest, rate, pr, redemption, frequency, basis ODDLYIELD Returns the yield of a security with an odd last period!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the security's last coupon date, expressed as a serial date number!is the security's interest rate!is the security's price!is the security's redemption value per $100 face value!is the number of coupon payments per year!is the type of day count basis to use settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, basis ODD Rounds a positive number up and negative number down to the nearest odd integer!is the value to round number,number_chosen OFFSET Returns the number of columns in an array or reference!is an array or array formula, or a reference to a range of cells for which you want the number of columns reference,rows,cols,height,width OR Checks whether any of the arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments are FALSE!are 1 to 255 conditions that you want to test that can be either TRUE or FALSE logical PEARSON Returns the Pearson product moment correlation coefficient, r!is a set of independent values!is a set of dependent values known_y's,known_x's PERCENTILE.EXC Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive!is the array or range of data that defines relative standing!is the percentile value that is between 0 through 1, inclusive array,k PERCENTILE.INC Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive!is the array or range of data that defines relative standing!is the percentile value that is between 0 through 1, inclusive array,x,significance PERCENTILE This function is available for compatibility with Excel 2007 and earlier. Returns the k-th percentile of values in a range!is the array or range of data that defines relative standing!is the percentile value that is between 0 through 1, inclusive array,x,significance PERCENTRANK.EXC Returns the rank of a value in a data set as a percentage of the data set as a percentage (0..1, exclusive) of the data set!is the array or range of data with numeric values that defines relative standing!is the value for which you want to know the rank!is an optional value that identifies the number of significant digits for the returned percentage, three digits if omitted (0.xxx%) array,x,significance PERCENTRANK.INC Returns the rank of a value in a data set as a percentage of the data set as a percentage (0..1, inclusive) of the data set!is the array or range of data with numeric values that defines relative standing!is the value for which you want to know the rank!is an optional value that identifies the number of significant digits for the returned percentage, three digits if omitted (0.xxx%) x,mean,cumulative PERCENT This function is available for compatibility with Excel 2007 and earlier. Returns the rank of a value in a data set as a percentage of the data set!is the array or range of data with numeric values that defines relative standing!is the value for which you want to know the rank!is an optional value that identifies the number of significant digits for the returned percentage, three digits if omitted (0.xxx%) number1,number2,... PERMUT Returns the number of permutations for a given number of objects that can be selected from the total objects!is the total number of objects!is the number of objects in each permutation x,mean,cumulative PHONETIC Get phonetic string!is a reference to a cell containing a phonetic string value1,value2,... PI Returns the value of Pi, 3.14159265358979, accurate to 15 digits number PMTRATE Calculates the payment for a loan based on constant payments and a constant interest rate!is the interest rate per period for the loan. For example, use 6%/4 for quarterly payments at 6% APR!is the total number of payments for the loan!is the present value: the total amount that a series of future payments is worth now!is the future value, or a cash balance you want to attain after the last payment is made, 0 (zero) if omitted!is a logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted nper,pmt,pv,fv,type,guess POISSON.DIST Returns the Poisson distribution!is the number of events!is the expected numeric value, a positive number!is a logical value: for the cumulative Poisson probability, use TRUE; for the Poisson probability mass function, use FALSE array,quart POISSON This function is available for compatibility with Excel 2007 and earlier. Returns the Poisson distribution!is the number of events!is the expected numeric value, a positive number!is a logical value: for the cumulative Poisson probability, use TRUE; for the Poisson probability mass function, use FALSE x,deg_freedom,tails POWER Returns the result of a number raised to a power!is the base number, any real number!is the exponent, to which the base number is raised name, pivot_field_name, new_name, position, function, calculation, base_field, base_item, format_text PPMT Returns the payment on the principal for a given investment based on periodic, constant payments and a constant interest rate!is the interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR!specifies the period and must be in the range 1 to nper!is the total number of payment periods in an investment!is the present value: the total amount that a series of future payments is worth now!is the future value, or cash balance you want to attain after the last payment is made!is a logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted value1,value2,... PRICEDISC Returns the price per $100 face value of a discounted security!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the security's discount rate!is the security's redemption value per $100 face value!is the type of day count basis to use settlement,maturity,pr,redemption,basis PRICEMAT Returns the price per $100 face value of a security that pays interest at maturity!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the security's issue date, expressed as a serial date number!is the security's interest rate at date of issue!is the security's annual yield!is the type of day count basis to use settlement,maturity,issue,rate,pr,basis PRICE Returns the price per $100 face value of a security that pays periodic interest!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the security's annual coupon rate!is the security's annual yield!is the security's redemption value per $100 face value!is the number of coupon payments per year!is the type of day count basis to use settlement,maturity,rate,pr,redemption,frequency,basis PROB Returns the probability that values in a range are between two limits or equal to a lower limit!is the range of numeric values of x with which there are associated probabilities!is the set of probabilities associated with values in X_range, values between 0 and 1 and excluding 0!is the lower bound on the value for which you want a probability!is the optional upper bound on the value. If omitted, PROB returns the probability that X_range values are equal to Lower_limit number1,number2,... PRODUCT Multiplies all the numbers given as arguments!are 1 to 255 numbers, logical values, or text representations of numbers that you want to multiply number PROPER Converts a text string to proper case; the first letter in each word in uppercase, and all other letters to lowercase!is text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing text to partially capitalize text,num_chars PV Returns the present value of an investment: the total amount that a series of future payments is worth now!is the interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR!is the total number of payment periods in an investment!is the payment made each period and cannot change over the life of the investment!is the future value, or a cash balance you want to attain after the last payment is made!is a logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted rate,nper,pmt,pv,type QUARTILE.EXC Returns the quartile of a data set, based on percentile values from 0..1, exclusive!is the array or cell range of numeric values for which you want the quartile value!is a number: minimum value = 0; 1st quartile = 1; median value = 2; 3rd quartile = 3; maximum value = 4 array,quart QUARTILE.INC Returns the quartile of a data set, based on percentile values from 0..1, inclusive!is the array or cell range of numeric values for which you want the quartile value!is a number: minimum value = 0; 1st quartile = 1; median value = 2; 3rd quartile = 3; maximum value = 4 number,ref,order QUARTILE This function is available for compatibility with Excel 2007 and earlier. Returns the quartile of a data set!is the array or cell range of numeric values for which you want the quartile value!is a number: minimum value = 0; 1st quartile = 1; median value = 2; 3rd quartile = 3; maximum value = 4 array,k QUOTIENT Returns the integer portion of a division!is the dividend!is the divisor number1,number2 RADIANS Converts degrees to radians!is an angle in degrees that you want to convert angle RANDBETWEEN Returns a random number between the numbers you specify!is the smallest integer RANDBETWEEN will return!is the largest integer RANDBETWEEN will return serial_number,return_type RAND Returns the internal rate of return for a series of cash flows!is an array or a reference to cells that contain numbers for which you want to calculate the internal rate of return!is a number that you guess is close to the result of IRR; 0.1 (10 percent) if omitted bottom,top RANK.AVG Returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the average rank is returned!is the number for which you want to find the rank!is an array of, or a reference to, a list of numbers. Nonnumeric values are ignored!is a number: rank in the list sorted descending = 0 or omitted; rank in the list sorted ascending = any nonzero value number,ref,order RANK.EQ Returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the top rank of that set of values is returned!is the number for which you want to find the rank!is an array of, or a reference to, a list of numbers. Nonnumeric values are ignored!is a number: rank in the list sorted descending = 0 or omitted; rank in the list sorted ascending = any nonzero value number1,number2,... RANK This function is available for compatibility with Excel 2007 and earlier. Returns the most frequently occurring, or repetitive, value in an array or range of data!are 1 to 255 numbers, or names, arrays, or references that contain numbers for which you want the mode array,percent RANK This function is available for compatibility with Excel 2007 and earlier.!Returns the rank of a number in a list of numbers: its size relative to other values in the list!is the number for which you want to find the rank!is an array of, or a reference to, a list of numbers. Nonnumeric values are ignored!is a number: rank in the list sorted descending = 0 or omitted; rank in the list sorted ascending = any nonzero value row_num,column_num,abs_num,a1,sheet_text RECEIVED Returns the amount received at maturity for a fully invested security!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the amount invested in the security!is the security's discount rate!is the type of day count basis to use settlement,maturity,pr,redemption,basis REPLACEB Replaces part of a text string with a different text string. Use with double-byte character sets (DBCS)!is text in which you want to replace some characters!is the position of the character in old_text that you want to replace with new_text!is the number of characters in old_text that you want to replace with new_text!is the text that will replace characters in old_text text,num_bytes REPLACE Replaces part of a text string with a different text string!is text in which you want to replace some characters!is the position of the character in Old_text that you want to replace with New_text!is the number of characters in Old_text that you want to replace!is the text that will replace characters in Old_text text,old_text,new_text,instance_num REPT Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string!is the text you want to repeat!is a positive number specifying the number of times to repeat text text,start_num,num_chars RIGHTB Returns the specified number of characters from the end of a text string. Use with double-byte character sets (DBCS)!is the text string containing the characters you want to extract!specifies how many characters you want to extract text,start_num,num_bytes RIGHT Returns the specified number of characters from the end of a text string!is the text string that contains the characters you want to extract!specifies how many characters you want to extract, 1 if omitted text1,text2 ROMAN Converts an Arabic numeral to Roman, as text!is the Arabic numeral you want to convert!is the number specifying the type of Roman numeral you want. file_filter,button_text,title,filter_index ROUNDBAHTDOWN Returns the floor of value (in Thai currency unit)!is a number that you want to convert number ROUNDBAHTUP Returns the ceiling of value (in Thai currency unit)!is a number that you want to convert number ROUNDDOWN Rounds a number down, toward zero!is any real number that you want rounded down!is the number of digits to which you want to round. Negative rounds to the left of the decimal point; zero or omitted, to the nearest integer text ROUNDUP Rounds a number up, away from zero!is any real number that you want rounded up!is the number of digits to which you want to round. Negative rounds to the left of the decimal point; zero or omitted, to the nearest integer number,num_digits ROUND Rounds a number to a specified number of digits!is the number you want to round!is the number of digits to which you want to round. Negative rounds to the left of the decimal point; zero to the nearest integer lookup_value,lookup_vector,result_vector!lookup_value,array ROWS Returns the number of areas in a reference. An area is a range of contiguous cells or a single cell!is a reference to a cell or range of cells and can refer to multiple areas array ROW Returns the row number of a reference!is the cell or a single range of cells for which you want the row number; if omitted, returns the cell containing the ROW function reference RSQ Returns the square of the Pearson product moment correlation coefficient through the given data points!is an array or range of data points and can be numbers or names, arrays, or references that contain numbers!is an array or range of data points and can be numbers or names, arrays, or references that contain numbers known_y's,known_x's RTD Retrieves real-time data from a program that supports COM automation!is the name of the ProgID of a registered COM automation add-in. Enclose the name in quotation marks!is the name of the server where the add-in should be run. Enclose the name in quotation marks. If the add-in is run locally, use an empty string!are 1 to 38 parameters that specify a piece of data connection,member_expression1,... SEARCHB Returns the number of the character at which a specific character or text string is first found, reading left to right (not case-sensitive). Use with double-byte character sets (DBCS)!is the text you want to find!is the text in which you want to search for find_text!is the character number in within_text, counting from the left, at which you want to start searching old_text,start_num,num_bytes,new_text SEARCH Returns the number of the character at which a specific character or text string is first found, reading left to right (not case-sensitive)!is the text you want to find. You can use the ? and * wildcard characters; use ~? and ~* to find the ? and * characters!is the text in which you want to search for Find_text!is the character number in Within_text, counting from the left, at which you want to start searching. If omitted, 1 is used array SECOND Returns the minute, a number from 0 to 59.!is a number in the date-time code used by Microsoft Excel or text in time format, such as 16:48:00 or 4:48:00 PM serial_number SERIESSUM Returns the sum of a power series based on the formula!is the input value to the power series!is the initial power to which you want to raise x!is the step by which to increase n for each term in the series!is a set of coefficients by which each successive power of x is multiplied number SIGN Returns the sign of a number: 1 if the number is positive, zero if the number is zero, or -1 if the number is negative!is any real number number,num_digits SINH Returns the hyperbolic sine of a number!is any real number number SIN Returns the sine of an angle!is the angle in radians for which you want the sine. Degrees * PI()/180 = radians number SKEW Returns the skewness of a distribution: a characterization of the degree of asymmetry of a distribution around its mean!are 1 to 255 numbers or names, arrays, or references that contain numbers for which you want the skewness array,x,sigma SLN Returns the straight-line depreciation of an asset for one period!is the initial cost of the asset!is the salvage value at the end of the life of the asset!is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset) cost,salvage,life,per SLOPE Returns the slope of the linear regression line through the given data points!is an array or cell range of numeric dependent data points and can be numbers or names, arrays, or references that contain numbers!is the set of independent data points and can be numbers or names, arrays, or references that contain numbers array1,array2,tails,type SMALL Returns the k-th smallest value in a data set. For example, the fifth smallest number!is an array or range of numerical data for which you want to determine the k-th smallest value!is the position (from the smallest) in the array or range of the value to return array,quart SQRTPI Returns the square root of (number * Pi)!is the number by which p is multiplied numerator,denominator SQRT Returns the square root of a number!is the number for which you want the square root number STANDARDIZE Returns a normalized value from a distribution characterized by a mean and standard deviation!is the value you want to normalize!is the arithmetic mean of the distribution!is the standard deviation of the distribution, a positive number number STDEV.P Calculates standard deviation based on the entire population given as arguments (ignores logical values and text)!are 1 to 255 numbers corresponding to a population and can be numbers or references that contain numbers! RNx"$%&'t(t)!x,deg_freedom,cumulative STDEV.S Estimates standard deviation based on a sample (ignores logical values and text in the sample)!are 1 to 255 numbers corresponding to a sample of a population and can be numbers or references that contain numbers number1,number2,... STDEVA Estimates standard deviation based on a sample, including logical values and text. Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1!are 1 to 255 values corresponding to a sample of a population and can be values or names or references to values value1,value2,... STDEVPA Calculates standard deviation based on an entire population, including logical values and text. Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1!are 1 to 255 values corresponding to a population and can be values, names, arrays, or references that contain values value1,value2,... STDEVP This function is available for compatibility with Excel 2007 and earlier.!Calculates standard deviation based on the entire population given as arguments (ignores logical values and text)!are 1 to 255 numbers corresponding to a population and can be numbers or references that contain numbers number1,number2,... STDEV This function is available for compatibility with Excel 2007 and earlier.!Estimates standard deviation based on a sample (ignores logical values and text in the sample)!are 1 to 255 numbers corresponding to a sample of a population and can be numbers or references that contain numbers number,decimals STEYX Returns the standard error of the predicted y-value for each x in a regression!is an array or range of dependent data points and can be numbers or names, arrays, or references that contain numbers!is an array or range of independent data points and can be numbers or names, arrays, or references that contain numbers known_y's,known_x's SUBSTITUTE Replaces existing text with new text in a text string!is the text or the reference to a cell containing text in which you want to substitute characters!is the existing text you want to replace. If the case of Old_text does not match the case of text, SUBSTITUTE will not replace the text!is the text you want to replace Old_text with!specifies which occurrence of Old_text you want to replace. If omitted, every instance of Old_text is replaced text SUBTOTAL Returns a subtotal in a list or database!is the number 1 to 11 that specifies the summary function for the subtotal.!are 1 to 254 ranges or references for which you want the subtotal range,criteria,sum_range SUMIFS Adds the cells specified by a given set of conditions or criteria!are the actual cells to sum.!is the range of cells you want evaluated for the particular condition!is the condition or criteria in the form of a number, expression, or text that defines which cells will be added range,criteria,average_range SUMIF Adds the cells specified by a given condition or criteria!is the range of cells you want evaluated!is the condition or criteria in the form of a number, expression, or text that defines which cells will be added!are the actual cells to sum. If omitted, the cells in range are used range,criteria SUMPRODUCT Returns the sum of the products of corresponding ranges or arrays!are 2 to 255 arrays for which you want to multiply and then add components. All arrays must have the same dimensions number SUMSQ Returns the sum of the squares of the arguments. The arguments can be numbers, arrays, names, or references to cells that contain numbers!are 1 to 255 numbers, arrays, names, or references to arrays for which you want the sum of the squares number1,number2,... SUMX2MY2 Sums the differences between the squares of two corresponding ranges or arrays!is the first range or array of numbers and can be a number or name, array, or reference that contains numbers!is the second range or array of numbers and can be a number or name, array, or reference that contains numbers array_x,array_y SUMX2PY2 Returns the sum total of the sums of squares of numbers in two corresponding ranges or arrays!is the first range or array of numbers and can be a number or name, array, or reference that contains numbers!is the second range or array of numbers and can be a number or name, array, or reference that contains numbers actual_range,expected_range SUMXMY2 Sums the squares of the differences in two corresponding ranges or arrays!is the first range or array of values and can be a number or name, array, or reference that contains numbers!is the second range or array of values and can be a number or name, array, or reference that contains numbers array_x,array_y SUM Adds all the numbers in a range of cells!are 1 to 255 numbers to sum. Logical values and text are ignored in cells, included if typed as arguments number1,number2,... SYD Returns the sum-of-years' digits depreciation of an asset for a specified period!is the initial cost of the asset!is the salvage value at the end of the life of the asset!is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset)!is the period and must use the same units as Life cost,salvage,life,period,factor T.DIST.2T Returns the two-tailed Student's t-distribution!is the numeric value at which to evaluate the distribution!is an integer indicating the number of degrees of freedom that characterize the distribution x,deg_freedom T.DIST.RT Returns the right-tailed Student's t-distribution!is the numeric value at which to evaluate the distribution!is an integer indicating the number of degrees of freedom that characterize the distribution probability,deg_freedom T.DIST Returns the left-tailed Student's t-distribution!is the numeric value at which to evaluate the distribution!is an integer indicating the number of degrees of freedom that characterize the distribution!is a logical value: for the cumulative distribution function, use TRUE; for the probability density function, use FALSE x,deg_freedom T.INV.2T Returns the two-tailed inverse of the Student's t-distribution!is the probability associated with the two-tailed Student's t-distribution, a number between 0 and 1 inclusive!is a positive integer indicating the number of degrees of freedom to characterize the distribution number1,number2,... T.INV Returns the left-tailed inverse of the Student's t-distribution!is the probability associated with the two-tailed Student's t-distribution, a number between 0 and 1 inclusive!is a positive integer indicating the number of degrees of freedom to characterize the distribution probability,deg_freedom T.TEST Returns the probability associated with a Student's t-Test!is the first data set!is the second data set!specifies the number of distribution tails to return: one-tailed distribution = 1; two-tailed distribution = 2!is the kind of t-test: paired = 1, two-sample equal variance (homoscedastic) = 2, two-sample unequal variance = 3 array,x,sigma TANH Returns the hyperbolic tangent of a number!is any real number number TAN Returns the tangent of an angle!is the angle in radians for which you want the tangent. Degrees * PI()/180 = radians number TBILLEQ Returns the bond-equivalent yield for a treasury bill!is the Treasury bill's settlement date, expressed as a serial date number!is the Treasury bill's maturity date, expressed as a serial date number!is the Treasury bill's discount rate settlement,maturity,discount TBILLPRICE Returns the price per $100 face value for a treasury bill!is the Treasury bill's settlement date, expressed as a serial date number!is the Treasury bill's maturity date, expressed as a serial date number!is the Treasury bill's discount rate settlement,maturity,pr TBILLYIELD Returns the yield for a treasury bill!is the Treasury bill's settlement date, expressed as a serial date number!is the Treasury bill's maturity date, expressed as a serial date number!is the Treasury Bill's price per $100 face value settlement,maturity,rate,yld,redemption,frequency,basis TDIST This function is available for compatibility with Excel 2007 and earlier. Returns the Student's t-distribution!is the numeric value at which to evaluate the distribution!is an integer indicating the number of degrees of freedom that characterize the distribution!specifies the number of distribution tails to return: one-tailed distribution = 1; two-tailed distribution = 2 x,alpha,beta,cumulative TEXT Converts a value to text in a specific number format!is a number, a formula that evaluates to a numeric value, or a reference to a cell containing a numeric value!is a number format in text form from the Category box on the Number tab in the Format Cells dialog box (not General) known_y's,known_x's,const,stats THAIDAYOFWEEK Returns the day of week in Thai!is a number specify date which you want to convert number THAIDIGIT Converts a number to Thai digit text!is a number that you want to convert number THAIMONTHOFYEAR Returns the month of year in Thai!is a number specifying the month number THAINUMSOUND Converts a number to text!is a number that you want to convert number THAINUMSTRING Converts a number to text!is a number that you want to convert text THAISTRINGLENGTH Returns the number of Thai characters!is text that you want to count text THAIYEAR Returns the Thai year!is a number progID,server,topic1,topic2,... TIMEVALUE Converts a text time to an Excel serial number for a time, a number from 0 (12:00:00 AM) to 0.999988426 (11:59:59 PM). Format the number with a time format after entering the formula!is a text string that gives a time in any one of the Microsoft Excel time formats (date information in the string is ignored) cost,salvage,life TIME Returns the number that represents the date in Microsoft Excel date-time code!is a number from 1900 to 9999 in Microsoft Excel for Windows or from 1904 to 9999 in Microsoft Excel for the Macintosh!is a number from 1 to 12 representing the month of the year!is a number from 1 to 31 representing the day of the month hour,minute,second TINV object_id_text,command_num,format TODAY Returns the current date formatted as a date. cost,salvage,life,start_period,end_period,factor,no_switch TRANSPOSE Converts a vertical range of cells to a horizontal range, or vice versa!is a range of cells on a worksheet or an array of values that you want to transpose enable_logical,macro_ref TREND Returns numbers in a linear trend matching known data points, using the least squares method!is a range or array of y-values you already know in the relationship y = mx + b!is an optional range or array of x-values that you know in the relationship y = mx + b, an array the same size as Known_y's!is a range or array of new x-values for which you want TREND to return corresponding y-values!is a logical value: the constant b is calculated normally if Const = TRUE or omitted; b is set equal to 0 if Const = FALSE known_y's,known_x's,const,stats TRIMMEAN This function is available for compatibility with Excel 2007 and earlier. Returns the two-tailed inverse of the Student's t-distribution!is the probability associated with the two-tailed Student's t-distribution, a number between 0 and 1 inclusive!is a positive integer indicating the number of degrees of freedom to characterize the distribution object_id_text,command_num,param1,units TRIM Removes all spaces from a text string except for single spaces between words!is the text from which you want spaces removed old_text,start_num,num_chars,new_text TRUE Returns the logical value TRUE TRUNC Truncates a number to an integer by removing the decimal, or fractional, part of the number!is the number you want to truncate!is a number specifying the precision of the truncation, 0 (zero) if omitted value TTEST This function is available for compatibility with Excel 2007 and earlier. Returns the probability associated with a Student's t-Test!is the first data set!is the second data set!specifies the number of distribution tails to return: one-tailed distribution = 1; two-tailed distribution = 2!is the kind of t-test: paired = 1, two-sample equal variance (homoscedastic) = 2, two-sample unequal variance = 3 x_range,prob_range,lower_limit,upper_limit TYPE Returns an integer representing the data type of a value: number = 1; text = 2; logical value = 4; error value = 16; array = 64!can be any value logical T Checks whether a value is text, and returns the text if it is, or returns double quotes (empty text) if it is not!is the value to test value UPPER Converts a text string to all uppercase letters!is the text you want converted to uppercase, a reference or a text string text USDOLLAR Converts a number to text, using currency format!is a number, a reference to a cell containing a number, or a formula that evaluates to a number!is the number of digits to the right of the decimal point find_text,within_text,start_num VALUE Converts a text string that represents a number to a number!is the text enclosed in quotation marks or a reference to a cell containing the text you want to convert VAR.P Calculates variance based on the entire population (ignores logical values and text in the population)!are 1 to 255 numeric arguments corresponding to a population x,alpha,beta,cumulative VAR.S Estimates variance based on a sample (ignores logical values and text in the sample)!are 1 to 255 numeric arguments corresponding to a sample of a population number1,number2,... VARA Estimates variance based on a sample, including logical values and text. Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1!are 1 to 255 value arguments corresponding to a sample of a population number VARPA Calculates variance based on the entire population, including logical values and text. Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1!are 1 to 255 value arguments corresponding to a population value1,value2,... VARP This function is available for compatibility with Excel 2007 and earlier.!Calculates variance based on the entire population (ignores logical values and text in the population)!are 1 to 255 numeric arguments corresponding to a population database,field,criteria VAR This function is available for compatibility with Excel 2007 and earlier.!Estimates variance based on a sample (ignores logical values and text in the sample)!are 1 to 255 numeric arguments corresponding to a sample of a population database,field,criteria VDB Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify!is the initial cost of the asset!is the salvage value at the end of the life of the asset!is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset)!is the starting period for which you want to calculate the depreciation, in the same units as Life!is the ending period for which you want to calculate the depreciation, in the same units as Life!is the rate at which the balance declines, 2 (double-declining balance) if omitted!switch to straight-line depreciation when depreciation is greater than the declining balance = FALSE or omitted; do not switch = TRUE VLOOKUP Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. By default, the table must be sorted in an ascending order!is the value to be found in the first column of the table, and can be a value, a reference, or a text string!is a table of text, numbers, or logical values, in which data is retrieved. Table_array can be a reference to a range or a range name!is the column number in table_array from which the matching value should be returned. The first column of values in the table is column 1!is a logical value: to find the closest match in the first column (sorted in ascending order) = TRUE or omitted; find an exact match = FALSE document_text,type_num WEEKDAY Returns the year of a date, an integer in the range 1900 - 9999.!is a number in the date-time code used by Microsoft Excel serial_number,return_type WEEKNUM Returns the week number in the year!is the date-time code used by Microsoft Excel for date and time calculation!is a number (1 or 2) that determines the type of the return value cost,date_purchased,first_period,salvage,period,rate,basis WEIBULL.DIST Returns the Weibull distribution!is the value at which to evaluate the function, a nonnegative number!is a parameter to the distribution, a positive number!is a parameter to the distribution, a positive number!is a logical value: for the cumulative distribution function, use TRUE; for the probability mass function, use FALSE start_date,end_date,weekend,holidays WEIBULL This function is available for compatibility with Excel 2007 and earlier. Returns the Weibull distribution!is the value at which to evaluate the function, a nonnegative number!is a parameter to the distribution, a positive number!is a parameter to the distribution, a positive number!is a logical value: for the cumulative distribution function, use TRUE; for the probability mass function, use FALSE array_x,array_y WORKDAY.INTL Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters!is a serial date number that represents the start date!is the number of nonweekend and non-holiday days before or after start_date!is a number or string specifying when weekends occur!is an optional array of one or more serial date numbers to exclude from the working calendar, such as state and federal holidays and floating holidays number,significance WORKDAY Returns the serial number of the date before or after a specified number of workdays!is a serial date number that represents the start date!is the number of nonweekend and non-holiday days before or after start_date!is an optional array of one or more serial date numbers to exclude from the working calendar, such as state and federal holidays and floating holidays start_date,end_date,holidays XIRR Returns the internal rate of return for a schedule of cash flows!is a series of cash flows that correspond to a schedule of payments in dates!is a schedule of payment dates that corresponds to the cash flow payments!is a number that you guess is close to the result of XIRR rate,values,dates XNPV Returns the net present value for a schedule of cash flows!is the discount rate to apply to the cash flows!is a series of cash flows that correspond to a schedule of payments in dates!is a schedule of payment dates that corresponds to the cash flow payments settlement,maturity,issue,rate,yld,basis YEARFRAC Returns the year fraction representing the number of whole days between start_date and end_date!is a serial date number that represents the start date!is a serial date number that represents the end date!is the type of day count basis to use settlement,maturity,frequency,basis YEAR Returns the month, a number from 1 (January) to 12 (December).!is a number in the date-time code used by Microsoft Excel serial_number YIELDDISC Returns the annual yield for a discounted security. For example, a treasury bill!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the security's price per $100 face value!is the security's redemption value per $100 face value!is the type of day count basis to use settlement,maturity,discount YIELDMAT Returns the annual yield of a security that pays interest at maturity!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the security's issue date, expressed as a serial date number!is the security's interest rate at date of issue!is the security's price per $100 face value!is the type of day count basis to use settlement,maturity,investment,redemption,basis YIELD Returns the yield on a security that pays periodic interest!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the security's annual coupon rate!is the security's price per $100 face value!is the security's redemption value per $100 face value!is the number of coupon payments per year!is the type of day count basis to use fractional_dollar,fraction Z.TEST Returns the one-tailed P-value of a z-test!is the array or range of data against which to test X!is the value to test!is the population (known) standard deviation. If omitted, the sample standard deviation is used X ZTEST This function is available for compatibility with Excel 2007 and earlier. Returns the one-tailed P-value of a z-test!is the array or range of data against which to test X!is the value to test!is the population (known) standard deviation. If omitted, the sample standard deviation is used array,k *ABSREF Returns a reference to a range that is a given number of rows and columns from a given reference!is the reference from which you want to base the offset, a reference to a cell or range of adjacent cells!is the number of rows, up or down, that you want the upper-left cell of the result to refer to!is the number of columns, to the left or right, that you want the upper-left cell of the result to refer to!is the height, in number of rows, that you want the result to be, the same height as Reference if omitted!is the width, in number of columns, that you want the result to be, the same width as Reference if omitted ref_text,reference *ACTIVE.CELLS *ADD.BAR bar_num,menu_ref,position1,position2 *ADD.COMMAND bar_num,menu,command,enable,subcommand *ADD.MENU bar_num,menu,command_ref,position1,position2 *ADD.TOOLBAR bar_name!bar_id *APP.TITLE bar_id,filename *ARGUMENT name_text,data_type_num!name_text,data_type_num,reference *BREAK *CALLER reference *CALL Calls a procedure in a dynamic link library or code resource!is the value returned by a previously executed REGISTER or REGISTER.ID function!are the arguments to be passed to the procedure!is quoted text specifying the name of the dynamic link library (DLL) that contains the procedure in Microsoft Excel for Windows!is text specifying the name of the function in the DLL (in Microsoft Excel for Windows)!is text specifying the data types of the return value and of all arguments to the DLL or code resource. bar_num *CANCEL.KEY counter_text,start_num,end_num,step_num *CHECK.COMMAND bar_num,menu,command,name_text,position *CREATE.OBJECT logical *CUSTOM.REPEAT formula_text,from_a1,to_a1,to_ref_type,rel_to_ref *CUSTOM.UNDO macro_text,repeat_text,record_text *DATEDIF *DATESTRING *DELETE.BAR register_id!module_text *DELETE.COMMAND x_y_index,point_index,item_text *DELETE.MENU bar_num,menu,command,subcommand *DELETE.TOOLBAR formula_text *DEREF type_num,match_text *DIALOG.BOX text *DIRECTORY find_text,within_text,start_num *DOCUMENTS *ECHO name_text,value *ECMA.CEILING Rounds a number up, to the nearest multiple of significance!is the value you want to round!is the multiple to which you want to round number,significance *ELECTIONRESULT type_num *ELSE.IF *ELSE logical_test *ENABLE.COMMAND bar_num,menu,command,check,position *ENABLE.TOOL module_text,procedure,type_text *END.IF ref_name,area_ref,skip_blanks *ERROR.TYPE text *ERROR *EVALUATE type_num,bar_id,position *EXECUTE channel_num *EXEC number *FCLOSE file_num *FILES rate,per,nper,pv,fv,type *FOPEN file_num *FOR.CELL number1,number2,... *FORMULA.CONVERT link_text,type_num,type_of_link,reference *FOR logical_test *FPOS date_text *FREADLN file_num,num_chars *FREAD file_num,text *FSIZE file_num *FWRITELN file_num,text *FWRITE file_num,position_num *GET.BAR number1,number2,... *GET.CELL type_num *GET.CHART.ITEM dialog_ref *GET.DEF reference,a1 *GET.DOCUMENT database,field,criteria *GET.FORMULA name_text,info_type *GET.LINK. add_text,object_id_text,start_num,num_chars *GET.MOVIE *GET.NAME reference,values *GET.NOTE add_text,cell_ref,start_char,num_chars *GET.OBJECT *GET.PIVOT.FIELD type_num,pivot_item_name,pivot_field_name,pivot_table_name *GET.PIVOT.ITEM angle *GET.PIVOT.TABLE type_num,pivot_field_name,pivot_table_name *GET.TOOLBAR word_text,custom_dic,ignore_uppercase *GET.TOOL error_val *GET.WINDOW type_num,name_text *GET.WORKBOOK number1,number2,... *GET.WORKSPACE type_num,window_text *GOTO cancel_close *HALT value *HELP bar_num,menu,command,subcommand *INFOGROUP cost,salvage,life,period,month *INITIATE channel_num,item_text *INPUT value *ISO.CEILING Rounds a number up, to the nearest integer or to the nearest multiple of significance!is the value you want to round!is the optional multiple to which you want to round x,alpha,beta,cumulative,A,B *LAST.ERROR macro_text,undo_text *LINKS message_text, type_num, title_text, default, x_pos, y_pos, help_ref *MOVIE.COMMAND text1,text2,... *NAMES path_text *NEXT app_text,topic_text *NOTE number1,number2,... *NUMBERSTRING number,form *OPEN.DIALOG init_filename,title,button_text,file_filter,filter_index *OPTIONS.LISTS.GET Get information about the Custom Lists rate,per,nper,pv *PAUSE type_num *PIVOT.ADD.DATA type_num,pivot_table_name *POKE channel_num,execute_text *PRESS.TOOL *REFTEXT text,a1 *REGISTER.ID Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered!is text specifying the name of the DLL that contains the function in Microsoft Excel for Windows!is text specifying the name of the function in the DLL in Microsoft Excel for Windows!is text encoding input and return data types and can be omitted if the function is already registered. type_num,name_text *REGISTER register_id,argument1,...!module_text,procedure,type_text,argument1,... *RELREF reference,rel_to_ref *RENAME.COMMAND bar_num *REQUEST channel_num,item_text,data_ref *RESET.TOOLBAR type_num,bar_id *RESTART help_ref *RESUME data_array,bins_array *RETURN rate,nper,pmt,fv,type *SAVE.DIALOG type_num,view_name *SAVE.TOOLBAR bar_id,position,down *SCENARIO.GET list_num!string_array *SERIES type_num,match_text *SET.NAME *SET.VALUE number,base *SHOW.BAR bar_num,menu,submenu *SPELLING.CHECK Returns a number matching an error value.!is the error value for which you want the identifying number, and can be an actual error value or a reference to a cell containing an error value text *STEP value *TERMINATE level_num *TEXT.BOX type_num,object_id_text,start_num,count_num,item_index *TEXTREF ref_text,a1 *UNREGISTER number,decimals *VIEW.GET data_field,pivot_table,field,item,... *VOLATILE *WHILE *WINDOW.TITLE bar_id,position,enable *WINDOWS