| Functions | Min. Version | Description | Arguments |
|---|---|---|---|
Financial Functions | |||
FV | Excel 2003 | Returns the future value of an investment | |
IRR | Excel 2003 | Returns the internal rate of return for a series of cash flows | |
NPV | Excel 2003 | Returns the net present value of an investment based on a series of periodic cash flows and a discount rate | |
PMT | Excel 2003 | Returns the periodic payment for an annuity | |
PV | Excel 2003 | Returns the present value of an investment | |
XIRR | Excel 2003 | Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic | |
XNPV | Excel 2003 | Returns the net present value for a schedule of cash flows that is not necessarily periodic | |
Logical Functions | |||
AND | Excel 2003 | Test multiple conditions with AND | |
BYCOL | Excel 365 | Executes a LAMBDA for each column in an array | array lambda |
BYROW | Excel 365 | Applies a LAMBDA to each row in an array | array lambda |
IF | Excel 2003 | Conditional logic test | |
IFERROR | Excel 2007 | Return value if no error, else alternate value | |
LAMBDA | Excel 365 | Create custom, reusable functions and call them by a friendly name | parameter1parameter2 ... calculation |
LET | Excel 2003 | Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula | |
NOT | Excel 2003 | Reverses the logic of its argument | |
OR | Excel 2003 | Returns TRUE if any argument is TRUE | |
SWITCH | Excel 365 | Evaluates an expression against a list of values and returns the result corresponding to the first matching value. | |
XOR | Excel 2007 | Returns a logical exclusive OR of all arguments | |
Date and Time Functions | |||
DATE | Excel 2003 | Create a date with year, month, and day | year month day |
DATEDIF | Excel 2003 | Calculate the difference between two dates | start_date end_date unit |
DAY | Excel 2003 | Returns the day of a date, represented by a serial number | serial_number |
EOMONTH | Excel 2010 | Returns the serial number of the last day of the month before or after a specified number of months | |
NOW | Excel 2003 | Returns the serial number of the current date and time | |
TODAY | Excel 2003 | Returns the serial number of today's date | |
WEEKDAY | Excel 2003 | Converts a serial number to a day of the week | |
YEARFRAC | Excel 2003 | Returns the year fraction representing the number of whole days between start_date and end_date | |
Lookup and Reference Functions | |||
ADDRESS | Excel 2003 | Returns a reference as text to a single cell in a worksheet | |
CHOOSE | Excel 2003 | Chooses a value from a list of values | |
COLUMN | Excel 2003 | Returns the column number of a reference | |
COLUMNS | Excel 2003 | Returns the number of columns in a reference | |
FILTER | Excel 2003 | Filters a range of data based on criteria you define | |
FORMULATEXT | Excel 2013 | Returns the formula at the given reference as text | |
GETPIVOTDATA | Excel 2003 | Extracts data stored in a PivotTable | |
HLOOKUP | Excel 2003 | Looks in the top row of an array and returns the value of the indicated cell | |
HYPERLINK | Excel 2003 | Creates a shortcut or jump that opens a document stored on your hard drive, a network server, or on the Internet | |
INDEX | Excel 2003 | Returns a value or reference of the cell at the intersection of a particular row and column, in a given range | |
INDIRECT | Excel 2003 | Returns the reference specified by a text string | |
MATCH | Excel 2003 | Returns the relative position of an item in an array that matches a specified value in a specified order | |
OFFSET | Excel 2003 | Returns a reference to a range that is a given number of rows and columns from a given reference | |
ROW | Excel 2003 | Returns the row number of a reference | |
ROWS | Excel 2003 | Returns the number of rows in a reference or array | |
SORT | Excel 2003 | Sorts a range or array | |
TRANSPOSE | Excel 2003 | Converts a vertical range of cells to a horizontal range, or vice versa | |
UNIQUE | Excel 365 | Returns the unique values from a range or array | |
VLOOKUP | Excel 2003 | Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify | |
XLOOKUP | Excel 365 | Searches a range or an array for a match and returns the corresponding item from a second range or array. By default, an exact match is used | |
XMATCH | Excel 365 | Returns the relative position of an item in an array. By default, an exact match is required | |
Math Functions | |||
ABS | Excel 2003 | Returns the absolute value of a number, i.e. a number without its sign | |
AGGREGATE | Excel 2010 | Returns an aggregate in a list or database | |
INT | Excel 2013 | Rounds a number down to the nearest integer | |
MOD | Excel 2003 | Returns the remainder from division | |
PI | Excel 2003 | Returns the value of pi | |
PRODUCT | Excel 2003 | Multiplies its arguments | |
RAND | Excel 2003 | Returns a random number greater than or equal to 0 and less than 1, evenly distributed (changes on recalculation) | |
RANDARRAY | Excel 365 | Returns an array of random numbers | |
RANDBETWEEN | Excel 2003 | Returns a random number between the numbers you specify | |
ROUND | Excel 2003 | Rounds a number to a specified number of digits | |
SIGN | Excel 2003 | Returns the sign of a number | |
SQRT | Excel 2003 | Returns a positive square root | |
SUBTOTAL | Excel 2003 | Returns a subtotal in a list or database | |
SUM | Excel 2003 | Adds its arguments | |
SUMIF | Excel 2003 | Adds the cells specified by a given criteria | |
SUMIFS | Excel 2003 | Adds the cells in a range that meet multiple criteria | |
SUMPRODUCT | Excel 2003 | Returns the sum of the products of corresponding array components | |
TRUNC | Excel 2003 | Truncates a number to an integer by removing the decimal or fractional part of the number | |
Text Functions | |||
CHAR | Excel 2003 | Returns the character specified by the code number from the character set of your computer | |
CONCAT | Excel 2019 | Concatenates a list or range of text trings | |
CONCATENATE | Excel 2003 | Joins several text items into one text string | |
FIND | Excel 2003 | Returns the starting position of one text string within another text string. | |
LEFT | Excel 2003 | Returns the specified number of characters from the start of a text string | |
LEN | Excel 2003 | Returns the number of characters in a text string | |
LOWER | Excel 2003 | Converts all letters in a text string to lowercase | |
MID | Excel 2003 | Returns the characters from the middle of a text string, given a starting position and length | |
PROPER | Excel 2003 | Capitalizes the first letter in each word of a text value | |
REPLACE | Excel 2003 | Replaces part of a text string with a different text string | |
REPT | Excel 2003 | Repeats text a given number of times | |
RIGHT | Excel 2003 | Returns the specified number of characters from the end of a text string | |
SEARCH | Excel 2003 | Returns the number of the character at which a specific character or text string is first found, reading left to right (not case-sensitive) | |
SUBSTITUTE | Excel 2003 | Replaces existing text with new text in a text string | |
TEXT | Excel 2003 | Formats a number and converts it to text | |
TEXTJOIN | Excel 365 | Concatenate a list or range of text strings using a delimiter | |
TRIM | Excel 2003 | Removes all spaces from a text string except for single spaces between words | |
UPPER | Excel 2003 | Converts text to uppercase | |
ARRAYTOTEXT | Excel 365 | Returns an array of text values from any specified range | |
Statistical Functions | |||
AVERAGE | Excel 2003 | Returns the average of its arguments | |
AVERAGEIF | Excel 2003 | Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria | |
AVERAGEIFS | Excel 2013 | Returns the average (arithmetic mean) of all cells that meet multiple criteria | |
COUNT | Excel 2003 | Counts how many numbers are in the list of arguments | |
COUNTA | Excel 2003 | Counts how many values are in the list of arguments | |
COUNTBLANK | Excel 2003 | Counts the number of blank cells within a range | |
COUNTIF | Excel 2003 | Counts the number of cells within a range that meet the given criteria | |
COUNTIFS | Excel 2013 | Counts the number of cells within a range that meet multiple criteria | |
FORECAST.LINEAR | Excel 2003 | Returns a future value based on existing values | |
LARGE | Excel 2003 | Returns the k-th largest value in a data set | |
MAX | Excel 2003 | Returns the maximum value in a list of arguments | |
MAXIFS | Excel 2013 | Returns the maximum value among cells specified by a given set of conditions or criteria | |
MIN | Excel 2003 | Returns the minimum value in a list of arguments | |
MINIFS | Excel 2013 | Returns the minimum value among cells specified by a given set of conditions or criteria. | |
Information Functions | |||
CELL | Excel 2003 | Returns information about the formatting, location, or contents of a cell | |
ISBLANK | Excel 2003 | Returns TRUE if the value is blank | |
ISERROR | Excel 2003 | Returns TRUE if the value is any error value | |
Programming Functions | |||
BYROW | Excel 365 | Applies a LAMBDA to each row in an array | array lambda |
BYCOL | Excel 365 | Executes a LAMBDA for each column in an array | array lambda |
LAMBDA | Excel 365 | Enables creation of custom, named functions | parameter1parameter2 ... calculation |
MAKEARRAY | Excel 365 | Generates an array by applying a LAMBDA to each row and column index | rows cols lambda |
