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.