This video,, can also be seen at you have no concern for upper- or lowercase text, there are several ways to check if a cell contains text. You can also use a filter to find text. For more information, see filter data. find cells that contain text. Follow these steps to locate cells containing specific text: select the range of cells that you want to search.IF statement You need to think logically when you do an IF statement. Working on paper and pencil may help you to perform an IF statement before you directly type your statement into the cell. An IF statement is a conditional test on values and formulas that returns one value if a condition you specify is TRUE and another value if it is FALSE.Excel IF function examples for text values. generally, you write an Excel if statement with text using either "equal to" or "not equal to" operator, as demonstrated in a couple of IF examples that follow. Example 1. Case-insensitive IF formula for text values. Like the overwhelming majority of Excel functions, IF is case-insensitive by default.Download this free template for an IF statement between two numbers in Excel. In this tutorial, we show you step-by-step how to calculate IF with AND statement. Learn how to build an IF statement that will test if a cell contains a value between two numbers and then output the result you want if that condition is metAn IF statements that operates if a cell CONTAINS a word. Posted by Chris Rock on October 24, 2001 1:53 PM Is it possible to write an IF statement that looks at a string of text, and will perform an action if the string CONTAINS a certain word?Home Learn Microsoft Excel Using multiple IF statements in Excel. Search form. Search .. Whilst you can get the result you want using multiple IF statements in a formula, I recommend you look at using a VLOOKUP function instead.. if not, please let me know!The basic form of IF function in Excel is shown as: =IF(logic_test, value_if true, value_if_false) In our case we want to check the sale volumes are Low or not. If the value in Cell B2 is equal or less than 80, return the text of "Low", if the value in Cell B2 is bigger than 80, return blank.