If Cell Contains Text Then Formula in Excel helps you to produce the output when a cell have some text. You can check if cell contains some string and produce something in another cell. For Example you can check if a cell A1 contains text ‘some string’ and print Yes or No in Cell B1. Following are the example Formulas to check if Cell contains then produce some thing in a Cell.

## If Cell Contains Text Then TRUE

Following is the Excel formula to return True if a Cell contains Text. You can check a cell if there is given string in the Cell and return True or False.

**=IF(ISNUMBER(FIND(“How”,A1,1)),TRUE,FALSE)**

The formula will return true if it found the match, returns False of no match found.

## If Cell Contains Text Then Return a Value

We can retrn some value if cell contains some string. Here is the the the Excel formula to return a value if a Cell contains Text. You can check a cell if there is given string in the Cell and return some string or value in aother column.

**=IF(ISNUMBER(SEARCH(“How”,A1,1)),”Found”,”Not Found”)**

The formula will return true if it found the match, returns False of no match found. can

## If Cell Contains Text Then SUM

Following is the Excel formula to Sum if a Cell contains Text. You can total the cell values if there is given string in the Cell. Here is the example to sum the column B values based on the values in anoter Column.

**=SUMIF($A$2:$A$7,”*”&D2&”*”,$B$2:$B$7)**

The formula will Sum the values in Colum B if the cells of Column A contains the given text.

## If Cell Contains Text Then COUNT

Here is the Excel formula to Count if a Cell contains Text. You can count the number of cells containing specific text.

**=COUNTIF($A$2:$A$7,”*”&D2&”*”)**

The formula will Sum the values in Colum B if the cells of Column A contains the given text.

## Leave A Comment