This section lists and explains the functions that is shown in Insert Function dialog.

Function	Overview
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.
AREAS	Returns the number of areas in a specified range.
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.
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.
BETAINV	Statistical function. Returns the inverse function value of the cumulative β distribution function.
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.
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.
CHOOSE	Selects one value from the specified list of values.
CLEAN	Removes all nonprintable characters from the specified text.
CODE	Returns a number (= character code) for the first character in the specified string.
COLUMN	Returns the column number of the specified cell reference.
COLUMNS	Returns the number of columns of the 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.
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 a 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).
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 using the fixed-declining balance method.
DBCS	Converts half-width (single-byte) characters in a string to full-width (double-byte) characters.
DCOUNT	Counts the cells that contain numbers in a column of records in a specified list/database that match specified conditions.
DCOUNTA	Counts the nonblank cells in a column of records in a specified list/database that match 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 maximum value in a column of records in a specified list/database that match specified conditions.
DMIN	Returns the minimum value in a column of records in a specified list/database that match 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 specified field values in a column of records in a specified list/database that match specified conditions.
DSTDEV	Calculates the standard deviation of a population based on a sample made up of the numbers in a column of records in a specified list/database that match specified conditions.
DSTDEVP	Calculates the standard deviation of a population based on the entire population made up of the numbers in a column of records in a specified list/database that match specified conditions.
DSUM	Returns the sum of the values in a column of records in a specified list/database that match 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 records in 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 of records 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	Returns an integrated value of the error function.
ERFC	Returns an integrated value of the complementary error function.
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 local 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.
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).
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.
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.
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 is replaced with FORECAST.LINEAR in Excel 2016.
FREQUENCY	Calculates the frequency distribution and returns the vertical array.
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.
GAMMADIST	Statistical function. Returns the value of the 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.
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).
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.
IFS	Tests whether one or more conditions are satisfied and returns a value that corresponds to the first TRUE condition. This function is not available in Excel 2016 for Mac.
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 the 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 product of specified complex numbers.
IMREAL	Returns the real coefficient of specified complex numbers.
IMSIN	Returns the sine of a specified complex numbers.
IMSQRT	Returns the square root of a specified complex numbers.
IMSUB	Returns the difference of specified two complex numbers.
IMSUM	Returns the sum of specified complex numbers.
INDEX	Returns the value of a cell determined by specified relative row and column positions, in an array/table.
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 Boolean 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.
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.
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.
LENB	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.
LOGNORMDIST	Statistical function. Returns the value of the cumulative lognormal 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 the 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.
MAXIFS	Returns the maximum value in a cell specified by a condition set.
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.
MINIFS	Returns the minimum value in a cell specified by a condition set.
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.
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).
NEGBINOMDIST	Statistical function. Returns the 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.
NOMINAL	Returns the nominal annual interest rate.
NORMDIST	Statistical function. Returns the value of the cumulative normal distribution function.
NORMINV	Returns the inverse function value of the cumulative normal distribution function.
NORMSDIST	Statistical function. Returns the value of the cumulative standard normal distribution function.
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 par value of a security having an odd last period.
ODDLYIELD	Returns the yield of a security having 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	Statistical function. Returns the n-th percentile of values in a specific range.
PERCENTRANK	Statistical function. Returns the rank of a value in an array as a percentage.
PERMUT	Returns the number of permutations when a specified number of items are selected from samples.
PI	Returns "π" (pi).
PMT	Returns the regular payment amount for a loan.
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 the first characters of alphabetical words in a target string to uppercase.
PV	Returns the present value of an investment.
QUARTILE	Statistical function. Returns the quartile of data values in an array.
QUOTIENT	Returns the integer part of the quotient of a division.
RADIANS	Converts a specified angle in degrees to radian.
RAND	Returns a random number greater than or equal to 0 and smaller than 1.
RANDBETWEEN	Returns a random integer number in a specified range.
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 the specified cell reference.
ROWS	Returns the number of rows of the specified cell reference.
RSQ	Returns the square value of the Pearson's 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 depreciation of an asset for one period using the straight-line method.
SLOPE	Returns the slope of a linear regression line.
SMALL	Returns the n-th smallest value in specified data values.
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.
STDEVA	Returns the estimated standard deviation of a population based on a sample, supposing that data (= number/text/logical value) in specified values is a sample of a normal population.
STDEVP	Statistical function. Returns the standard deviation of a population, supposing that specified numbers are an entire population.
STDEVPA	Returns the standard deviation of a population, supposing that data (= number/text/logical value) in specified values is an entire population.
STEYX	Returns the standard error of the predicted value on a 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.
SWITCH	Evaluates an expression against a list of values and returns the result that corresponds to the first matching value. If no match is found, an optional default value is returned. This function is not available in Excel 2016 for Mac.
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).
TDIST	Statistical function. Returns the probability of the Student's t distribution.
TEXT	Converts a target number to a string of a specified format.
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.
TINV	Returns the inverse function value 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.
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 a 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.
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 the 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.
ZTEST	Statistical function. Returns the result of the z test.

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