| 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 full-width (double-byte) alphanumeric and Kana characters to half-width (single-byte) 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 one-sided probability of the chi-squared distribution. | |
| CHIINV | Statistical function. Returns the inverse function value of the one-sided probability of the chi-squared distribution. | |
| CHITEST | Statistical function. Tests the independence from the chi-squared distribution and returns the result. | (*2) |
| CHISQ.DIST | Returns the chi-squared distribution (probability density or cumulative distribution function). | |
| CHISQ.DIST.RT | Returns the right-tailed probability of the chi-squared distribution. | |
| CHISQ.INV | Returns the inverse of the left-tailed probability of the chi-squared distribution. | |
| CHISQ.INV.RT | Returns the inverse of the right-tailed probability of the chi-squared distribution. | |
| CHISQ.TEST | Returns the chi-squared 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 360-day 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 fixed-declining 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 non-blank 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 double-declining 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 non-case 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 F-test | (*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 base-2 logarithm of a specified complex number. | |
| IMLOG10 | Returns the common logarithm (= base-10 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 half-width (single-byte) characters in a string to full-width (double-byte) characters. | |
| KURT | Returns the kurtosis of a specified data set. | (*2) |
| LARGE | Returns the n-th 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 product-moment correlation coefficient. | (*2) |
| PERCENTILE.EXC | Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive. | (*2) |
| PERCENTILE.INC | Returns the k-th percentile of values in a range. | (*2) |
| PERCENTILE | Statistical function. Returns the n-th 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 | "Non-case 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 straight-line depreciation of an asset for one period. | |
| SLOPE | Returns the slope of the linear regression line. | (*2) |
| SMALL | Returns the n-th 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 sum-of-the-years' 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 bond-equivalent 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 t-distribution | |
| 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 t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. | |
| T.INV.2T | Returns the inverse of the Student's t-distribution. | |
| TINV | Returns the inverse of the Student's t-distribution. | |
| 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 t-test. | (*2) |
| TTEST | Statistical function. Returns the result of the Student's t-test. | (*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 double-declining 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 one-tailed probability-value of a z-test. | (*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.