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 omitted	reference
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 omitted	known_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