Function List

In This Topic

Following tables describe the functions supported in krewData.

The krewData function can only refer to field values in the same record. You cannot see the values of other records.
Unlike Excel, krewData does not manage data in spreadsheet format, and because there is no concept of cells, the search target cannot be specified in range format (In Excel, cell positions are separated by colons like "A1: A5" to specify a range).
Functions marked as "(*1) Not supported" in the Remarks column of the below table are not support in krewData.
Functions marked as "(*2)" in the Suported Status column of the below table have arguments in array format.
- For arguments in array format, you need to use the CHOOSE function to create a list of fields you want to select and specify it as an array.
  For example: SMALL (CHOOSE ({1, 2, 3}, number1, number2, number3), 1)
- When specifying a holiday list as an argument, you can use the setting code created for the specific holiday setting. For details, see "Holiday Setting in Formula" in the "Holiday Setting List" topic.

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	The function returns the angle whose cosine is the specified value. The returned angle is in the range of 0 to π (in radians).
ACOSH	Calculates the inverse function of hyperbolic cosine of a specified angle.
ADDRESS	Returns text representing a cell address based on the specified row and column numbers.	(*1) Not supported
AMORDEGRC	Returns the depreciation for each accounting period by calculating the daily depreciation and applying the depreciation coefficient based on the asset's life.
AMORLINC	Calculates the depreciation expense for a specified accounting period, considering daily depreciation.
AND	Returns True if all arguments are true, and False if one or more arguments are false.
ASC	This function changes full-width characters to half-width characters.
ASIN	Returns the angle whose sine is the specified value. The returned angle ranges between -π/2 and π/2 (in radians).
ASINH	Returns the inverse function value of the hyperbolic sine of a specified number.
ATAN	Returns the angle whose tangent is the specified value. The returned angle ranges between -π/2 to π/2 (in radians).
ATAN2	Returns the arctangent of the specified x and y coordinates. The returned angle ranges between -π and π (in radians, excluding -π).
ATANH	Returns the inverse hyperbolic tangent of the specified number.
AVEDEV	Returns the average of the absolute deviation of individual values from the average value of a specified data.	(*2)
AVERAGE	Returns the average value of a specific number.	(*2)
AVERAGEA	Returns the average value of a dataset that meets specified criteria.	(*2)
AVERAGEIF	Returns the average value of a dataset that meets specified criteria.	(*2)
AVERAGEIFS	Returns the average value of a dataset that meets multiple specified criteria.	(*2)
BESSELI	Returns the modified Bessel function of the first kind when a pure imaginary number is used as an argument.
BESSELJ	Returns the Bessel function value of the first kind.
BESSELK	Returns the modified Bessel function of the second kind when a pure imaginary number is used as an argument.
BESSELY	Returns the Bessel function value of the second kind.
BETADIST	Returns the value of the cumulative β probability density function.
BETA.DIST	Returns the β distribution.
BETAINV	Returns the inverse function value of the cumulative β probability density function.
BETA.INV	Returns the inverse of the cumulative beta probability density function (BETA.DIST).
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	Returns the binomial distribution probability for an individual term.
BINOM.DIST	Returns the binomial distribution probability for a single term.
BINOM.INV	Returns the minimum value for which the cumulative binomial distribution is greater than or equal to the criterion value.
CEILING	Rounds up the number to a multiple of the specified reference value and return the value that is closest to the original.
CHAR	Returns the character corresponding to the specified number.
CHIDIST	Returns the one-sided probability of the chi-squared distribution.
CHIINV	Returns the inverse function of the one-sided probability of the chi-square distribution.
CHITEST	Test independence from chi-square distribution.	(*2)
CHISQ.DIST	Returns the chi-square distribution.
CHISQ.DIST.RT	Returns the value of the right-tailed probability of the chi-square 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	Perform a chi-square (χ2) test.	(*2)
CHOOSE	Returns a specific value from the list of values.	(*2)
CLEAN	Removes all nonprintable characters from the specified text.
CODE	Returns the numeric code corresponding to the first character in text. The code returned is Unicode.
COLUMN	Returns the column number of the reference.	(*1) Not supported
COLUMNS	Returns the number of columns in the array.	(*1) Not supported
COMBIN	Returns the number of selectable combinations, when extracting the specified number from the total number.
COMPLEX	Converts real and imaginary factors into a complex number.
CONCATENATE	Combines specified strings or numbers into one string.
CONFIDENCE	Returns the day of the week that corresponds to the specified date.
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 the T distribution.
CONVERT	Convert a value from one measurement unit to another.
CORREL	Returns the correlation coefficient between two data sets.	(*2)
COS	Returns the cosine of a specified angle.
COSH	Returns the hyperbolic cosine of a specified number.
COUNT	Returns the number of numeric values included in the specified array.	(*2)
COUNTA	Returns the number of data items (= number/text/logical value) in the specified array.	(*2)
COUNTBLANK	Returns the number of blank cells in a specified cell range on the sheet.	(*2)
COUNTIF	Returns the number of cells that meet the specified condition.	(*2)
COUNTIFS	Returns the number of cells that meet multiple conditions.	(*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 (including the settlement date).
COUPDAYSNC	Returns the number of days from the settlement date to the next coupon date.
COUPNCD	Return the next coupon payment date value after the settlement date.
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 date value.
COVAR	Return the average of the products of the standard deviations of two corresponding datasets.	(*2)
COVARIANCE.P	Returns the population covariance (i.e. the average product of the standard deviation between two corresponding datasets).	(*2)
COVARIANCE.S	Returns the sample covariance (i.e. the average product of the standard deviation between two corresponding data sets).	(*2)
CRITBINOM	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 Date object representing the date specified by year, month, and day.
DATEDIF	Returns the number of days/months/years between specified two dates.
DATEVALUE	Returns the date for the specified date.
DAVERAGE	Returns the average value in a column of records in a specified list/database that match specified conditions.	(*2)
DAY	Return the day of the month (1-31) corresponding to a specific date.
DAYS360	Returns the number of days between two specified dates, considering 360-day year (January has 30 days).
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 or other specified calculation methods.
DEC2BIN	Converts a decimal value to a binary value.
DEC2HEX	Converts a decimal value to a hexadecimal value.
DEC2OCT	Converts a decimal value to an octal value.
DEGREES	Converts a specified angle in radian to degrees.
DELTA	Checks whether two values are equal. Returns 1 if the two values are equal, otherwise returns 0.
DEVSQ	Calculates the sum of the squared deviations of each data point from the mean.	(*2)
DGET	Extracts a single value from a specified column of a list or database that meets the specified conditions.	(*2)
DISC	Returns the discount rate of a security.
DMAX	Return the maximum value in a specified column of a list or database that meets the specified conditions.	(*2)
DMIN	Return the minimum value in a specified column of a list or database that meets the specified conditions.	(*2)
DOLLAR	Round up a number to the specified decimal places and convert it to a string formatted as currency.
DOLLARDE	Converts a dollar value in fraction into decimal.
DOLLARFR	Converts a dollar value in decimal into fraction.
DPRODUCT	Multiply the values in a specified column of a list or database that meet 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 based on the entire population using the numbers in a specified column of a list or database that meet the specified conditions.	(*2)
DSUM	Adds the numbers in the column of a list or database that meet the specified conditions.	(*2)
DURATION	Returns the annual Macauley duration for an assumed par value of $100 of a security.
DVAR	Evaluates the variance of a population using the sample by using the numbers in a specified column of a list or database that meet the specified conditions.	(*2)
DVARP	Calculates the variance based on the entire population by using the numbers in a specified column in a list or database that meet specified conditions.	(*2)
EDATE	Return the date and time that is a specified number of months before or after a given date
EFFECT	Return the effective annual interest rate based on the specified nominal annual interest rate and the number of compounding periods per year.
EOMONTH	Returns a date and time of the last day of the month that is a specified number of months before or after the given date.
ERF	Returns the integral value of the error function integrated between upper and lower limits.
ERF.PRECISE	Returns the integrated value of the error function.
ERFC	Returns the integral of the complementary error function integrated between lower limit to infinity.
ERFC.PRECISE	Returns the complementary error function integrated between x and infinity.
ERROR.TYPE	Returns a numeric value corresponding to the error value. Returns #N/A if there are no errors.
EUROCONVERT	Converts a currency value to another between the euro member currencies (including euros).
EVEN	Rounds up the specified value and returns the nearest even integer.
EXACT	Returns True if the two strings are equal, otherwise, returns False.
EXP	Returns the specified power (ex) with e (the base of natural logarithms) as the base. The EXP function is the inverse of the LN function.
EXPON.DIST	Returns the exponential distribution.
EXPONDIST	Calculates the value of the exponential distribution function or the probability density function.
FACT	Returns the factorial of a specified number.
FACTDOUBLE	Return the double factorial of a number.
FALSE	Return the logical value 0 (False).
F.DIST	Return the value of the F probability distribution function.
FDIST	Calculates the F probability distribution function that compares the dispersion degree between two data sets.
F.DIST.RT	Returns the value (dispersion) of the (right-tailed) F probability distribution function for two data sets.
FIND	Searches for a specified character in text and returns the position of this character.
F.INV	Returns the inverse of the F probability distribution function. When probability = F.DIST(x,...), the F.INV(probability,...) = x .
F.INV.RT	Returns the inverse function value of the (right-tailed) F probability distribution. When probability = F.DIST.RT(x,...), then F.INV.RT(probability,...) = x .
FINV	Returns the inverse of the F probability distribution function. When p = FDIST(x,...), then FINV(p,...) = x.
FISHER	Returns the value of the Fisher transformation.
FISHERINV	Returns the inverse function value of the Fisher transformation.
FIXED	Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas (if specified), and returns the result as text.
FLOOR	Truncates a number to the nearest multiple of a specified value and returns the value closest to the original value.
FORECAST	Calculates future value using existing values.	(*2)
FREQUENCY	Calculates how often values occur within a range of values. this function returns a vertical array of numbers.	(*2)
F.TEST	Returns the result of an F-test, the two-tailed probability that the variances in array1 and array2 are not significantly different.	(*2)
FTEST	Returns the results of the F test, the one-tailed probability calculation indicating that there is no significant difference in variance between the data in the two arrays.	(*2)
FV	Calculate the future value of an investment based on the present value, periodic payments, and a specified interest rate.
FVSCHEDULE	Calculate the future value of the initial investment (principal) by applying a series of compound interest rates over the investment period.	(*2)
GAMMA.DIST	Calculates the value of the gamma distribution function.
GAMMADIST	Statistical function. Returns the value of the gamma distribution function.
GAMMA.INV	Return the inverse cumulative distribution function of the gamma distribution. If p = GAMMA.DIST(x,...) then GAMMA.INV(p,...) = x.
GAMMAINV	Returns the inverse of the gamma cumulative distribution function. If p = GAMMADIST (x,...) then GAMMAINV(p,...) = x.
GAMMALN	Returns the natural logarithm (x) of the value of the gamma function.
GAMMALN.PRECISE	Returns the natural logarithm of the value of the gamma function, G(x).
GCD	Returns the greatest common divisor between two numbers. The greatest common divisor is the largest integer that can divide all the values without leaving any remainder.	(*2)
GEOMEAN	Calculates the geometric mean value of a group of positive numbers.	(*2)
GESTEP	Determines whether the number is equal to a threshold. Returns 1 if the specified number is equal to or greater than the threshold, otherwise returns 0.	(*2)
GROWTH	Calculate the predicted exponential curve.	(*2)
HARMEAN	Calculates the harmonic mean of a group of numbers.	(*2)
HEX2BIN	Converts a hexadecimal value to a binary value.
HEX2DEC	Converts a hexadecimal value to a decimal value.
HEX2OCT	Converts a hexadecimal value to an octal value.
HLOOKUP	Searches for a value in the top row of the specified range, and then return the value from the same column from the specified row.	(*1) Not supported
HOUR	Returns the hour of the specified time value.
HYPGEOM.DIST	Returns the value of the hypergeometric distribution function.
HYPGEOMDIST	Calculates the value of the hypergeometric distribution function.
IF	Returns a value representing the result of a logical expression.
IFERROR	Evaluates a formula and returns the specified value in case of an error, otherwise returns the result of the formula.
IMABS	Returns the absolute value of a complex number.
IMAGINARY	Returns the imaginary coefficient of a complex number.
IMARGUMENT	Returns the argument θ, an angle in radians.
IMCONJUGATE	Returns the complex conjugate of a complex number.
IMCOS	Returns the cosine of a complex number.
IMDIV	Returns the quotient of two complex numbers.
IMEXP	Returns the exponential function of a complex number.
IMLN	Returns the natural logarithm of a complex number.
IMLOG2	Returns the base-2 logarithm of a complex number.
IMLOG10	Returns the common logarithm of a complex number.
IMPOWER	Returns the integer power of a complex number.
IMPRODUCT	Returns the product of up to 29 complex numbers specified in x+yi or "x+yj" text format.	(*2)
IMREAL	Returns the real coefficients of a complex number specified in x+yi or "x+yj" text format.
IMSIN	Returns the sine of a complex number specified in x+yi or "x+yj" text format.
IMSQRT	Returns the square root of a complex number specified in x+yi or "x+yj" text format.
IMSUB	Returns the difference between two complex numbers specified in x+yi or "x+yj" text format.
IMSUM	Returns the sum of two or more complex numbers specified in "x+yi" or "x+yj" text format.	(*2)
INDEX	Return a specific value or a reference to a value in an array or a range of cells.	(*1) Not supported
INDIRECT	Returns a reference to the specified string.	(*1) Not supported
INT	Truncate the decimal part of the specified value and return the nearest integer.
INTERCEPT	Finds the point at which the regression line intersects the y-axis using the specified x and y values.	(*2)
INTRATE	Calculates the interest rate on a fully invested security.
IPMT	Calculate the interest to be paid on a loan repayment.
IRR	Calculates the internal rate of return based on a series of periodic cash flows (specified by the array values in the values argument).	(*2)
ISBLANK	Determines whether a value (such as cell) is empty.
ISERR	Determine whether the value (such as cell) refers to an error value other than #N/A (not available).
ISERROR	Determines whether the value (such as cell) refers to any error value.
ISEVEN	Determines whether the value (such as cell) is an even number.
ISLOGICAL	Determines whether the value (such as cell) is logical.
ISNA	Determines whether the value (such as cell) refers to the error value #N/A (not available).
ISNONTEXT	Determines whether the value (such as cell) is non-text data.
ISNUMBER	Determines whether the value (such as cell) is a number.
ISODD	Determines whether the value (such as cell) is an odd.
ISREF	Determines whether the value (such as cell) is a reference to another cell.	(*1) Not supported
ISTEXT	Determines whether the value (such as cell) is a string.
ISPMT	Calculates the interest rate paid over a specified investment period.
JIS	This function changes half-width characters to full-width characters.
KURT	Returns the kurtosis of a data set.	(*2)
LARGE	Returns the n-th largest value in a dataset.	(*2)
LCM	Returns the least common multiple of the specified integers.	(*2)
LEFT	Returns the first (leftmost) character from a text value.	(*2)
LEN	Returns the number of characters in a text.
LENB	Returns the number of characters in a specified text string. Half-width characters are 1 byte, full-width characters are 2 bytes.
LINEST	Calculate statistical value based on 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 the number X to the base Y.
LOG10	Returns the logarithm of the number X to the base 10.
LOGEST	Calculate an exponential curve that fits your data and return an array of values that describes the curve.	(*2)
LOGINV	Calculates the inverse of the lognormal cumulative distribution function of x.
LOGNORM.DIST	Return the value of the lognormal distribution function of x. ln(x) is normally distributed with the given mean and standard deviation.
LOGNORMDIST	Calculated the lognormal cumulative distribution function of x.
LOGNORM.INV	Returns the inverse lognormal cumulative distribution function of x. ln(x) is normally distributed with argument mean and standard deviation.
LOOKUP	Checks a value within a range of cells in a row or column, or an array.	(*1) Not supported
LOWER	Convert text to lowercase.
MATCH	Returns the relative position of the specified item in the range.	(*2)
MAX	Returns the maximum value from the argument list.	(*2)
MAXA	Returns the maximum value from the argument list.	(*2)
MDETERM	Returns the determinant of an array.	(*2)
MDURATION	Returns the modified Macaulay duration of a security with an assumed par value of $100.
MEDIAN	Returns the median value in a specified set of numbers.	(*2)
MID	Extracts and returns a specified number of characters from a specified text.
MIN	Returns the minimum value from the argument list.	(*2)
MINA	Returns the minimum value from the argument list.	(*2)
MINUTE	Return the minute as an integer range between 0 to 59.
MINVERSE	Returns the inverse of the matrix specified in an array.	(*2)
MIRR	Calculates a modified internal rate of return based on a series of periodic cash flows.	(*2)
MMULT	Returns the specified matrix product of two arrays.	(*2)
MOD	Returns the remainder when the number argument (dividend) is divided by the divisor argument.
MODE	Returns the most frequently occurring value from the specified argument list.	(*2)
MODE.MULT	Return the vertical array (mode) of the most frequently occurring values from the data specified in an array or cell range. For horizontal arrays, use TRANSPOSE (MODE.MULT(number 1, number 2,...)).	(*2)
MODE.SNGL	Returns the most frequently occurring value (mode) from the data specified in an array or range of cells.	(*2)
MONTH	Returns the month corresponding to the specified date value.
MROUND	Returns a value rounded to the specified multiple.
MULTINOMIAL	The multinomial coefficient calculates the polynomial coefficients (based on the ratio of the factorial of the sum of the values in the list to the product of the factorials of each value in the list).
N	Returns the value converted to a number.
NA	Returns the error value of "#N/A" (= Not Available).
NEGBINOM.DIST	Returns the value of the probability function of the negative binomial distribution, and when the success rate of the trials is constant, it calculates the probability that there will be failed attempts specified in (number of failures) before success attempts specified in (number of successes).
NEGBINOMDIST	Calculates the negative binomial distribution.
NETWORKDAYS	Calculates the total number of whole working days within the period from the start date to the end date.	(*2)
NETWORKDAYS.INTL	Returns the number of working days between two dates, using parameters that indicate the weekend days and number of weekend days. All days specified as weekends and holidays are not considered as working days.	(*2)
NOMINAL	Calculates the nominal annual interest rate based on the specified effective interest rate and compounding period per year.
NORM.DIST	Returns the value of the normal distribution function for the specified mean and standard deviation.
NORMDIST	Returns the value of the normal cumulative distribution function for the specified mean and standard deviation.
NORMINV	Returns the inverse of the normal cumulative distribution function for the specified mean and standard deviation.
NORM.INV	Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
NORM.S.DIST	Returns the cumulative distribution function value for the standard normal distribution. This distribution corresponds to a normal distribution with a mean of 0 (zero) and a standard deviation of 1.
NORMSDIST	Calculates the standard normal cumulative distribution function.
NORM.S.INV	Returns the inverse of the cumulative distribution function of the standard normal distribution. This distribution corresponds to a normal distribution with mean 0 and standard deviation 1.
NORMSINV	Returns the inverse of the standard normal cumulative distribution function. This distribution has a mean of 0 and a standard deviation of 1.
NOT	Reverses the logical value of the argument.
NOW	Returns a value representing the current date and time.
NPER	Returns the required investment period (number of payments) based on the present value, future value, periodic payments, and a constant interest rate.
NPV	Calculates the net present value of an investment based on a discount rate and a series of future payments and their returns.	(*2)
OCT2BIN	Convert a discount rate, a series of future payments and their octal value to a binary value.
OCT2DEC	Converts an octal value to a decimal value.
OCT2HEX	Converts an octal value to a hexadecimal value. Calculates the net present value of an investment based on its return.
ODD	Rounds up the specified value up to the nearest odd integer value.
ODDFPRICE	Calculates the price per $100 par value for securities having odd number of days in the first period.
ODDFYIELD	Calculate the yield of securities with an odd number of days in the first term.
ODDLPRICE	Calculates the price per $100 par value of a security with an odd last period.
ODDLYIELD	Calculates the yield of a security with an odd last period.
OFFSET	This function returns a reference to a cell range. The range of cells returned can be specified as the number of rows and columns from a single cell or cell range. This returns a single cell or a cell range.
OR	Returns 1 (True) if any argument is true, and 0 (False) if all arguments are false.
PEARSON	Returns the Pearson product-moment correlation coefficient, which ranges between -1.0 -1.0 and indicates the degree of linear correlation between two data sets.	(*2)
PERCENTILE.EXC	Returns the k-th percentile of data in a specified range (k ranges from 0-1).	(*2)
PERCENTILE.INC	Returns the k-th percentile of data in a range (k ranges from 0- 1).	(*2)
PERCENTILE	Returns the value that has the n-th percentile among the values within a specified range.	(*2)
PERCENTRANK.EXC	Returns the rank of a value in an array as a percentage (greater than 0 and less than 1).	(*2)
PERCENTRANK.INC	Returns the rank of a value in an array as a percentage (0-1, inclusive).	(*2)
PERCENTRANK	Returns the rank of a value as a percentage in a data set.	(*2)
PERMUT	Returns the number of valid permutations when selecting a specified number of samples.
PI	Returns pi (π) as 3.1415926536.
PMT	Calculates the periodic payment amount for loan repayment based on the present value, specified interest rate, and number of payments.
POISSON.DIST	Returns the Poisson probability value.
POISSON	Calculates the value of the Poisson probability distribution.
POWER	Calculates the power of the exponent (Y) using specified number (X) as the base.
PPMT	Return the principal amount.
PRICE	Returns the price per $100 par value of a security that pays periodic interest.
PRICEDISC	Calculate the price per $100 par value of a discount bond.
PRICEMAT	Returns the price per $100 par value of a security that pays interest on maturity.
PROB	Returns the probability that the value within a specified range fall between the upper and lower limits.	(*2)
PRODUCT	Returns the product obtained by multiplying all argument values.	(*2)
PROPER	Converts the first letter of all English words in the string to uppercase.
PV	Returns the present value of an investment based on a specific interest rate, the number of periodic payments and payment amount, and the future value.
QUARTILE	Returns the specified quartile (1/4 [25%] of the dataset) of the data set.	(*2)
QUARTILE.EXC	Returns the quartiles of an array of data based on percentage values between 0-1 (exclusive).	(*2)
QUARTILE.INC	Returns the quartiles of an array of data, based on percentile values from 0 and 1 (inclusive).	(*2)
QUOTIENT	Returns the integer part of the quotient obtained by division. Use the QUOTIENT function when you want to discard the remainder of the quotient.
RADIANS	Converts an angle value from degrees to radians.
RAND	Generates uniformly distributed random numbers between 0 and 1. The RAND function generates a new random number every time the spreadsheet is recalculated.
RANDBETWEEN	Generates random numbers within the range of the two specified values. The RANDBETWEEN function generates a new random number every time the sheet is recalculated.
RANK.AVG	Returns the rank of a specified value within a list of numbers. The returned rank is relative to the other values in the range. When multiple values have the same rank, the average rank is returned.	(*2)
RANK.EQ	Returns the rank of the specified number in a list of numbers. The returned rank is relative to other values in the range. When multiple values have the same rank, the top rank of those values is returned.	(*2)
RANK	Returns the rank of a specified number in a list of numbers. The rank returned by the RANK function represents the position of that number in the sorted list.	(*2)
RATE	Returns the interest rate over the investment period.
RECEIVED	Returns the amount to be paid at maturity for a fully invested security.
REPLACE	Replaces part of a string with another string.
REPT	Repeats a text string, a specified number of times.
RIGHT	Returns the rightmost character from a text.
ROMAN	Converts Arabic numerals to text representing Roman numerals.
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 the reference.	(*1) Not supported
ROWS	Returns the number of rows in the array.	(*1) Not supported
RSQ	Returns the squared Pearson product moment correlation coefficient using the data points of a regression line that passes through known x and known Y.	(*2)
SEARCH	Searches for a specified character in text and returns the starting position of this character in the text.
SECOND	Returns the seconds value (0-59) of the specified time value.
SERIESSUM	Returns the sign of a number.	(*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 the distribution (the deviation of the data from the mean).	(*2)
SLN	Calculates the depreciation of an asset per period using the straight-line method.
SLOPE	Calculates the slope of the regression line.	(*2)
SMALL	Returns the n-th smallest value in a data set.	(*2)
SQRT	Returns the positive square root of a specified number.
SQRTPI	Returns the positive square root of the value obtained by multiplying the specified number by pi.
STANDARDIZE	Returns the variable used to standardize a distribution determined by a specific mean and standard deviation.
STDEV	Returns the standard deviation based on the set value.	(*2)
STDEV.P	Returns the standard deviation of a population, when the specified numbers represent an entire population (excluding Booleans and Strings).	(*2)
STDEV.S	Returns an estimate of the standard deviation of the population based on the sample, assuming the argument as a sample (ignoring logical values and text in the sample).	(*2)
STDEVA	Calculates the standard deviation based on the specified set of numbers.	(*2)
STDEVP	Calculates standard deviation of an entire population given as an argument.	(*2)
STDEVPA	Calculates standard deviation for an entire population given as an argument.	(*2)
STEYX	Returns the standard error of the predicted y-value for each x. The standard error compute the amount of errors in the predicted of y-value for each x.	(*2)
SUBSTITUTE	Replaces specified characters in an existing text with a new text.
SUBTOTAL	Returns the subtotal.	(*2)
SUM	Returns the sum of a cell or block of cells.	(*2)
SUMIF	Sums up the cell value based on the specified condition.	(*2)
SUMIFS	Sums up the cell value based on multiple conditions.	(*2)
SUMPRODUCT	Calculates the product of corresponding elements in the specified array and returns the sum of these products.	(*2)
SUMSQ	Returns the sum of the squares of the values specified as arguments.	(*2)
SUMX2MY2	Returns the sum of the squared differences of corresponding elements in two arrays.	(*2)
SUMX2PY2	Returns the sum of the squares of corresponding elements in two arrays.	(*2)
SUMXMY2	Sums the squares differences of corresponding elements in two arrays.	(*2)
SWITCH	The SWITCH function evaluates one value (called the expression) against a list of values and returns the result corresponding to the first matching value. If none matches, an optional default value is returned.
SYD	Returns the depreciation expense of an asset for a specific period using the straight-line method.
T	Returns the text if the text is contained in the cell.
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 U.S. Treasury Bill (TB).
TBILLPRICE	Returns the price per $100 par value for a U.S. Treasury Bill (TB).
TBILLYIELD	Returns the yield for US Treasury Bills (TB).
T.DIST	Returns the value of the student’s left-tailed t distribution.
T.DIST.2T	Returns the values of the student’s two-tailed t distribution.
T.DIST.RT	Returns the value of the student's right-tailed t distribution.
TDIST	Returns the probability of the t distribution.
TEXT	Formats a number and converts it to text.
TIME	Returns a DateTime object for the specified time.
TIMEVALUE	Converts a time represented as a string to a decimal.
T.INV	Returns the left-sided inverse of the student's t distribution.
T.INV.2T	Returns the value of the two-tailed inverse of the student's t distribution.
TINV	Calculates the value of the student's t distribution as a function using probabilities and degrees of freedom.
TODAY	Returns a serial number representing the current date.
TRANSPOSE	Returns a horizontal cell range as a vertical cell range, and a vertical cell range as a horizontal cell range.	(*1) Not supported
TREND	Returns the predicted value for the regression line.	(*2)
TRIM	Removes all extra spaces from a text and keep single space between the words.
TRIMMEAN	Calculates the average value of the data in a data set, excluding the top and bottom tails of the data.	(*2)
TRUE	Returns logical value 1 (True).
TRUNC	Returns the probability associated with Student's t-test.
T.TEST	Returns the probability of Student's t-test.	(*2)
TTEST	Returns the probability associated with Student's t-test.	(*2)
TYPE	Returns the data type of a value.
UPPER	Converts text to uppercase.
VALUE	Converts a string representing a number to a number.
VAR	Calculates the variance of the population, assuming argument value as a sample of the population.	(*2)
VAR.P	Returns the population variance (sample variance), assuming argument as the entire population (ignores boolean values and strings in the population).	(*2)
VAR.S	Returns an estimate of the population variance (unbiased variance) based on the sample, assuming argument as a sample of a normal population (ignores logical values and strings in the sample).	(*2)
VARA	Calculates the variance of the population, assuming the argument value as a sample of the population.	(*2)
VARP	Calculates the variance of the entire population.	(*2)
VARPA	Calculates the variance of the entire population.	(*2)
VDB	Calculate the depreciation of an asset for any specified period using the multiplicative method.
VLOOKUP	Searches for a value in the leftmost column of the specified range and returns the value from the same row in the specified column.	(*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 of a date within the year.
WEIBULL	Calculates the Weibull distribution value with two parameters. This is often used for reliability analysis, etc.
WEIBULL.DIST	Returns the Weibull distribution value.
WORKDAY	Returns the total workdays that is the specified number of days before or after the start date.	(*2)
WORKDAY.INTL	Returns the serial number of the date before and after a specified number of working days, using a custom weekend parameter.	(*2)
XIRR	Calculates internal rate of return based on the schedule of cash flows (regular or irregular).	(*2)
XNPV	Calculates the net present value based on the schedule of cash flows (regular or irregular).	(*2)
XOR	Returns the exclusive OR of all arguments.
YEAR	Returns an integer representing the year corresponding to the specified date.
YEARFRAC	Returns the fraction of the year represented by the number of whole days between the start date and the end date.
YIELD	Calculates the yield of security that pays periodic interest.
YIELDDISC	Calculate the annual yield for a discount bond.
YIELDMAT	Calculates the annual yield of a security that pays interest at maturity.
Z.TEST	Returns the P- value of one-tailed z-test.	(*2)
ZTEST	Returns the significance value of the z-test. The z-test generates a standard score for the given test value x for a dataset and returns the probability values for both tail of the normal distribution.	(*2)

Microsoft Excel is a registered trademark of Microsoft Corporation in the United States and other countries.