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.
Find more great free tutorials at;
https://www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course – Learn Everything ► https://bit.ly/2Ag5AKH
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/2UlTfvB
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm
Connect with us!
LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1