SWITCH function - Microsoft Support
Applies To. The SWITCH function evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.
IF function – nested formulas and avoiding pitfalls
Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False.
IFS function - Microsoft Support
The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)
Use AND and OR to test a combination of conditions
This formula nests the AND function inside the OR function to search for units sold between April 1, 2011 and January 1, 2012, or any units sold by Nancy. You can see it returns True for units sold by Nancy, and also for units sold by Tim and Ed during the dates specified in the formula.
FIND, FINDB functions - Microsoft Support
If you don't want to do a case sensitive search or use wildcard characters, you can use SEARCH and SEARCHB. If find_text is "" (empty text), FIND matches the first character in the search string (that is, the character numbered start_num or 1).
Check if a cell contains text (case-sensitive) - Microsoft Support
There are several ways to check if a cell contains text and the case of the text matters to you. Compare one cell to another cell To do this task, use the EXACT function.
Create conditional formulas - Microsoft Support
You can use the AND, OR, NOT, and IF functions to create conditional formulas. For example, the IF function uses the following arguments. Formula that uses the IF function. logical_test: The condition that you want to check. value_if_true: The value to return if the condition is True.
Filter by using advanced criteria - Microsoft Support
Filter by using advanced criteria. If the data you want to filter requires complex criteria (such as Type = "Produce" OR Salesperson = "Davolio"), you can use the Advanced Filter dialog box. To open the Advanced Filter dialog box, click Data > Advanced.
Change the case of text - Microsoft Support
In Excel, you can change case for text to uppercase, lowercase, or proper case with the UPPER, LOWER, or PROPER functions.
Check if a cell contains text (case-insensitive) - Microsoft Support
Find cells that contain text. Follow these steps to locate cells containing specific text: Select the range of cells that you want to search. To search the entire worksheet, click any cell. On the Home tab, in the Editing group, click Find & Select, and then click Find.