Function List
KrewData Features > Commands > Edit Data > Function List

Following tables describe the functions supported in krewData.

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.

See Also
Edit Data