Information
★ 20 · ◉ 22 · All versions
=ISTEXT()
Checks whether an input value is text or not?
=ISTEXT(value)
Data Cleaning
Error Handling
Conditional Formatting & Validation
24 functions for this use case · out of 12 defined
Lookup & Reference
★ 30 · ◉ 21 · All versions
=ROW()
Returns the row number of a reference.
=ROW([reference])
Conditional Formatting & Validation
Numbering & Sample Data
Lookup & Reference
★ 50 · ◉ 20 · All versions
=COLUMN()
Syntax: COLUMN([reference])
=COLUMN([reference])
Conditional Formatting & Validation
Numbering & Sample Data
Math & Trig
★ 55 · ◉ 19 · All versions
=MOD()
Returns the remainder after number is divided by divisor. The result has the same sign as divisor.
=MOD(number, divisor)
Conditional Formatting & Validation
Date & Time Calculations
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
Information
★ 60 · ◉ 16 · All versions
=ISBLANK()
Checks whether a cell is empty or not?
=ISBLANK(value)
Error Handling
Conditional Formatting & Validation
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
Logical
★ 50 · ◉ 14 · All versions
=AND()
Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE.
=AND(logical1, [logical2], ...)
Daily Tasks
Conditional Logic
Lookup & Reference
★ 55 · ◉ 14 · All versions
=INDIRECT()
Returns the reference specified by a text string. References are immediately evaluated to display their contents. Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself.
=INDIRECT(ref_text, [a1])
Lookup & Retrieval
Conditional Formatting & Validation
Statistical
★ 60 · ◉ 14 · All versions
=LARGE()
Returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score.
=LARGE(array, k)
Daily Tasks
Ranking & Top N
Date & Time
★ 55 · ◉ 14 · All versions
=WEEKDAY()
Returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default.
=WEEKDAY(serial_number,[return_type])
Conditional Formatting & Validation
Date & Time Calculations
Information
★ 30 · ◉ 13 · All versions
=ISEVEN()
Returns TRUE if number is even, or FALSE if number is odd.
=ISEVEN(number)
Error Handling
Conditional Formatting & Validation
Information
★ 20 · ◉ 13 · Excel 2013
=ISFORMULA()
Checks whether there is a reference to a cell that contains a formula, and returns TRUE or FALSE.
=ISFORMULA(reference)
Error Handling
Conditional Formatting & Validation
Information
★ 30 · ◉ 13 · All versions
=ISODD()
Returns TRUE if number is odd, or FALSE if number is even.
=ISODD(number)
Error Handling
Conditional Formatting & Validation
Lookup & Reference
★ 60 · ◉ 13 · All versions
=OFFSET()
Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells. You can specify the number of rows and the number of columns to be returned.
=OFFSET(reference, rows, cols, [height], [width])
Lookup & Retrieval
Conditional Formatting & Validation
Text
★ 60 · ◉ 12 · All versions
=LEN()
LEN returns the number of characters in a text string.
=LEN(text)
Daily Tasks
Data Cleaning
Logical
★ 30 · ◉ 12 · All versions
=NOT()
Use the NOT function, one of the logical functions, when you want to make sure one value is not equal to another. One common use for the NOT function is to expand the usefulness of other functions that perform logical tests. For example, the IF function performs a logical test and then returns one value if the test evaluates to TRUE and another value if the test evaluates to FALSE. By using the NOT function as the logical_test argument of the IF function, you can test many different conditions instead of just one.
=NOT(logical)
Conditional Logic
Conditional Formatting & Validation
Text
★ 30 · ◉ 12 · Excel 365
=REGEXTEST()
REGEXTEST Function
=REGEXTEST(text, pattern, [case_sensitivity])
Data Cleaning
Text Manipulation
Date & Time
★ 40 · ◉ 12 · All versions
=TODAY()
The TODAY function returns the serial number of the current date. The serial number is the date-time code used by Excel for date and time calculations. If the cell format was General before the function was entered, Excel changes the cell format to Date. If you want to view the serial number, you must change the cell format to General or Number. The TODAY function is useful when you need to have the current date displayed on a worksheet, regardless of when you open the workbook. It is also useful for calculating intervals. For example, if you know that someone was born in 1963, you might use the following formula to find that person's age as of this year's birthday: = YEAR( TODAY())-1963 This formula uses the TODAY function as an argument for the YEAR function to obtain the current year, and then subtracts 1963, returning the person's age.
=TODAY()
Daily Tasks
Conditional Formatting & Validation
Text
★ 60 · ◉ 11 · All versions
=SEARCH()
The SEARCH function locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string. For example, to find the position of the letter "n" in the word "printer", you can use the following function: =SEARCH("n","printer") This function returns 4 because "n" is the fourth character in the word "printer." You can also search for words within other words. For example, the function =SEARCH("base","database") returns 5, because the word "base" begins at the fifth character of the word "database". You can use the SEARCH to determine the location of a character or text string within another text string, and then use the MID to return the text, or use the REPLACE to change the text. These functions are demonstrated in Example 1 in this article.
=SEARCH(find_text,within_text,[start_num])
Text Manipulation
Conditional Formatting & Validation
Statistical
★ 60 · ◉ 10 · All versions
=COUNTIF()
Conditional count (a single condition)
=COUNTIF(range, criteria)
Daily Tasks
Conditional Aggregation
Logical
★ 50 · ◉ 9 · All versions
=OR()
Use the OR function, one of the logical functions, to determine if any conditions in a test are TRUE.
=OR(logical1, [logical2], ...)
Daily Tasks
Conditional Logic
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