Function  Summary  Remarks 

ABS  Returns the absolute value of a specified number.  
ACCRINT  Returns the accrued interest for a security that pays periodic interest.  
ACCRINTM  Returns the accrued interest for a security that pays interest at maturity.  
ACOS  Returns the arccosine (=angle, 0π, in radian) of a specified number.  
ACOSH  Returns the hyperbolic arccosine (= inverse function of hyperbolic cosine) of a specified number (= angle).  
ADDRESS  Returns the cell address of a specified column number and row number, as string. For example, it returns a string like "$C$2" for absolute reference, "R2C3" for R1C1, and "'Sheet2'!R2C3" for a cell address in another sheet.  (*1) Not supported 
AMORDEGRC  Returns the depreciation cost for each accounting period, applying the depreciation coefficient. For French accounting system.  
AMORLINC  Returns the depreciation cost for each accounting period. For French accounting system.  
AND  Returns True (=1) if all arguments are true. Returns False (=0) if any argument is false.  
ASC  Converts fullwidth (doublebyte) alphanumeric and Kana characters to halfwidth (singlebyte) characters.  
ASIN  Returns the arcsine (=angle, π/2π/2, in radian) of a specified number.  
ASINH  Returns the hyperbolic arcsine (= inverse function of hyperbolic sine) of a specified number.  
ATAN  Returns the arctangent (=angle, π/2  π/2, in radian) of a specified number.  
ATAN2  Returns the arctangent (=angle, π  π excluding π, in radian) of specified x and y coordinates.  
ATANH  Returns the hyperbolic arctangent (= inverse function of hyperbolic tangent) of a specified number.  
AVEDEV  Returns the average of the absolute deviation of individual values from the average of a specified data set.  (*2) 
AVERAGE  Returns the average of a specified number.  (*2) 
AVERAGEA  Returns the average of specified values (including number, string, and logical value).  (*2) 
AVERAGEIF  Returns the average of the data which meets a specified condition among specified data.  (*2) 
AVERAGEIFS  Returns the average of the data which meets specified several conditions among specified data.  (*2) 
BESSELI  Returns the modified Bessel function value of the first kind for a pure imaginary number.  
BESSELJ  Returns the Bessel function value of the first kind.  
BESSELK  Returns the modified Bessel function value of the second kind for a pure imaginary number.  
BESSELY  Returns the Bessel function value of the second kind.  
BETADIST  Statistical function. Returns the value of the cumulative β distribution function.  
BETA.DIST  Returns the beta cumulative distribution function.  
BETAINV  Statistical function. Returns the inverse function value of the cumulative β distribution function.  
BETA.INV  Returns the inverse of the cumulative distribution function for a specified beta distribution.  
BIN2DEC  Converts a specified binary number to decimal.  
BIN2HEX  Converts a specified binary number to hexadecimal.  
BIN2OCT  Converts a specified binary number to octal.  
BINOMDIST  Statistical function. Returns the binomial distribution probability.  
BINOM.DIST  Returns the individual term binomial distribution probability.  
BINOM.INV  Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.  
CEILING  Returns a number rounded up to the nearest multiple of a specified significance.  
CHAR  Returns the character specified by a number (= character code).  
CHIDIST  Statistical function. Returns the value of the onesided probability of the chisquared distribution.  
CHIINV  Statistical function. Returns the inverse function value of the onesided probability of the chisquared distribution.  
CHITEST  Statistical function. Tests the independence from the chisquared distribution and returns the result.  (*2) 
CHISQ.DIST  Returns the chisquared distribution (probability density or cumulative distribution function).  
CHISQ.DIST.RT  Returns the righttailed probability of the chisquared distribution.  
CHISQ.INV  Returns the inverse of the lefttailed probability of the chisquared distribution.  
CHISQ.INV.RT  Returns the inverse of the righttailed probability of the chisquared distribution.  
CHISQ.TEST  Returns the chisquared statistical test for independence.  (*2) 
CHOOSE  Selects one value from a specified list of values.  (*2) 
CLEAN  Removes all nonprintable characters from the specified text.  
CODE  Returns a number (= character code) for the first character in a specified string.  
COLUMN  Returns the column number of a specified cell reference.  (*1) Not supported 
COLUMNS  Returns the number of columns of a specified cell reference.  (*1) Not supported 
COMBIN  Returns the number of combinations when a specified number of items are selected.  
COMPLEX  Converts real and imaginary factors into a complex number.  
CONCATENATE  Joins specified strings into one string.  
CONFIDENCE  Statistical function. Returns the confidence interval for a population mean, using a normal distribution.  
CONFIDENCE.NORM  Returns the confidence interval for a population mean, using a normal distribution.  
CONFIDENCE.T  Returns the confidence interval for a population mean, using a Student's t distribution.  
CONVERT  Converts the unit of a specified number.  
CORREL  Returns the correlation coefficient of specified two array data.  (*2) 
COS  Returns the cosine of a specified angle.  
COSH  Returns the hyperbolic cosine of a specified number.  
COUNT  Returns the number of numbers in a specified array or values.  (*2) 
COUNTA  Returns the number of data values (= number/text/logical value) in a specified array or values.  (*2) 
COUNTBLANK  Returns the number of empty cells in a specified cell range.  (*2) 
COUNTIF  Returns the total number of cells which meet a specified condition, in a specified cell range.  (*2) 
COUNTIFS  Returns the total number of cells which meet specified conditions, in a specified cell range.  (*2) 
COUPDAYBS  Returns the number of days from the beginning of a coupon period to its settlement date.  
COUPDAYS  Returns the number of days in the coupon period that contains the settlement date.  
COUPDAYSNC  Returns the number of days from the settlement date to the next coupon date.  
COUPNCD  Returns the next coupon date after the settlement date as number.  
COUPNUM  Returns the number of coupons payable between the settlement date and the maturity date.  
COUPPCD  Returns the coupon date immediately before the settlement date as number.  
COVAR  Statistical function. Returns the covariance (= average of the products of standard deviations for each data point pair in two data sets).  (*2) 
COVARIANCE.P  Returns population covariance (i.e. the average of the products of deviations for each pair within two supplied data sets).  (*2) 
COVARIANCE.S  Returns sample covariance (i.e. the average of the products of deviations for each pair within two supplied data sets).  (*2) 
CRITBINOM  Statistical function. Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.  
CUMIPMT  Returns the cumulative interest paid on a loan between the specified start and end periods.  
CUMPRINC  Returns the cumulative principal paid on a loan between the specified start and end periods.  
DATE  Returns a DateTime object representing the date specified by year, month, and date values.  
DATEDIF  Returns the number of days/months/years between specified two dates.  
DATEVALUE  Returns a DateTime object representing the date specified by a string.  
DAVERAGE  Returns the average value in a column of records in a specified list/database that match specified conditions.  (*2) 
DAY  Returns the day value (1  31) in a data specified by year, month, and day values/string/DateTime object.  
DAYS360  Returns the number of days between specified two dates based on the calculation method of a 360day year (1 year = 30 days * 12 months). This calculation method is used in some accounting calculations like payment calculation.  
DB  Returns the depreciation of an asset for a specified period by using the fixeddeclining balance method.  
DCOUNT  Counts the cells that contain numbers in a column of a list or database that match the specified conditions.  (*2) 
DCOUNTA  Counts the nonblank cells in a column of a list or database that match the specified conditions.  (*2) 
DDB  Returns the depreciation of an asset for a specified period using the doubledeclining balance method.  
DEC2BIN  Converts a specified decimal number to binary.  
DEC2HEX  Converts a specified decimal number to hexadecimal.  
DEC2OCT  Converts a specified decimal number to octal.  
DEGREES  Converts a specified angle in radian to degrees.  
DELTA  Tests whether specified two values are equal (= true: 1) or not (= false: 0).  
DEVSQ  Returns the sum of squares of deviations of data points from the sample mean.  (*2) 
DGET  Extracts a single value from a column of a specified list or database that matches specified conditions.  (*2) 
DISC  Returns the discount rate of a security.  
DMAX  Returns the largest number in a column of a list or database that matches the specified conditions.  (*2) 
DMIN  Returns the smallest number in a column of a list or database that matches the specified conditions.  (*2) 
DOLLAR  Rounds a specified number, inserts separators at specified digits, prepends a dollar sign ($), and returns the resulting string.  
DOLLARDE  Converts a dollar value in fraction into decimal.  
DOLLARFR  Converts a dollar value in decimal into fraction.  
DPRODUCT  Multiplies the values in a column of a list or database that match the specified conditions.  (*2) 
DSTDEV  Calculates the standard deviation of a population based on a sample by using the numbers in a column of a list or database that match the specified conditions.  (*2) 
DSTDEVP  calculates the standard deviation of a population based on the entire population using the numbers in a column of a list or database that match the specified conditions.  (*2) 
DSUM  Returns the sum of the values in a column of a list or database that match the specified conditions.  (*2) 
DURATION  Returns the annual Macauley duration for an assumed par value of $100 of a security that pays periodic interest.  
DVAR  Calculates the variance of a population based on a sample made up of the numbers in a column of a specified list/database that match specified conditions.  (*2) 
DVARP  Calculates the variance of a population based on the entire population made up of the numbers in a column in a specified list/database that match specified conditions.  (*2) 
EDATE  Returns a DateTime object that represents the date that is the specified number of months before () or after (+) a specified start date (number/string/DateTime object).  
EFFECT  Returns the effective annual interest rate.  
EOMONTH  Returns a DateTime object that represents the last day of the month that is the specified number of months before () or after (+) a specified start date (number/string/DateTime object).  
ERF  Calculates and returns the integrted value of the error function.  
ERF.PRECISE  Returns the integrated value of the error function.  
ERFC  Returns an integrated value of the complementary error function.  
ERFC.PRECISE  Returns the complementary ERF function integrated between x and infinity.  
ERROR.TYPE  Returns the number corresponding to an error value (for example, "=ERROR.TYPE(#VALUE!)" returns 3).  
EUROCONVERT  Converts a specified number (= amount) from a local currency or euro to another country's currency or euro.  
EVEN  Returns a number rounded up to the nearest even integer.  
EXACT  Determines whether specified two strings are "exactly equal or not" and returns True/False.  
EXP  Returns e (the base of the natural logarithm) raised to the power of a number (ex). EXP is the inverse function of LN.  
EXPON.DIST  Returns the exponential distribution.  
EXPONDIST  Statistical function. Returns the value of the exponential distribution function or the probability density function.  
FACT  Returns the factorial of a specified number.  
FACTDOUBLE  Returns the double factorial of a specified number.  
FALSE  Returns a logical value of False (= 0).  
F.DIST  Returns the F probability distribution.  
FDIST  Statistical function. Returns the value of the (left side) F probability distribution function (= degree of diversity), using the cumulative distribution or probability density function.  
F.DIST.RT  Returns the F probability distribution.  
FIND  "Case sensitive search" (Use the SEARCH function for noncase sensitive search). Searches a target string for a specified search string from a specified position and returns the found position (= first start) if hit or an error value "#VALUE!" otherwise.  
F.INV  Returns inverse of the F probability distribution.  
F.INV.RT  Returns inverse of the F probability distribution.  
FINV  Returns the inverse function value of the (right side) F probability density function.  
FISHER  Returns the value of the Fisher transformation.  
FISHERINV  Returns the inverse function value of the Fisher transformation.  
FIXED  Rounds a specified number, converts it into the format of specified digits and separators, and returns the resulting string.  
FLOOR  Mathematical/Trigonometric function. Returns a number rounded down to the nearest multiple of a specified significance.  
FORECAST  Predicts a future value by using existing values.* Note that this has been replaced with FORECAST.LINEAR in Excel 2016.  (*2) 
FREQUENCY  Calculates the frequency distribution and returns the vertical array.  (*2) 
F.TEST  Returns the result of an Ftest  (*2) 
FTEST  Statistical function. Returns the result of the F test.  (*2) 
FV  Returns the future value of an investment.  
FVSCHEDULE  Returns the future value of an initial principal.  (*2) 
GAMMA.DIST  Returns value of the gamma distribution function.  
GAMMADIST  Statistical function. Returns the value of the gamma distribution function.  
GAMMA.INV  Returns the inverse function value of the cumulative gamma distribution function.  
GAMMAINV  Statistical function. Returns the inverse function value of the cumulative gamma distribution function.  
GAMMALN  Returns the natural logarithm of a value of the gamma function.  
GAMMALN.PRECISE  Returns the natural logarithm of the gamma function, Γ(x).  
GCD  Returns the greatest common divisor.  (*2) 
GEOMEAN  Returns the geometric mean value.  (*2) 
GESTEP  Tests whether a specified number is more than or equal to the threshold (= true: 1) or not (= false: 0).  (*2) 
GROWTH  Returns a growth predicted from an exponential curve.  (*2) 
HARMEAN  Returns the harmonic mean value.  (*2) 
HEX2BIN  Converts a specified hexadecimal number to binary.  
HEX2DEC  Converts a specified hexadecimal number to decimal.  
HEX2OCT  Converts a specified hexadecimal number to octal.  
HLOOKUP  Searches a specified range for a data value that matches a search value column by column horizontally and returns the value of the cell at the specified "row" number in the matched "column".  (*1) Not supported 
HOUR  Returns a value (0  23) that represents the "hour" component of a specified date and time (number/string/DateTime object/TimeSpan object).  
HYPGEOM.DIST  Returns the hypergeometric distribution.  
HYPGEOMDIST  Statistical function. Returns the value of the hypergeometric distribution function.  
IF  Returns a specified value depending on the result of a logical expression (True/False).  
IFERROR  Returns a specified value if a formula evaluates to an error, or the result of the formula otherwise.  
IMABS  Returns the absolute value of a specified complex numbers.  
IMAGINARY  Returns the imaginary coefficient of specified complex numbers.  
IMARGUMENT  Returns the argument in radian.  
IMCONJUGATE  Returns the complex conjugate of a specified complex numbers.  
IMCOS  Returns the cosine of a specified complex number.  
IMDIV  Returns the quotient of specified two complex numbers.  
IMEXP  Returns value of the exponential function of a specified complex numbers.  
IMLN  Returns the natural logarithm of a specified complex number.  
IMLOG2  Returns the base2 logarithm of a specified complex number.  
IMLOG10  Returns the common logarithm (= base10 logarithm) of a specified complex number.  
IMPOWER  Returns the integer power of a specified complex numbers.  
IMPRODUCT  Returns the integer power of a specified complex numbers.  (*2) 
IMREAL  Returns the real coefficient of specified complex numbers.  
IMSIN  Returns sine of a specified complex number.  
IMSQRT  Returns square root of a specified complex number.  
IMSUB  Returns difference of two complex numbers.  
IMSUM  Returns sum of a specified complex numbers.  (*2) 
INDEX  Returns value of a cell determined by specified relative row and column positions, in an array/table.  (*1) Not supported 
INDIRECT  Specifies a cell indirectly through the string entered in the cell specified by the reference string.  (*1) Not supported 
INT  Rounds a number down to the nearest integer.  
INTERCEPT  Returns the intercept of a regression line.  (*2) 
INTRATE  Returns the interest rate of a fully invested security.  
IPMT  Returns the interest payment amount for a loan.  
IRR  Returns the internal rate of return based on a series of periodic cash flows.  (*2) 
ISBLANK  Returns True if the target cell/value/formula is empty, or False otherwise.  
ISERR  Returns True if the target cell/value/formula has an error value other than "#N/A" (= Not Available), or False otherwise.  
ISERROR  Returns True if the target cell/value/formula has any error value, or False otherwise.  
ISEVEN  Returns True if the target cell/value/formula has an even number, or False otherwise.  
ISLOGICAL  Returns True if the target cell/value/formula has a logical value, or False otherwise.  
ISNA  Returns True if the target cell/value/formula has an error value of "#N/A" (= Not Available), or False otherwise.  
ISNONTEXT  Returns True if the target cell/value/formula has a value other than a string, or False otherwise.  
ISNUMBER  Returns True if the target cell/value/formula has a number, or False otherwise.  
ISODD  Returns True if the target cell/value/formula has an odd number, or False otherwise.  
ISREF  Returns True if the target cell/value/formula is a cell reference, or False otherwise.  (*1) Not supported 
ISTEXT  Returns True if the target cell/value/formula has a string, or False otherwise.  
ISPMT  Returns the interest paid during a specified investment period.  
JIS  Converts halfwidth (singlebyte) characters in a string to fullwidth (doublebyte) characters.  
KURT  Returns the kurtosis of a specified data set.  (*2) 
LARGE  Returns the nth largest value in a specified data set.  (*2) 
LCM  Returns the least common multiple.  (*2) 
LEFT  Returns a substring in a target string that contains a specified number of characters from the left edge (i.e. from the beginning).  (*2) 
LEN  Returns the number of characters in a target string.  
LENB  Returns the number of characters in a target string.  
LINEST  Returns an array of the statistic values for a regression line.  (*2) 
LN  Returns the natural logarithm of a specified number. LN is the inverse function of EXP.  
LOG  Returns the logarithm of a number to a specified base.  
LOG10  Returns the logarithm of a number to the base 10 (common logarithm).  
LOGEST  Returns an array of the statistic values for a regression exponential curve.  (*2) 
LOGINV  Statistical function. Returns the inverse function value of the cumulative lognormal distribution function.  
LOGNORM.DIST  Returns value of the cumulative distribution function of the lognormal distribution.  
LOGNORMDIST  Statistical function. Returns value of the cumulative lognormal distribution function.  
LOGNORM.INV  Returns inverse function value of the lognormal cumulative distribution function.  
LOOKUP  A lookup range and result range are specified with a single row or single column in a common size. This function searches the lookup range for a data value that matches the search value, and returns the value of a cell determined by the found column/row number, in the result range.  (*1) Not supported 
LOWER  Converts all alphabetical characters in a target string to lowercase.  
MATCH  Search a specified range of one row or one column for a data value that matches the search value according to a specified match type, and returns relative position of the found item as a number.  (*2) 
MAX  Returns the maximum value from numbers in specified values or a specified array.  (*2) 
MAXA  Returns the maximum value from data (= number/text/logical value) in specified values or a specified array.  (*2) 
MDETERM  Returns the matrix determinant of an array.  (*2) 
MDURATION  Returns the annual modified Macauley duration for an assumed par value of $100 of a security that pays periodic interest.  
MEDIAN  Returns the median of numbers in specified values or a specified array.  (*2) 
MID  Extracts a substring that contains a specified number of characters from an arbitrary position in a target string.  
MIN  Returns the minimum value from numbers in specified values or a specified array.  (*2) 
MINA  Returns the minimum value from data (= number/text/logical value) in specified values or a specified array.  (*2) 
MINUTE  Returns a value (0  59) that represents the "minute" component of a specified date and time (number/string/DateTime object/TimeSpan object).  
MINVERSE  Returns the inverse matrix of a matrix.  (*2) 
MIRR  Returns the modified internal rate of return based on a series of periodic cash flows.  (*2) 
MMULT  Returns the matrix product of two arrays.  (*2) 
MOD  Returns the remainder after division.  
MODE  Statistical function. Returns the mode value (= most frequently occurring value) in specified values or a specified array, as a number.  (*2) 
MODE.MULT  Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.  (*2) 
MODE.SNGL  Returns the most common value in a data set.  (*2) 
MONTH  Returns the month value (1  12) in a data specified by year, month, and day values/string/DateTime object.  
MROUND  Rounds a specified number to a multiple of a specified number.  
MULTINOMIAL  Returns the multinomial of specified multiple numbers.  
N  Converts a value to a number.  
NA  Returns the error value of "#N/A" (= Not Available).  
NEGBINOM.DIST  Returns the negative binomial distribution.  
NEGBINOMDIST  Statistical function. Returns value of the negative binomial distribution probability function.  
NETWORKDAYS  Returns the total number of workdays (= days excluding Saturday, Sunday, and specified holidays) between start and end dates specified by numbers/DateTime objects.  (*2) 
NETWORKDAYS.INTL  Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days.  (*2) 
NOMINAL  Returns the nominal annual interest rate.  
NORM.DIST  Returns the normal cumulative distribution.  
NORMDIST  Statistical function. Returns value of the cumulative normal distribution function.  
NORMINV  Returns inverse function value of the cumulative normal distribution function.  
NORM.INV  Returns the inverse of the normal cumulative distribution. Note: In Excel 2007, this is a Statistical function. 

