# User:Devon McCormick/ExcelFnsHelp

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