In this video we use the IF function of Excel to test if a cell contains specific text.
Usually with the IF function you test a cell for a complete match, but in this example we need a partial match on text.
We then extend the scenario to handle a problem and then test for two different specific text strings.
Advanced Excel Formulas book (840 pages and more than 150 Excel functions)
[ Ссылка ]
Find more great free tutorials at;
[ Ссылка ]
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► [ Ссылка ]
Excel VBA for Beginners ► [ Ссылка ]
Advanced Excel Tricks ► [ Ссылка ]
Excel Formulas Made Easy ► [ Ссылка ]
Creating Sports League Tables and Tournaments in Excel ► [ Ссылка ]
Connect with us!
LinkedIn ► [ Ссылка ]
Instagram ► [ Ссылка ]
Twitter ► [ Ссылка ]
