4 Fantastic Alternatives to Nested IF Formulas

View more Excel formula tutorials - http://www.computergaga.com/blog/category/excel/formulas/ In this video we look at 4 fantastic alternatives to nested IF formulas in Excel. Nested IF formulas are very useful, but they can also be long, messy and convoluted. This video uncovers 4 more effective formulas. This video covers the IFS function, lookups and also the relatively unknown CHOOSE function. A demonstration is given of each with comparisons to the nested IF alternative. The ultimate guide to the VLOOKUP function - http://www.computergaga.com/tips/ultimate_vlookup_guide.html Find more great free tutorials at; http://www.computergaga.com Connect with us! Google+ ► https://plus.google.com/+Computergaga Facebook ► http://www.facebook.com/computergaga Twitter ► http://www.twitter.com/computergaga1