## Excel Function Reference

Functions alphabetically | Functions by category

Functions are sorted from A to Z, click on a letter to quickly navigate in the table below.

Click on a link to get more detailed information about a function.

Function name Description Category
ABS function Converts negative numbers to positive numbers. Math and trigonometry
ACCRINT function Calculates the accrued interest for a security that pays periodic interest. Financial
ACCRINTM function Calculates the accrued interest for a security that pays interest at maturity. Financial
ACOS function Calculates the arccosine, or inverse cosine, of a number. Math and trigonometry
ACOSH function Calculates the inverse hyperbolic cosine of a number. Math and trigonometry
ACOT function Calculates the inverse cotangent of a number. Math and trigonometry
ACOTH function Calculates the inverse hyperbolic cotangent of a number. Math and trigonometry
ADDRESS function Returns the address of a specific cell, you need to provide a row and column number. Lookup and reference
AGGREGATE function Perform different specific functions to a list or database. Math and trigonometry
AMORDEGRC function Calculates the depreciation for each accounting period. This function is designed for the French accounting system. Financial
AMORLINC function Calculates the depreciation for each accounting period. Financial
AND function Perform a logical test in each argument and if all arguments return TRUE the AND function returns TRUE. Logical
AREAS function Returns the number of cell ranges and single cells in a reference. Lookup and reference
ASC function Converts full-width (double-byte) characters to half-width (single-byte) characters. Text
ASIN function Calculates the arcsine of a number. Math and trigonometry
ASINH function Calculates the inverse hyperbolic sine of a number. Math and trigonometry
ATAN function Calculates the arctangent of a number. Math and trigonometry
ATAN2 function Calculates the arctangent of an angle using specific x- and y-coordinates. Math and trigonometry
ATANH function Calculates the inverse hyperbolic tangent of a number. Math and trigonometry
AVEDEV function Calculates the average of the absolute deviations of data points from their mean. Statistical
AVERAGE function Calculates the average of numbers in a cell range. Statistical
AVERAGEA function Returns the average of a group of values. Text and boolean value FALSE evaluates to 0. TRUE to 1. Statistical
AVERAGEIF function Returns the average of cell values that are valid for a given condition. Statistical
AVERAGEIFS function Returns the average of cell values that evaluates to TRUE for multiple criteria. Statistical
BASE function Converts a number into a text representation with a given radix (base). Math and trigonometry
BETA.DIST function Calculates the beta distribution. Statistical
BETA.INV function Calculates the inverse of the cumulative beta distribution. Statistical
BETADIST function Calculates the beta distribution, it represents outcomes in the form of probabilities. Compatibility
BETAINV function Calculates the inverse of the beta distribution. Compatibility
BIN2DEC function Converts a binary number to the decimal number system. Engineering
BIN2HEX function Converts a binary number to hexadecimal. Engineering
BIN2OCT function Converts a binary number to octal. Engineering
BINOM.DIST function Calculates the individual term binomial distribution probability. Statistical
BINOM.INV function Statistical
BINOMDIST function Calculates the individual term binomial distribution probability Compatibility
BITAND function Calculates a bitwise 'AND' of two numbers. Engineering
BITLSHIFT function Calculates a number whose binary representation is shifted left by a specified number of bits. Engineering
BITOR function Performs a bitwise 'OR' of two numbers. Engineering
BITRSHIFT function Calculates the number where the binary equivalent is shifted right by a specified number of bits and then converted back to a number. Engineering
BITXOR function Calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers. Engineering
CEILING function Rounds a number up to its nearest multiple. Math and trigonometry
CELL function Gets information about the formatting, location, or the contents of a cell. Information
CHAR function Converts a number to the corresponding ANSI character determined by your computers character set. Text
CHIDIST function Calculates the probability of the chi-squared distribution. Compatibility
CHIINV function Calculates the inverse probability of the chi-squared distribution.  Compatibility
CHISQ.DIST function Calculates the probability of the chi-squared distribution, cumulative distribution or probability density. Statistical
CHISQ.DIST.RT function Calculates the right-tailed probability of the chi-squared distribution. Statistical
CHISQ.INV function Calculates the inverse of the left-tailed probability of the chi-squared distribution. Statistical
CHISQ.INV.RT function Calculates the inverse of the right-tailed probability of the chi-squared distribution. Statistical
CHISQ.TEST function Statistical
CHITEST function Compatibility
CHOOSE function Gets a value based on a number. Lookup and reference
CLEAN function Deletes the first 32 nonprinting characters in 7-bit ASCII code in your argument. Text
CODE function Returns the corresponding number for the first character based on your computers character set. (PC- ANSI) Text
COLUMN function Returns the column number of the top-left cell of a cell reference. Lookup and reference
COLUMNS function Calculates the number of columns in a cell range. Lookup and reference
COMBIN function Returns the number of combinations for a specific number of elements out of a larger group. Math and trigonometry
COMBINA function Calculates the number of combinations for a given number of elements from a larger group of elements. Math and trigonometry
COMPLEX function Returns a complex number based on a real and imaginary number. Engineering
CONCAT function Concatenates values from multiple cells. Text
CONCATENATE function Joins text strings. Text
CONFIDENCE function Calculates the confidence interval for a population mean, using a normal distribution. Compatibility
CONFIDENCE.NORM function Calculates the confidence interval for a population mean. Statistical
CONFIDENCE.T function Calculates the confidence range for a population mean using a Student's t distribution. Statistical
CONVERT function Converts a number from one measurement system to another. Engineering
CORREL function Calculates the correlation between two groups of numbers. Statistical
COS function Calculates the cosine of an angle. Math and trigonometry
COSH function Calculates the hyperbolic cosine of a number. Math and trigonometry
COT function Calculates the cotangent of an angle specified in radians. Math and trigonometry
COTH function Calculates the hyperbolic cotangent of a hyperbolic angle. Math and trigonometry
COUNT function Counts all numerical values in an argument. Statistical
COUNTA function Counts the non-empty or blank cells in a cell range. Statistical
COUNTBLANK function Counts empty or blank cells in a range. Statistical
COUNTIF function Calculates the number of cells that is equal to a condition. Statistical
COUNTIFS function Calculates the number of cells across multiple ranges that equals all given conditions. Statistical
COVAR function Calculates the covariance meaning the average of the products of deviations for each pair in two different datasets. Compatibility
COVARIANCE.P function Calculates the covariance meaning the average of the products of deviations for each pair in two different datasets. Statistical
COVARIANCE.S function Calculates the sample covariance meaning the average of the products of deviations for each pair in two different datasets. Statistical
CRITBINOM function Compatibility
CSC function Calculates the cosecant of an angle (radians). Math and trigonometry
CUMIPMT function Calculates the accumulated interest based on a start and end period on a loan. Financial
CUMPRINC function Calculates the accumulated principal based on a start and end period on a loan. Financial
DATE function Returns a number that acts as a date in the Excel environment. Date and Time
DATEDIF function Returns the number of days, months, or years between two dates. The DATEDIF function exists in order to ensure compatibility with Louts 1-2-3. Date and Time
DATEVALUE function Returns an Excel date value (serial number) based on a date stored as text. Date and Time
DAVERAGE function Calculates an average based on values in a list or database that meet specific conditions. Database
DAY function Extracts the day as a number from an Excel date. Date and Time
DAYS function Calculates the number of days between two dates. Date and Time
DB function Calculates the depreciation of an asset for a given period using the fixed-declining balance method. Financial
DCOUNT function Counts cells containing numbers and that meet a condition or criteria. Database
DCOUNTA function Counts nonempty cells in a column you specify, in a database where records also meet a condition or criteria. Database
DDB function Calculates the depreciation of an asset for a given period using the double-declining balance method or based on user input. Financial
DEC2BIN function Converts a decimal number to a binary number. Engineering
DEC2HEX function Converts a decimal number to a hexadecimal number. Engineering
DEC2OCT function Converts a decimal number to an octal number. Engineering
DECIMAL function Converts a text representation of a number in a given base into a decimal number. Math and trigonometry
DEGREES function Calculates degrees from radians. Math and trigonometry
DELTA function Evaluates whether two numerical values are equal. Engineering
DGET function Fetches a value from a column in a database whose records meet a condition or criteria. Database
DMAX function Extracts the maximum number from a column in a database whose records match a condition or criteria. Database
DMIN function Extracts the smallest number from a column in a database whose records match a condition or criteria. Database
DOLLARFR function Converts a decimal number to its equivalent in fractional numbers, used in securities denominated in dollars. Financial
DPRODUCT function Multiplies numbers that match a condition or criteria in a database. Database
DSTDEV function Calculates an estimation of the standard deviation based on a sample of a population. The function also allows you to specify criteria applied to a database. Database
DSTDEVP function Calculates the standard deviation based on a population. The function also allows you to specify criteria applied to a database. Database
DSUM function Adds numbers in a database/list that meets a condition or criteria. Database
DVARP function Returns the variance of an entire population. The numbers are in a column of records in a dataset or database that meets a given condition or criteria. Database
EDATE function Returns a date determined by a start date and a number representing how many months. Date and Time
EFFECT function Calculates the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year. Financial
ENCODEURL function Returns a URL-encoded string. Web
EOMONTH function Returns an Excel date for the last day of a given month using a number and a start date. Date and Time
ERROR.TYPE function Returns a number that represents one of the error values in Excel. Information
EVEN function Rounds a number up to the nearest even whole number. Math and trigonometry
EXACT function Checks if two values are precisely the same, it returns TRUE or FALSE. The EXACT function also considers upper case and lower case letters. Text
EXP function Returns e raised to the power of a number, e equals 2.71828182845904. Math and trigonometry
EXPON.DIST function Calculates the exponential distribution representing an outcome in the form of probability. Statistical
EXPONDIST function Compatibility
F.DIST function Calculates the F probability for two tests. Statistical
F.DIST.RT function Calculates the right-tailed F probability for two tests. Statistical
F.TEST function Calculates the two-tailed probability from an F-test Statistical
FACT function Returns the factorial of a number. Math and trigonometry
FACTDOUBLE function Returns the double factorial of a number. Math and trigonometry
FALSE function Returns the logical (boolean) value FALSE. Logical
FDIST function Calculates the F probability of the right-tailed distribution for two tests. Compatibility
FIND function Returns the position of a specific string in another string, reading left to right. Note, the FIND function is case-sensitive. Text
FIXED function Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. Text
FLOOR function Rounds a number down, toward zero, to the nearest multiple of significance. Compatibility
FLOOR.MATH function Rounds a number down to the nearest integer or to the nearest multiple of significance. Math and trigonometry
FLOOR.PRECISE function Rounds a number down to the nearest integer or nearest multiple of significance. Math and trigonometry
FORECAST function Calculates a value based on existing x and y values using linear regression. Use this function to predict linear trends. Compatibility
FORECAST.LINEAR function Calculates a value based on existing x and y values using linear regression. Statistical
FORMULATEXT function Returns a formula as a text string. Lookup and reference
FREQUENCY function Calculates how often values occur within a range of values and then returns a vertical array of numbers. Statistical
FTEST function Calculates the value from an F-test. The value shows if the variances from two data sets are not significantly different. Compatibility
FV function Returns the future value of an investment based on a constant interest rate. Financial
GAMMA function Calculates the GAMMA value. Statistical
GAMMA.DIST function Calculates the gamma often used in queuing analysis (probability statistics) that may have a skewed distribution. Statistical
GAMMADIST function Calculates the gamma often used in queuing analysis (probability statistics). Compatibility
GCD function Calculates the greatest common divisor that divides all given arguments without a remainder. Math and trigonometry
GEOMEAN function Calculates the geometric mean. Statistical
GROWTH function Returns estimated exponential growth based on given data. Statistical
HLOOKUP function Searches the top row in a data range for a value and return another value on the same column in a row you specify. Lookup and reference
HOUR function Returns an integer representing the hour of an Excel time value. Date and Time
IF function Returns one value if the logical test is TRUE and another value if the logical test is FALSE. Logical
IFERROR function If the value argument returns an error, the value_if_error argument is used. If the value argument does NOT return an error, the IFERROR function returns the value argument. Logical
IFNA function Handles #N/A errors only, it returns a specific value if the formula returns a #N/A error. Logical
IFS function Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. Logical
INDEX function Returns a value from a cell range, you specify which value based on a row and column number. Lookup and reference
INDIRECT function Returns the cell reference based on a text string and shows the content of that cell reference. Lookup and reference
INFO function Returns information about the current operating environment, file path, number of active worksheets, Excel version etc. Information
INT function Removes the decimal part from positive numbers and returns the whole number (integer) except negative values are rounded down to the nearest integer. Math and trigonometry
INTERCEPT function Returns a value representing the y-value where a line intersects the y-axis. Statistical
IPMT function Calculates the interest payment for a specific period for an investment based on repeated constant payments and a constant interest rate. Financial
ISBLANK function Returns TRUE if the argument is an empty cell, returns FALSE if not. Information
ISERR function Returns TRUE if a cell returns an error, except error value #N/A. Information
ISERROR function Returns TRUE if a cell contains an error. Information
ISFORMULA function Returns TRUE if a cell contains a formula, FALSE if text, number or boolean value. Information
ISLOGICAL function Returns TRUE if value is boolean. A boolean value is either TRUE or FALSE. Information
ISNA function Returns TRUE if value is a #N/A error. Information
ISNONTEXT function Returns TRUE if value is not text, also returns TRUE if cell is empty. Information
ISNUMBER function Checks if a value is a number, returns TRUE or FALSE. Information
ISODD function Returns TRUE if a cell contains an odd number, FALSE if even number. Information
ISPMT function Calculates the interest paid during a specific period of an investment. Financial
ISREF function Returns TRUE if value refers to a reference. Information
ISTEXT function Returns TRUE if argument is text. Information
LARGE function Calculates the k-th largest value from an array of numbers. Statistical
LCM function Calculates the least common multiple. The least common multiple is the smallest positive integer that is a multiple of all integer arguments. Use the LCM function to find fractions with different denominators. Math and trigonometry
LEFT function Extracts a specific number of characters always starting from the left. Text
LEN function Returns the number of characters in a cell value. Text
LINEST function Returns an array of values representing the parameters of a straight line based on the "least squares" method. Statistical
LN function Calculates the natural logarithm of a number. Natural logarithms are based on the constant e. Math and trigonometry
LOG function Calculates the logarithm of a number to a specific base. Math and trigonometry
LOG10 function Calculates the logarithm of a number using the base 10. Math and trigonometry
LOGEST function Statistical
LOGNORM.DIST function Calculates the lognormal distribution of argument x, based on a normally distributed ln(x) with the arguments of mean and standard_dev. Statistical
LOGNORMDIST function Calculates the cumulative lognormal distribution of argument x, based on a normally distributed ln(x) with the arguments of mean and standard_dev. Compatibility
LOOKUP function Find a value in a cell range and return a corresponding value on the same row. Lookup and reference
LOWER function Converts a value to lower case letters. Text
MATCH function Returns the relative position of an item in an array that matches a specified value in a specific order. Lookup and reference
MAX function Calculate the largest number in a cell range. Statistical
MAXIFS function Calculates the highest value based on a condition or criteria. Statistical
MEDIAN function Calculates the median based on a group of numbers. The median is the middle number of a group of numbers. Statistical
MID function Returns a substring from a string based on the starting position and the number of characters you want to extract. Text
MIN function Returns the smallest number in a cell range. Statistical
MINA function Returns the smallest number. Text values and blanks are ignored, boolean value TRUE evaluates to 1 and FALSE to 0 (zero). Statistical
MINIFS function Calculates the smallest value based on a given set of criteria. Statistical
MINUTE function Returns a whole number representing the minute based on an Excel time value. The returned number is ranging from 0 to 59. Date and Time
MINVERSE function Calculates the inverse matrix for a given array. Math and trigonometry
MMULT function Calculates the matrix product of two arrays, an array as the same number of rows as array1 and columns as array2. Math and trigonometry
MOD function Returns the remainder after a number is divided by divisor. Math and trigonometry
MODE function Calculates the most frequent number in a cell range. Compatibility
MODE.MULT function Returns the most frequent number in a cell range. It will return multiple numbers if they are equally frequent. Statistical
MODE.SNGL function Calculates the most frequent value in an array or range of data. Statistical
MONTH function Extracts the month as a number from an Excel date. Date and Time
MROUND function Calculates a number rounded to a given multiple. Math and trigonometry
MULTINOMIAL function Calculates the ratio of the factorial of a sum of values to the product of factorials. Math and trigonometry
MUNIT function Calculates the identity matrix for a given dimension Math and trigonometry
N function Returns a value converted into a number. Information
NA function Returns the error value #N/A meaning "value is not available". Information
NETWORKDAYS function Returns the number of working days between two dates, excluding weekends. It also allows you to ignore a list of holiday dates that you can specify. Date and Time
NETWORKDAYS.INTL function Calculates the number of working days between two dates, excluding weekends. Date and Time
NOMINAL function Calculates the nominal annual interest rate based on the effective rate and the number of compounding periods per year. Financial
NORM.DIST function Calculates the normal distribution for a given mean and standard deviation. Statistical
NORM.INV function Calculates the inverse of the normal cumulative distribution for a given mean and standard deviation. Statistical
NOT function Returns the boolean opposite to the given argument. Logical
NOW function Returns the current date and time. Date and Time
OFFSET function Returns a reference to a range that is a given number of rows and columns from a given reference. Lookup and reference
OR function Evaluates a logical expression in each argument and if at least one argument returns TRUE the OR function returns TRUE. If all arguments return FALSE the OR function also returns FALSE. Logical
PDURATION function Calculates how many periods required by an investment to reach a given amount based on a rate in percentage. Financial
PERCENTRANK function Compatibility
PERCENTRANK.EXC function Statistical
PERCENTRANK.INC function Statistical
PERMUT function Returns the number of permutations for a set of elements that can be selected from a larger number of elements. Statistical
PERMUTATIONA function Returns the number of permutations for a specific number of elements that can be selected from a larger group of elements. Statistical
PHI function Calculates a number of the density function for a standard normal distribution. Statistical
PI function Returns the number pi (¶). Math and trigonometry
PMT function Returns the payment needed for borrowing a fixed sum of money based on constant payments and interest rate. Financial
POWER function Calculates a number raised to a power. Math and trigonometry
PPMT function Calculates the principal payment for a specific period for an investment based on repeated constant payments and a constant interest rate. Financial
PRICEMAT function Calculates the price per \$100 nominal value of a bond that pays interest at maturity. Financial
PROB function Statistical
PRODUCT function Returns the product of the numbers given in the argument. Math and trigonometry
QUARTILE function Compatibility
QUARTILE.EXC function Returns the quartile of a data set. Statistical
QUARTILE.INC function Returns the quartile of a data set, based on percentile values from 0..1, inclusive. Statistical
QUOTIENT function Returns the integer portion of a division. Math and trigonometry
RAND function Calculates a random real number greater than or equal to 0 and less than 1. Math and trigonometry
RANDBETWEEN function Returns a random whole number between the numbers you specify. Math and trigonometry
RANK function Calculates the rank of a specific number compared to a list of numbers. Compatibility
RANK.AVG function Returns the rank of a number out of a list of numbers. Statistical
RANK.EQ function Calculates the rank of a number in a list of numbers, based on its position if the list were sorted. Statistical
RATE function Returns the interest rate per period of an annuity. Financial
REPT function Repeats a specific text a chosen number of times. Text
RIGHT function Extracts a specific number of characters always starting from the right. Text
ROUNDDOWN function Rounds a number down. Math and trigonometry
ROUNDUP function Calculates a number rounded up. Math and trigonometry
ROW function Calculates the row number of a cell reference. Lookup and reference
ROWS function Calculate the number of rows in a cell range. Lookup and reference
RRI function Financial
SEARCH function Returns the number of the character at which a specific character or text string is found reading left to right (not case-sensitive) Text
SEC function Calculates the secant of an angle. Math and trigonometry
SECH function Calculates the hyperbolic secant of an angle. Math and trigonometry
SECOND function Returns an integer representing the second based on an Excel time value Date and Time
SERIESSUM function Calculates the sum of a power series based on a formula. Math and trigonometry
SHEET function Returns the sheet number of the cell reference sheet. Information
SHEETS function Returns the number of sheets in a reference. Information
SIGN function Returns the sign of a number. 1 for a positiv number, 0 (zero) for a 0 (zero) and -1 for a negative number. Math and trigonometry
SIN function Calculates the sine of an angle. Math and trigonometry
SINH function Calculates the hyperbolic sine of a number. Math and trigonometry
SKEW function Calculates the skewness of a group of values. Statistical
SLOPE function Calculates the slope of the linear regression line through coordinates. Statistical
SMALL function Returns the k-th smallest value from a group of numbers. Statistical
SQRT function Calculates the positive square root. Math and trigonometry
STANDARDIZE function Calculates a normalized value from a distribution characterized by mean and standard_dev. Statistical
STDEV function Calculates the standard deviation of a group of values. Compatibility
STDEV.P function Returns standard deviation based on the entire population. Statistical
STDEV.S function Returns standard deviation based on a sample of the entire population. Statistical
STDEVA function Estimates the standard deviation from a sample of values. Statistical
STDEVPA function Returns the standard deviation based on the entire population, including text and logical values. Statistical
SUBSTITUTE function Replaces a specific text string in a value. Case sensitive. Text
SUBTOTAL function Returns a subtotal from a list or database, you can choose from a variety of arguments that determine what you want the function to do. Math and trigonometry
SUM function Allows you to add numerical values, the function returns the sum in the cell it is entered in. The SUM function is cleverly designed to ignore text and boolean values, adding only numbers. Math and trigonometry
SUMIF function Sums numerical values based on a condition. Math and trigonometry
SUMIFS function Adds numbers based on criteria. Math and trigonometry
SUMPRODUCT function Calculates the product of corresponding values and then returns the sum of each multiplication. Math and trigonometry
SUMSQ function Calculates the sum of the squares of the arguments. Math and trigonometry
SUMX2MY2 function Calculates the sum of the difference of squares of corresponding values in two arrays. Math and trigonometry
SUMX2PY2 function Calculates the sum of the sum of squares of corresponding values in two arrays. Math and trigonometry
SUMXMY2 function Calculates the sum of squares of differences of corresponding values in two arrays. Math and trigonometry
SWITCH function Returns a given value determined by an expression and a list of values. Logical
SYD function Calculates the yearly asset depreciation of a given year. Financial
T function Returns a text value if the argument is a text value. Text
TAN function Calculates the tangent of an angle. Math and trigonometry
TANH function Calculates the hyperbolic tangent of a number. Math and trigonometry
TBILLPRICE function Calculates the par amount (face value) for a Treasury bill. Financial
TBILLYIELD function Calculates the yield for a Treasury bill. Financial
TEXT function Converts a value to text in a specific number format. Text
TEXTJOIN function Combine text strings from multiple cell ranges. Text
TIME function Returns a decimal value between 0 (zero) representing 12:00:00 AM and 0.99988426 representing 11:59:59 P.M. Date and Time
TIMEVALUE function Returns a decimal number based on a text string. Date and Time
TODAY function Returns the Excel date (serial number) of the current date. Date and Time
TRANSPOSE function Converts a vertical range to a horizontal range, or vice versa. Lookup and reference
TREND function Calculates values along a linear trend. Statistical
TRIM function Deletes all blanks or space characters except single blanks between words in a cell value. Text
TRIMMEAN function Calculates the mean of the interior of a data set. Statistical
TRUE function Returns the logical (boolean) value TRUE. Logical
TRUNC function Removes the fractional part of the number to an integer. Math and trigonometry
TYPE function Use TYPE to find out what type of data is returned by a function or formula. Information
UNICHAR function Calculates a character based on a Unicode number. Text
UNICODE function Returns a Unicode number based on a character. Text
UPPER function Converts a value to upper case letters. Text
VALUE function Converts a text string that represents a number to a number. Text
VAR.P function Returns the variance based on the entire population. The function ignores logical and text values. Statistical
VAR.S function The VAR.S function tries to estimate the variance based on a sample of the population. The function ignores logical and text values. Statistical
VDB function Calculates the depreciation of an asset for a given period using the double-declining balance method or based on user input, you may use partial periods in this function. Financial
VLOOKUP function Lets you search the leftmost column for a value and return another value on the same row in a column you specify. Lookup and reference
WEBSERVICE function Gets data from a web service on the Internet or Intranet. Web
WEEKDAY function Converts a date to a weekday number from 1 to 7. Date and Time
WEEKNUM function Calculates a given date's week number based on a return_type parameter that determines which day the week begins. Date and Time
WORKDAY function Returns a date based on a start date and a given number of working days (nonweekend and nonholidays). Date and Time
XNPV function Financial
XOR function Calculates the logical exclusive OR meaning if at least one of the arguments evaluates to TRUE then the XOR returns TRUE. All arguments must be evaluated to FALSE for the XOR function to return FALSE. Logical
YEAR function Converts a date to a number representing the year in the date. Date and Time
YEARFRAC function Returns the fraction of the year based on the number of whole days between a start date and an end date. Date and Time
YIELD function Calculates the yield for a security that pays interest. The YIELD function is designed to calculate the bond yield. Financial