How To Use “If Cell Contains” Formulas in Excel

The “If Cell Contains” formula in Excel allows you to perform an action based on the contents of a cell. Here’s how to use it:

1. Open your Excel worksheet and select the cell where you want to apply the “If Cell Contains” formula.
2. Click on the “Formulas” tab in the ribbon and select “More Functions” > “Statistical” > “IF” to open the “Insert Function” dialog box.
3. In the “Logical_test” box, type in the condition you want to test for. For example, if you want to test if a cell contains the text “Apple,” you would enter the formula: =IF(ISNUMBER(SEARCH(“Apple”,A1)),”Yes”,”No”). This formula will search cell A1 for the word “Apple” and return “Yes” if it’s found, and “No” if it’s not found.
4. In the “Value_if_true” box, enter the action you want Excel to take if the condition is true. For example, if you want Excel to fill the cell with a certain color or value, enter the appropriate command.
5. In the “Value_if_false” box, enter the action you want Excel to take if the condition is false. For example, if you want Excel to do nothing, leave this box blank.
6. Press “OK” to apply the “If Cell Contains” formula to the selected cell.

Note: You can also use the “If Cell Contains” formula in combination with other formulas, such as the “COUNTIF” formula, to perform more complex actions based on the contents of a cell.

By using the “If Cell Contains” formula in Excel, you can easily test for a specific condition and take appropriate action based on the result. This can be useful for automating tasks and improving your workflow in Excel.