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

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.