Logical
★ 15 · ◉ 19 · Excel 2013
=XOR()
The XOR function returns a logical Exclusive Or of all arguments.
=XOR(logical1, [logical2],…)
Comparation
Conditional Logic
Comparation
20 functions for this use case · out of 12 defined
Lookup & Reference
★ 100 · ◉ 18 · Excel 2021
=XLOOKUP()
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
Daily Tasks
Lookup & Retrieval
Information
★ 50 · ◉ 17 · All versions
=ISNUMBER()
Checks whether a value is numeric or not?
=ISNUMBER(value)
Data Cleaning
Comparation
Statistical
★ 70 · ◉ 16 · Excel 2007
=COUNTIFS()
How to use the COUNTIFS function in Excel to apply criteria to cells, across multiple ranges, and count the number of times all criteria are met.
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
Daily Tasks
Conditional Aggregation
Math & Trig
★ 50 · ◉ 15 · All versions
=ABS()
Returns the absolute value of a number. The absolute value of a number is the number without its sign.
=ABS(number)
Comparation
Rounding & Numeric
Lookup & Reference
★ 80 · ◉ 15 · Excel 2021
=UNIQUE()
Learn about the UNIQUE function, which returns a list of unique values in a list or range. UNIQUE is in a class of functions called dynamic arrays.
=UNIQUE(array,[by_col],[exactly_once])
Daily Tasks
Reporting
Math & Trig
★ 15 · ◉ 13 · All versions
=SIGN()
Determines the sign of a number. Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative.
=SIGN(number)
Comparation
Rounding & Numeric
Lookup & Reference
★ 90 · ◉ 12 · Excel 2021
=FILTER()
How to use the FILTER function in Excel to filter a range of data based on criteria you define.
=FILTER(array,include,[if_empty])
Daily Tasks
Lookup & Retrieval
Lookup & Reference
★ 90 · ◉ 12 · All versions
=VLOOKUP()
Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
=VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
Daily Tasks
Lookup & Retrieval
Logical
★ 75 · ◉ 11 · Excel 2013
=IFNA()
The IFNA function returns the value you specify if a formula returns the #N/A error value; otherwise it returns the result of the formula.
=IFNA(value, value_if_na)
Comparation
Error Handling
Math & Trig
★ 85 · ◉ 11 · All versions
=ROUND()
The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula: =ROUND(A1, 2) The result of this function is 23.78.
=ROUND(number, num_digits)
Daily Tasks
Comparation
Math & Trig
★ 80 · ◉ 11 · All versions
=SUMPRODUCT()
How to use the SUMPRODUCT function in Excel, one of Excel’s math and trig functions, using multiplication, addition, subtraction, and/or division to return the sum of the products of corresponding ranges or arrays.
=SUMPRODUCT(array1, [array2], [array3], ...)
Conditional Aggregation
Reporting
Statistical
★ 60 · ◉ 10 · All versions
=COUNTIF()
Conditional count (a single condition)
=COUNTIF(range, criteria)
Daily Tasks
Conditional Aggregation
Lookup & Reference
★ 60 · ◉ 10 · Excel 365
=VSTACK()
The arrays to append.
=VSTACK(array1,[array2],...)
Comparation
Reshape Tables
Lookup & Reference
★ 70 · ◉ 10 · Excel 2021
=XMATCH()
The XMATCH function searches for a specified item in an array or range of cells, and then returns the relative position of the first match.
=XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])
Lookup & Retrieval
Comparation
Text
★ 30 · ◉ 8 · All versions
=EXACT()
Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document.
=EXACT(text1, text2)
Text Manipulation
Comparation
Math & Trig
★ 90 · ◉ 7 · Excel 2007
=SUMIFS()
How to use the SUMIFS function in Excel, one of Excel’s math and trig functions, to add arguments that meet multiple criteria.
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Daily Tasks
Conditional Aggregation
Information
★ 60 · ◉ 6 · All versions
=ISNA()
Whether it is the #N/A error or not
=ISNA(value)
Comparation
Error Handling
Math & Trig
★ 60 · ◉ 6 · All versions
=SUMIF()
How to use the SUMIF function in Excel to add the values in a range that meet criteria that you specify.
=SUMIF(range, criteria, [sum_range])
Daily Tasks
Conditional Aggregation
Lookup & Reference
★ 80 · ◉ 4 · All versions
=MATCH()
How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.
=MATCH(lookup_value, lookup_array, [match_type])
Daily Tasks
Lookup & Retrieval