How to Use “If Contains” Formula in Excel

In this tutorial, you will learn how to use ‘If Contains’ formula in Excel.

You may use your data in helpful ways with the help of a number of Excel formulae. You could, for instance, receive a result based on whether or not a cell satisfies a set of requirements. We’ll concentrate on the “if cell contains, then” function right now.

Before moving to the tutorial, let’s familiarize ourselves with the Excel functions we will be using to use ‘If Contains’ formula.

Anatomy of IF Functions

IF Function

IF(logical_test, value_if_true, [value_if_false])

IF function allows you to compare values logically to expectations.

Once ready, we’ll get started by utilizing real-world examples to show you how to use ‘If Contains’ formulas in Excel.

Use ‘If Contains’ Formula in Excel

Before we begin we will need a group of data to use ‘If Contrains’ formula in Excel.

Step 1

First, you need to have a clean and tidy group of data to work with.

Step 2

In this example, we want to return a ‘Yes’ for cells with text only. In order to do so, we can simply enter this formula =IF(ISTEXT(A2), “Yes”, “No”). we can then apply the same formula to the rest of the cells.

Step 3

Once you are done, your Excel will look something like this.