The If function checks whether a condition is met, and returns one value if TRUE, and another if FALSE.
We will use 3 functions, namely, IF, SEARCH & IFERROR to calculate the value in column B. To understand better, see the below screenshot: If it does, we need to return the value 1 in column B, else we need to return 0. We need to check if each cell in this column contains the word “color”. (The colors are not of any significance here). We can see how this is done using an example -Ĭolumn A has text containing the word “color”. If yes, we need to return a number in a separate cell, else ignore. Let's consider we have a situation where we need to review each cell and check if it contains any text. In this article we will learn if cell contains word then how to assign value in Microsoft Excel 2010.