NORM.S.DIST  Returns the standard normal cumulative distribution.  
NORMSDIST  Statistical function. Returns value of the cumulative standard normal distribution function.  
NORM.S.INV  Returns the inverse of the standard normal cumulative distribution.  
NORMSINV  Statistical function. Returns the inverse function value of the cumulative standard normal distribution function.  
NOT  Returns the inverted Boolean value (True/False) of an argument. That is, returns False (= 0) for True, and True (= 1) for False.  
NOW  Returns a DateTime object that represents the current date and time.  
NPER  Returns the number of periods (= number of payments) for an investment.  
NPV  Returns the net present value of an investment.  (*2) 
OCT2BIN  Converts a specified octal number to binary.  
OCT2DEC  Converts a specified octal number to decimal.  
OCT2HEX  Converts a specified octal number to hexadecimal.  
ODD  Rounds up a specified number to the nearest odd number.  
ODDFPRICE  Returns the price per $100 par value of a security having an odd first period.  
ODDFYIELD  Returns the yield of a security having an odd first period.  
ODDLPRICE  Returns the price per $100 face value of a security with an odd last period.  
ODDLYIELD  Returns the yield of a security with an odd last period.  
OFFSET  Returns a reference (= offset reference) to a cell/cell range shifted by a specified number of rows and columns from a specified base cell/cell range.  (*1) Not supported 
OR  Returns True (=1) if any argument is true. Returns False (=0) if every argument is false.  
PEARSON  Returns the value of the Pearson's productmoment correlation coefficient.  (*2) 
PERCENTILE.EXC  Returns the kth percentile of values in a range, where k is in the range 0..1, exclusive.  (*2) 
PERCENTILE.INC  Returns the kth percentile of values in a range.  (*2) 
PERCENTILE  Statistical function. Returns the nth percentile of values in a specific range.  (*2) 
PERCENTRANK.EXC  Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.  (*2) 
PERCENTRANK.INC  Returns the percentage rank of a value in a data set.  (*2) 
PERCENTRANK  Statistical function. Returns the rank of a value in an array as a percentage.  (*2) 
PERMUT  Returns the number of permutations for a given number of objects.  
PI  Returns "π" (pi).  
PMT  Returns the regular payment amount for a loan.  
POISSON.DIST  Returns the Poisson distribution.  
POISSON  Statistical function. Returns the value of the Poisson probability.  
POWER  Returns the power of a specified number.  
PPMT  Returns the payment on a principal for a specified period.  
PRICE  Returns the price per $100 par value of a security that pays periodic interest.  
PRICEDISC  Returns the price per $100 par value for a discount security.  
PRICEMAT  Returns the price per $100 par value of a security that pays interest at maturity.  
PROB  Returns the probability that values in a specified range are between upper and lower limits.  (*2) 
PRODUCT  Returns the product of numbers in specified values or a specified array.  (*2) 
PROPER  Converts only first character of alphabetical words in the target string to uppercase.  
PV  Returns the present value of an investment  
QUARTILE  Statistical function. Returns the quartile of data values in an array.  (*2) 
QUARTILE.EXC  Returns the quartile of the data set, based on percentile values from 0..1, exclusive.  (*2) 
QUARTILE.INC  Returns the quartile of a data set.  (*2) 
QUOTIENT  Returns the integer portion of a division.  
RADIANS  Converts degrees to radians.  
RAND  Returns a random number between 0 and 1.  
RANDBETWEEN  Returns a random number between the numbers you specify.  
RANK.AVG  Returns the rank of a number in a list of numbers.  (*2) 
RANK.EQ  Returns the rank of a number in a list of numbers.  (*2) 
RANK  Statistical function. Returns the rank (= position) of a specified number in a specified list of numbers.  (*2) 
RATE  Returns the interest rate of an investment.  
RECEIVED  Returns the amount received at maturity for a fully invested security.  
REPLACE  "String replacement by location" (Use the SUBSTITUTE function for string replacement by keyword). Returns a specified string after replacing a specified number of characters from a specified position with another string.  
REPT  Repeats a specified string a specified number of times.  
RIGHT  Returns a substring in a target string that contains a specified number of characters from the right edge (i.e. from the end).  
ROMAN  Converts an Arabic number to Roman and returns the result as a string.  
ROUND  Rounds off a specified number to a specified number of digits.  
ROUNDDOWN  Rounds down a specified number to a specified number of digits.  
ROUNDUP  Rounds up a specified number to a specified number of digits.  
ROW  Returns the row number of a specified cell reference.  (*1) Not supported 
ROWS  Returns the number of rows of a specified cell reference.  (*1) Not supported 
RSQ  Returns the square of the Pearson product moment correlation coefficient.  (*2) 
SEARCH  "Noncase sensitive search" (Use the FIND function for case sensitive search). Searches a target string or cell range for a specified search string and returns the found position (= first start) if hit or an error value "#VALUE!" otherwise. In the case of a cell range, this function indicates just the number of position, not the exact cell position.  
SECOND  Returns a value (0  59) that represents the "second" component of a specified date and time (number/string/DateTime object/TimeSpan object).  
SERIESSUM  Returns a power series.  (*2) 
SIGN  Returns whether a specified number is positive or negative (= sign).  
SIN  Returns the sine of a specified angle.  
SINH  Returns the hyperbolic sine of a specified number.  
SKEW  Returns the skewness of a distribution (= degree of asymmetry around the mean).  (*2) 
SLN  Returns the straightline depreciation of an asset for one period.  
SLOPE  Returns the slope of the linear regression line.  (*2) 
SMALL  Returns the nth smallest value in a data set.  (*2) 
SQRT  Returns a positive square root.  
SQRTPI  Returns the square root of a specified number multiplied by pi.  
STANDARDIZE  Returns a normalized value from a distribution determined by specified mean and standard deviation.  
STDEV  Statistical function. Returns the estimated standard deviation of a population based on a sample, supposing that specified numbers are a sample of a normal population.  (*2) 
STDEV.P  Returns the standard deviation of a population, assuming that specified numbers are an entire population.  (*2) 
STDEV.S  Returns the standard deviation of a population, assuming that specified number is a sample of the normal population.  (*2) 
STDEVA  Returns the estimated value of the standard deviation of the population, assuming that the data (= numerical value / text / logical value) contained in the specified values is sample of the normal population.  (*2) 
STDEVP  Statistical function. Returns the standard deviation of a population, assuming the specified numbers as the entire population.  (*2) 
STDEVPA  Returns the standard deviation of a population, assuming that the data (= numerical value / text / logical value) contained in the specified values is the entire population.  (*2) 
STEYX  Returns the standard error of the predicted value on the regression line.  (*2) 
SUBSTITUTE  "String replacement by keyword" (Use the REPLACE function for string replacement by location). Returns a specified string after replacing a specified substring with another string.  
SUBTOTAL  Returns a subtotal. You can select an aggregation method, such as total, average, and count.  (*2) 
SUM  Returns the total.  (*2) 
SUMIF  Sums up the values of cells that satisfy a specified condition.  (*2) 
SUMIFS  Sums up the values of cells that satisfy specified conditions.  (*2) 
SUMPRODUCT  Sums up the products of corresponding elements in specified two arrays.  (*2) 
SUMSQ  Returns the sum of squares (= square sum).  (*2) 
SUMX2MY2  Sums up the square differences of corresponding elements in specified two arrays.  (*2) 
SUMX2PY2  Sums up the square sums of corresponding elements in specified two arrays.  (*2) 
SUMXMY2  Sums up the squared differences of corresponding elements in specified two arrays.  (*2) 
SYD  Returns the depreciation of an asset for a specified period using the sumoftheyears' digits method.  
T  Converts a specified cell to a string.  
TAN  Returns the tangent of a specified angle.  
TANH  Returns the hyperbolic tangent of a specified number.  
TBILLEQ  Returns the bondequivalent yield for a Treasury Bill (TB).  
TBILLPRICE  Returns the price per $100 par value for a Treasury Bill (TB).  
TBILLYIELD  Returns the yield for a Treasury Bill (TB).  
T.DIST  Returns the probability of the Student's t distribution.  
T.DIST.2T  Returns the probability of the Student's t distribution.  
T.DIST.RT  Returns the Student's t distribution  
TDIST  Statistical Function. Returns the Student's tdistribution  
TEXT  Formats a number and converts it to text.  
TIME  Returns a TimeSpan object representing the time specified by hour, minute, and second values.  
TIMEVALUE  Returns a TimeSpan object representing the time specified by a string.  
T.INV  Returns the tvalue of the Student's tdistribution as a function of the probability and the degrees of freedom.  
T.INV.2T  Returns the inverse of the Student's tdistribution.  
TINV  Returns the inverse of the Student's tdistribution.  
TODAY  Returns a DateTime object that represents the current date.  
TRANSPOSE  Returns an array made by swapping rows and columns in a specified cell range.  (*1) Not supported 
TREND  Returns an array of predicted values on a regression line.  (*2) 
TRIM  Removes all spaces from a specified string except for single spaces between words.  
TRIMMEAN  Returns the average of middle data values which excludes upper and lower data values in a data set.  (*2) 
TRUE  Returns a logical value of True (= 1).  
TRUNC  Truncates a number by removing the fractional part of it.  
T.TEST  Returns the probability associated with a Student's ttest.  (*2) 
TTEST  Statistical function. Returns the result of the Student's ttest.  (*2) 
TYPE  Returns the data type of a value (1 = Number/DateTime/TimeSpan, 2 = Text, 4 = Boolean, 16 = Error, 64 = Array).  
UPPER  Converts all alphabetical characters in the target string to uppercase.  
VALUE  Converts a specified string (that represents a number) to a number.  
VAR  Statistical function. Returns the estimated variance (= unbiased variance) of a population based on a sample, supposing that a set of numbers in a specified array or values is a sample of a normal population.  (*2) 
VAR.P  Returns the population variance (sample variance), assuming that specified value is the entire population.  (*2) 
VAR.S  Returns an estimate of the population variance (unbiased variance) based on the sample.  (*2) 
VARA  Returns the estimated variance (= unbiased variance) of a population based on a sample, supposing that data (= number/text/logical value) in specified values is a sample of a normal population.  (*2) 
VARP  Statistical function. Returns the variance (= sample variance) of a population, supposing that a set of numbers in a specified array or values is an entire population.  (*2) 
VARPA  Returns the variance (= sample variance) of a population, supposing that data (= number/text/logical value) in specified values is an entire population.  (*2) 
VDB  Returns the depreciation of an asset for any specified period using the doubledeclining balance method.  
VLOOKUP  Searches a specified range for a data value that matches a search value row by row vertically and returns the value of the cell at a specified "column" number in the matched "row".  (*1) Not supported 
WEEKDAY  Returns the day of the week for a date specified by a number/string/DateTime object.  
WEEKNUM  Returns the week number in a year for a date specified by a number/string/DateTime object.  
WEIBULL  Statistical function. Returns the value of the Weibull distribution.  
WEIBULL.DIST  Returns the value of the Weibull distribution.  
WORKDAY  Returns the total number of workdays (= days excluding Saturday, Sunday, and specified holidays) to the date that is the specified number of days before () or after (+) a specified start date (number/DateTime object).  (*2) 
WORKDAY.INTL  Returns the serial number of the date before or after a specified number of workdays from a start date using a parameter that indicates which and how many days are weekend days.  (*2) 
XIRR  Returns the internal rate of return based on an irregular cash flow.  (*2) 
XNPV  Returns the net present value based on an irregular cash flow.  (*2) 
YEAR  Returns the year value in a data specified by year, month, and day values/string/DateTime object.  
YEARFRAC  Returns the percentage of the number of days in a year, for a period between start and end dates specified by DateTime objects.  
YIELD  Returns the yield of a security that pays periodic interest.  
YIELDDISC  Returns the annual yield for a discounted security such as the Treasury Bill (TB).  
YIELDMAT  Returns the annual yield of a security that pays interest at maturity.  
Z.TEST  Returns the onetailed probabilityvalue of a ztest.  (*2) 
ZTEST  Statistical function. Returns the result of the z test.  (*2) 
Microsoft Excel is a registered trademark of Microsoft Corporation in the United States and other countries.