Excel Functions
Search and filter all relevant Excel functions in seconds.
Learn how to use them with our straightforward explanations and easy-to-understand examples.
Function | Min. Version | Description | Arguments |
---|---|---|---|
LOGICAL | |||
LogicalTop Fundamentals AND | Excel 2003 | Test multiple conditions with AND | logical1 logical2 ... |
Logical FALSE | Excel 2003 | Generate the logical value FALSE | |
LogicalTop Fundamentals IF | Excel 2003 | Conditional logic test | logical_test value_if_true value_if_false |
LogicalTop Advanced IFERROR | Excel 2003 | Return value if no error, else alternate value | value value_if_error |
LogicalTop Advanced IFNA | Excel 2013 | Return value if not #N/A error | value value_if_na |
LogicalTop Advanced IFS | Excel 2019 | Checks multiple conditions and returns a value | condition1 value1 condition2, value2 ... |
LogicalTop Fundamentals NOT | Excel 2003 | Invert logical value | logical |
LogicalTop Fundamentals OR | Excel 2003 | Test multiple conditions with OR | logical1 logical2 ... |
LogicalTop Advanced SWITCH | Excel 2016 | Evaluate expressions against list of values | expression value1 result1 value2, result2 ... default |
Logical TRUE | Excel 2003 | Generate the logical value TRUE | |
Logical XOR | Excel 2013 | Exclusive OR of all arguments | logical1 logical2 ... |
DATE AND TIME | |||
Date and TimeTop Fundamentals DATE | Excel 2003 | Create a date with year, month, and day | year month day |
Date and Time DATEDIF | Excel 2003 | Calculate the difference between two dates | start_date end_date unit |
Date and Time DATEVALUE | Excel 2003 | Converts a date in text to a serial number | date_text |
Date and Time DAY | Excel 2003 | Returns the day of a date, represented by a serial number | serial_number |
Date and TimeTop Advanced DAYS | Excel 2013 | Calculates the number of days between two dates | end_date start_date |
Date and Time DAYS360 | Excel 2003 | Calculates the number of days between two dates based on a 360-day year | start_date end_date method |
Date and Time EDATE | Excel 2003 | Adds a specified number of months to a date | start_date months |
Date and Time EOMONTH | Excel 2003 | Returns the last day of the month after adding a specified number of months | start_date months |
Date and Time HOUR | Excel 2003 | Converts a serial number to an hour | serial_number |
Date and Time ISOWEEKNUM | Excel 2013 | Returns the ISO week number of the year for a given date | date |
Date and Time MINUTE | Excel 2003 | Converts a serial number to a minute | serial_number |
Date and Time MONTH | Excel 2003 | Converts a serial number to a month | serial_number |
Date and TimeTop Advanced NETWORKDAYS | Excel 2003 | Calculates the number of whole workdays between two dates | start_date end_date holidays |
Date and Time NETWORKDAYS.INTL | Excel 2010 | Calculates the number of whole workdays between two dates with custom weekend parameters | start_date end_date weekend holidays |
Date and TimeTop Advanced NOW | Excel 2003 | Returns the current date and time | |
Date and Time SECOND | Excel 2003 | Returns seconds from a time value | serial_number |
Date and Time TIME | Excel 2003 | Creates a time from hour, minute, and second | hour minute second |
Date and Time TIMEVALUE | Excel 2003 | Converts a time in text to a serial number | time_text |
Date and TimeTop Advanced TODAY | Excel 2003 | Returns the current date | |
Date and TimeTop Advanced WEEKDAY | Excel 2003 | Returns the day of the week for a date | serial_number return_type |
Date and TimeTop Advanced WEEKNUM | Excel 2003 | Returns the week number for a date | serial_number return_type |
Date and TimeTop Advanced WORKDAY | Excel 2003 | Returns the date before or after a specified number of workdays | start_date days holidays |
Date and Time WORKDAY.INTL | Excel 2010 | Returns the date before or after a specified number of workdays with custom weekend parameters | start_date days weekend holidays |
Date and Time YEAR | Excel 2003 | Returns the year from a date value | serial_number |
Date and Time YEARFRAC | Excel 2003 | Calculates the fraction of the year between two dates | start_date end_date basis |
LOOKUP AND REFERENCE | |||
Lookup and ReferenceTop Advanced ADDRESS | Excel 2003 | Returns a cell reference as text | row_num column_num abs_num a1 sheet_text |
Lookup and Reference AREAS | Excel 2003 | Returns the number of areas in a reference | reference |
Lookup and Reference CHOOSE | Excel 2003 | Chooses a value from a list of values | index_num value1 value2 ... |
Lookup and Reference CHOOSECOLS | Excel 365 | Extracts specified columns from an array | array col_num1 col_num2 ... |
Lookup and Reference CHOOSEROWS | Excel 365 | Extracts specified rows from an array | array row_num1 row_num2 ... |
Lookup and ReferenceTop Advanced COLUMN | Excel 2003 | Returns the column number of a reference | reference |
Lookup and Reference COLUMNS | Excel 2003 | Returns the number of columns in a reference | array |
Lookup and Reference DROP | Excel 365 | Excludes rows or columns from an array's start or end | array rows columns |
Lookup and Reference EXPAND | Excel 365 | Alters array size to specific row and column dimensions | array rows columns pad_with |
Lookup and Reference FIELDVALUE | Excel 365 | Returns value from a record in a data set | value field_name |
Lookup and ReferenceTop NextGen FILTER | Excel 365 | Filters array using a Boolean (True/False) criteria | array include if_empty |
Lookup and Reference FORMULATEXT | Excel 2013 | Returns a formula as a string | reference |
Lookup and Reference GETPIVOTDATA | Excel 2003 | Returns data stored in a PivotTable | data_field pivot_table [field1, item1] ... |
Lookup and Reference HLOOKUP | Excel 2003 | Searches for a value in the top row and returns a value in the same column | lookup_value table_array row_index_num range_lookup |
Lookup and ReferenceTop NextGen HSTACK | Excel 365 | Combines arrays horizontally into a larger array | array1 array2 ... |
Lookup and Reference HYPERLINK | Excel 2003 | Creates a shortcut or jump to another location | link_location friendly_name |
Lookup and ReferenceTop Advanced INDEX | Excel 2003 | Uses an index to choose a value from a reference or array | array row_num col_num area_num |
Lookup and ReferenceTop Advanced INDIRECT | Excel 2003 | Returns a reference indicated by a text value | ref_text a1 |
Lookup and Reference LOOKUP | Excel 2003 | Looks up values in a vector or array | lookup_value lookup_vector result_vector |
Lookup and ReferenceTop Advanced MATCH | Excel 2003 | Searches for a value in an array and returns the relative position | lookup_value lookup_array match_type |
Lookup and ReferenceTop Advanced OFFSET | Excel 2003 | Returns a reference offset from a given starting point | reference rows cols height width |
Lookup and ReferenceTop Advanced ROW | Excel 2003 | Returns the row number of a reference | reference |
Lookup and Reference ROWS | Excel 2003 | Returns the number of rows in a reference | array |
Lookup and ReferenceTop NextGen SORT | Excel 365 | Sorts array elements in specified order and shape | array sort_index sort_order by_col |
Lookup and Reference SORTBY | Excel 365 | Sorts an array based on values in a corresponding range | array by_array1 sort_order1 by_array2 sort_order2 ... |
Lookup and Reference TAKE | Excel 365 | Returns specified contiguous rows or columns from an array | array rows columns |
Lookup and Reference TOCOL | Excel 365 | Converts an array into a single-column array | array ignore scan_by_column |
Lookup and Reference TOROW | Excel 365 | Converts an array to a single row array | array ignore scan_by_column |
Lookup and Reference TRANSPOSE | Excel 2003 | Transposes the rows and columns of an array | array |
Lookup and ReferenceTop NextGen UNIQUE | Excel 365 | Extracts unique values from a specified array | array by_col exactly_once |
Lookup and ReferenceTop Fundamentals VLOOKUP | Excel 2003 | Looks up a value in a table by matching on the first column | lookup_value array col_index range_lookup |
Lookup and ReferenceTop NextGen VSTACK | Excel 365 | Vertically combines multiple arrays into one | array1 array2 ... |
Lookup and Reference WRAPCOLS | Excel 365 | Wraps row/column values by columns after a specified count | vector wrap_count pad_with |
Lookup and Reference WRAPROWS | Excel 365 | Wraps row/column values by rows after a specified count | vector wrap_count pad_with |
Lookup and ReferenceTop NextGen XLOOKUP | Excel 365 | Looks up values in range or array | lookup_value lookup_array return_array if_not_found match_mode search_mode |
Lookup and Reference XMATCH | Excel 365 | Returns relative position of an item in an array | lookup_value lookup_array match_mode search_mode |
MATH | |||
MathTop Advanced ABS | Excel 2003 | Returns the absolute value of a number | number |
Math AGGREGATE | Excel 2010 | Applies functions to lists or databases, ignoring errors and hidden rows | function_num options ref1 ref2 ... |
Math BASE | Excel 2013 | Converts a number into a text representation with the given base | number radix min_length |
MathTop Advanced CEILING | Excel 2003 | Rounds a number up to the nearest multiple of significance | number significance |
Math CEILING.MATH | Excel 2013 | Rounds a number up, to the nearest integer or multiple of significance | number significance mode |
Math EXP | Excel 2003 | Returns e raised to the power of a given number | number |
MathTop Advanced FLOOR | Excel 2003 | Rounds a number down, toward zero | number significance |
Math FLOOR.MATH | Excel 2013 | Rounds a number down, to the nearest integer or multiple of significance | number significance mode |
Math LN | Excel 2003 | Returns the natural logarithm of a number | number |
Math LOG | Excel 2003 | Returns the logarithm of a number to a specified base | number base |
Math LOG10 | Excel 2003 | Returns the base-10 logarithm of a number | number |
Math MOD | Excel 2003 | Returns the remainder from division | number divisor |
Math POWER | Excel 2003 | Raise a number to the power of another number | number power |
Math PRODUCT | Excel 2003 | Multiply all the numbers given as arguments | number1 number2 ... |
Math QUOTIENT | Excel 2003 | Return the integer portion of a division | numerator denominator |
Math RAND | Excel 2003 | Return a random number greater than or equal to 0 and less than 1 | |
Math RANDARRAY | Excel 365 | Returns an array of random numbers | rows columns min max integer |
Math RANDBETWEEN | Excel 2007 | Return a random number between the numbers you specify | bottom top |
Math ROUND | Excel 2003 | Round a number to a specified number of digits | number num_digits |
Math ROUNDDOWN | Excel 2003 | Round a number down, toward zero | number num_digits |
Math ROUNDUP | Excel 2003 | Rounds a number away from zero | number num_digits |
Math SEQUENCE | Excel 365 | Generates a list or matrix of sequential numbers | rows columns start step |
Math SIGN | Excel 2003 | Returns the sign of a number | number |
Math SQRT | Excel 2003 | Returns the square root of a number | number |
Math SUBTOTAL | Excel 2003 | Returns a subtotal in a list or database | function_num ref1 ref2 ... |
MathTop Fundamentals SUM | Excel 2003 | Adds all the numbers in a range of cells | number1 number2 ... |
MathTop Fundamentals SUMIF | Excel 2003 | Adds the cells specified by a given condition or criteria | range criteria sum_range |
Math SUMIFS | Excel 2007 | Adds the cells in a range that meet multiple criteria | sum_range criteria_range1 criteria1 criteria_range2, criteria2 ... |
MathTop Advanced SUMPRODUCT | Excel 2003 | Multiplies corresponding components in the given arrays, and returns the sum of those products | array1 array2 ... |
Math TRUNC | Excel 2003 | Truncates a number to an integer by removing the fractional part of the number | number num_digits |
TEXT | |||
Text ARRAYTOTEXT | Excel 365 | Converts a range of values to an array of texts | array format |
TextTop Advanced CLEAN | Excel 2003 | Removes all non-printable characters from text | text |
TextTop Advanced CONCAT | Excel 2019 | Combines the text from multiple ranges and/or strings | text1 text2 ... |
Text CONCATENATE | Excel 2003 | Combines the text from multiple ranges and/or strings, but does not provide delimiter or IgnoreEmpty arguments | text1 text2 ... |
Text EXACT | Excel 2003 | Checks whether two text strings are exactly the same | text1 text2 |
TextTop Advanced FIND | Excel 2003 | Finds one text value within another (case-sensitive) | find_text within_text start_num |
TextTop Fundamentals LEFT | Excel 2003 | Returns the leftmost characters from a text string | text num_chars |
TextTop Fundamentals LEN | Excel 2003 | Returns the number of characters in a text string | text |
Text LOWER | Excel 2003 | Converts all letters in a text string to lowercase | text |
TextTop Fundamentals MID | Excel 2003 | Extracts a substring from a text string, starting at the position specified, for a given number of characters | text start_num num_chars |
TextTop Advanced NUMBERVALUE | Excel 2013 | Converts text that represents a number in a given locale into a numeric value | text decimal_separator group_separator |
Text PROPER | Excel 2003 | Converts text to title case (first letter in each word capitalized) | text |
TextTop Advanced REPLACE | Excel 2003 | Replaces part of a text string with a different text string | old_text start_num num_chars new_text |
Text REPT | Excel 2003 | Repeats text a given number of times | text number_times |
TextTop Fundamentals RIGHT | Excel 2003 | Extracts a given number of characters from the end of a text string | text num_chars |
TextTop Advanced SEARCH | Excel 2003 | Finds one text value within another (not case-sensitive) | find_text within_text start_num |
Text SUBSTITUTE | Excel 2003 | Replaces existing text with new text in a text string | text old_text new_text instance_num |
TextTop Advanced TEXT | Excel 2003 | Formats a number and converts it to text | value format_text |
Text TEXTAFTER | Excel 365 | Extracts text from a string after a specific delimiter | text delimiter instance_num match_mode match_end if_not_found |
Text TEXTBEFORE | Excel 365 | Extracts text from a string before a specific delimiter | text delimiter instance_num match_mode match_end if_not_found |
Text TEXTJOIN | Excel 2019 | Joins two or more text strings into one string | delimiter ignore_empty text1 text2 ... |
Text TEXTSPLIT | Excel 365 | Splits text into multiple rows or columns based on a delimiter | text col_delimiter row_delimiter ignore_empty match_mode pad_with |
Text TRIM | Excel 2003 | Removes all spaces from text except for single spaces between words | text |
Text UNICHAR | Excel 2013 | Returns the Unicode character that is referenced by the given numeric value | number |
Text UNICODE | Excel 2013 | Returns the Unicode code point of the first character of the text | text |
Text UPPER | Excel 2003 | Converts all letters in a text string to uppercase | text |
Text VALUE | Excel 2003 | Converts a text string that represents a number to a number | text |
Text VALUETOTEXT | Excel 365 | Converts a value to text format | value format |
STATISTICAL | |||
StatisticalTop Fundamentals AVERAGE | Excel 2003 | Calculates the average of the numbers provided | number1 number2 ... |
StatisticalTop Advanced AVERAGEIF | Excel 2007 | Calculates the average of numbers based on a criteria | range criteria average_range |
Statistical AVERAGEIFS | Excel 2007 | Calculates the average of numbers with multiple criteria | average_range range1 criteria1 range2 criteria2 ... |
Statistical Top FundamentalsCOUNT | Excel 2003 | Counts the number of cells that contain numbers | value1 value2 ... |
Statistical Top FundamentalsCOUNTA | Excel 2003 | Counts the number of cells that are not empty | value1 value2 ... |
Statistical Top AdvancedCOUNTBLANK | Excel 2003 | Counts the number of empty cells in a specified range | range |
Statistical Top FundamentalsCOUNTIF | Excel 2003 | Counts the number of cells within a range that meet a single condition | range criteria |
Statistical COUNTIFS | Excel 2007 | Counts the number of cells within a range that meet multiple criteria | range1 criteria1 range2 criteria2 ... |
Statistical FREQUENCY | Excel 2003 | Calculates the frequency distribution of a dataset | data_array bins_array |
StatisticalTop Fundamentals MAX | Excel 2003 | Returns the largest number in a set of values | number1 number2 ... |
Statistical MAXIFS | Excel 2019 | Returns the maximum value among cells specified by a given set of conditions or criteria | max_range range1 criteria1 range2 criteria2 ... |
StatisticalTop Advanced MEDIAN | Excel 2003 | Finds the median of the given numbers | number1 number2 ... |
Statistical Top FundamentalsMIN | Excel 2003 | Returns the smallest number in a set of values | number1 number2 ... |
Statistical MINIFS | Excel 2019 | Returns the minimum value among cells specified by a given set of conditions or criteria | min_range range1 criteria1 range2 criteria2 ... |
StatisticalTop Advanced MODE | Excel 2003 | Returns the most frequently occurring number in a set of numbers | number1 number2 ... |
StatisticalTop Advanced RANK | Excel 2003 | Returns the rank of a number in a list of numbers | number ref order |
Statistical STDEV | Excel 2003 | Estimates standard deviation based on a sample | number1 number2 ... |
Statistical STDEV.P | Excel 2010 | Calculates standard deviation based on the entire population | number1 number2 ... |
Statistical STDEV.S | Excel 2010 | Calculates standard deviation based on a sample | number1 number2 ... |
Statistical VAR | Excel 2003 | Estimates variance based on a sample | number1 number2 ... |
Statistical VAR.P | Excel 2010 | Calculates variance based on the entire population | number1 number2 ... |
Statistical VAR.S | Excel 2010 | Calculates variance based on a sample | number1 number2 ... |
INFORMATION | |||
Information ERROR.TYPE | Excel 2003 | Returns a number corresponding to an error type | error_val |
InformationTop Advanced ISBLANK | Excel 2003 | Checks whether a cell is empty | value |
Information ISERR | Excel 2003 | Checks for an error value except #N/A | value |
Information ISERROR | Excel 2003 | Checks for any error value | value |
Information ISFORMULA | Excel 2013 | Checks if a cell contains a formula | reference |
Information ISLOGICAL | Excel 2003 | Checks whether a value is a logical value (TRUE or FALSE) | value |
Information ISNA | Excel 2003 | Checks whether a value is the #N/A error | value |
InformationTop Advanced ISNUMBER | Excel 2003 | Checks whether a value is a number | value |
InformationTop NextGen ISOMITTED | Excel 365 | Checks if a LAMBDA argument is missing | argument |
Information ISREF | Excel 2003 | Checks whether a value is a reference | value |
Information ISTEXT | Excel 2003 | Checks whether a value is text | value |
Information NA | Excel 2003 | Returns the #N/A error | |
PROGRAMMING | |||
Programming BYCOL | Excel 365 | Executes a LAMBDA for each column in an array | array lambda |
Programming BYROW | Excel 365 | Applies a LAMBDA to each row in an array | array lambda |
ProgrammingTop NextGen LAMBDA | Excel 365 | Enables creation of custom, named functions | parameter1 parameter2 ... calculation |
ProgrammingTop NextGen LET | Excel 365 | Assigns names to intermediate calculation results for clarity and reuse | name1 value1 calculation_or_name2 value2 calculation_or_name3 ... |
Programming MAKEARRAY | Excel 365 | Generates an array by applying a LAMBDA to each row and column index | rows cols lambda |
ProgrammingTop NextGen MAP | Excel 365 | Applies a LAMBDA to each value in an array | array1 array2 ... lambda |
ProgrammingTop NextGen PY | Excel 365 | Executes Python code, returning results as Python objects or Excel values | python_code return_type |
Programming REDUCE | Excel 365 | Applies a LAMBDA to each array value, accumulating and returning a total result | initial_value array lambda |
Programming SCAN | Excel 365 | Applies a LAMBDA to each array element, returning an array of intermediate results | initial_value array lambda |