In This Topic

Function List

In This Topic

This topic lists the functions that are displayed in the **Insert Function** dialog of krewDashboard.

- Functions are used to set conditions for Conditional Formatting of Pivot Table.
- Functions specifying cell range cannot be used.

Function |
Summary |
---|---|

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. |

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. |

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. |

AVERAGE | Returns the average of a specified number. |

AVERAGEA | Returns the average of specified values (including number, string, and logical value). |

AVERAGEIF | Returns the average of the data which meets a specified condition among specified data. |

AVERAGEIFS | Returns the average of the data which meets specified several conditions among specified data. |

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. |

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. |

CHOOSE | Selects one value from a specified list of values. |

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. |

COLUMNS | Returns the number of columns of a specified cell reference. |

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. |

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. |

COUNTA | Returns the number of data values (= number/text/logical value) in a specified array or values. |

COUNTBLANK | Returns the number of empty cells in a specified cell range. |

COUNTIF | Returns the total number of cells which meet a specified condition, in a specified cell range. |

COUNTIFS | Returns the total number of cells which meet specified conditions, in a specified cell range. |

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). |

COVARIANCE.P | Returns population covariance (i.e. the average of the products of deviations for each pair within two supplied data sets). |

COVARIANCE.S | Returns sample covariance (i.e. the average of the products of deviations for each pair within two supplied data sets). |

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. |

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. |

DCOUNTA | Counts the non-blank cells in a column of a list or database that match the specified conditions. |

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. |

DGET | Extracts a single value from a column of a specified list or database that matches specified conditions. |

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. |

DMIN | Returns the smallest number in a column of a list or database that matches the specified conditions. |

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. |

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. |

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. |

DSUM | Returns the sum of the values in a column of a list or database that match the specified conditions. |

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. |

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. |

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 integrated 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). |

EURO | Returns the value corresponding to one euro in the local currency of a country specified by a string (= ISO currency code). For example, "=EURO("ESP")" returns 166.39. ISO currency codes are 3-character codes, including Belgium: BEF, Luxembourg: LUF, Germany: DEM, Spain: ESP, France: FRF, Ireland: IEP, Italy: ITL, Netherlands: NLG, Austria: ATS, Portugal: PTE, Finland: FIM, and Euro member state: EUR. |

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. |

FREQUENCY | Calculates the frequency distribution and returns the vertical array. |

F.TEST | Returns the result of an F-test |

FTEST | Statistical function. Returns the result of the F test. |

FV | Returns the future value of an investment. |

FVSCHEDULE | Returns the future value of an initial principal. |

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. |

GEOMEAN | Returns the geometric mean value. |

GESTEP | Tests whether a specified number is more than or equal to the threshold (= true: 1) or not (= false: 0). |

GROWTH | Returns a growth predicted from an exponential curve. |

HARMEAN | Returns the harmonic mean value. |

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". |

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. |

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. |

INDEX | Returns value of a cell determined by specified relative row and column positions, in an array/table. |

INDIRECT | Specifies a cell indirectly through the string entered in the cell specified by the reference string. |

INT | Rounds a number down to the nearest integer. |

INTERCEPT | Returns the intercept of a regression line. |

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. |

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. |

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. |

KURT | Returns the kurtosis of a specified data set. |

LARGE | Returns the n-th largest value in a specified data set. |

LCM | Returns the least common multiple. |

LEFT | Returns a substring in a target string that contains a specified number of characters from the left edge (i.e. from the beginning). |

LEN | Returns the number of characters in a target string. |

LINEST | Returns an array of the statistic values for a regression line. |

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. |

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. |

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. |

MAX | Returns the maximum value from numbers in specified values or a specified array. |

MAXA | Returns the maximum value from data (= number/text/logical value) in specified values or a specified array. |

MDETERM | Returns the matrix determinant of an array. |

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. |

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. |

MINA | Returns the minimum value from data (= number/text/logical value) in specified values or a specified array. |

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. |

MIRR | Returns the modified internal rate of return based on a series of periodic cash flows. |

MMULT | Returns the matrix product of two arrays. |

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. |

MODE.MULT | Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data. |

MODE.SNGL | Returns the most common value in a data set. |

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. |

NETWORKDAYS.INTL | Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. |

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. |

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. |

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. |

PERCENTILE.EXC | Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive. |

PERCENTILE.INC | Returns the k-th percentile of values in a range. |

PERCENTILE | Statistical function. Returns the n-th percentile of values in a specific range. |

PERCENTRANK.EXC | Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set. |

PERCENTRANK.INC | Returns the percentage rank of a value in a data set. |

PERCENTRANK | Statistical function. Returns the rank of a value in an array as a percentage. |

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. |

PRODUCT | Returns the product of numbers in specified values or a specified array. |

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. |

QUARTILE.EXC | Returns the quartile of the data set, based on percentile values from 0..1, exclusive. |

QUARTILE.INC | Returns the quartile of a data set. |

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. |

RANK.EQ | Returns the rank of a number in a list of numbers. |

RANK | Statistical function. Returns the rank (= position) of a specified number in a specified list of numbers. |

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. |

ROWS | Returns the number of rows of a specified cell reference. |

RSQ | Returns the square of the Pearson product moment correlation coefficient. |

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. |

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). |

SLN | Returns the straight-line depreciation of an asset for one period. |

SLOPE | Returns the slope of the linear regression line. |

SMALL | Returns the n-th smallest value in a data set. |

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. |

STDEV.P | Returns the standard deviation of a population, assuming that specified numbers are an entire population. |

STDEV.S | Returns the standard deviation of a population, assuming that specified number is a sample of the normal population. |

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. |

STDEVP | Statistical function. Returns the standard deviation of a population, assuming the specified numbers as the entire population. |

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. |

STEYX | Returns the standard error of the predicted value on the regression line. |

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. |

SUM | Returns the total. |

SUMIF | Sums up the values of cells that satisfy a specified condition. |

SUMIFS | Sums up the values of cells that satisfy specified conditions. |

SUMPRODUCT | Sums up the products of corresponding elements in specified two arrays. |

SUMSQ | Returns the sum of squares (= square sum). |

SUMX2MY2 | Sums up the square differences of corresponding elements in specified two arrays. |

SUMX2PY2 | Sums up the square sums of corresponding elements in specified two arrays. |

SUMXMY2 | Sums up the squared differences of corresponding elements in specified two arrays. |

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. |

TREND | Returns an array of predicted values on a regression line. |

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. |

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. |

TTEST | Statistical function. Returns the result of the Student's t-test. |

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. |

VAR.P | Returns the population variance (sample variance), assuming that specified value is the entire population. |

VAR.S | Returns an estimate of the population variance (unbiased variance) based on the sample. |

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. |

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. |

VARPA | Returns the variance (= sample variance) of a population, supposing that data (= number/text/logical value) in specified values is an entire population. |

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". |

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). |

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. |

XIRR | Returns the internal rate of return based on an irregular cash flow. |

XNPV | Returns the net present value based on an irregular cash flow. |

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. |

ZTEST | Statistical function. Returns the result of the z test. |

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