Excel Logic: IF, AND, OR, and Beyond is brought to you by Wolters Kluwer
In this comprehensive presentation, Excel expert David Ringstrom, CPA, briefly discusses the IF function and then, in detail, takes you beyond the basics. He explains what can go awry with the IF function and ways to improve the integrity of decision-making formulas. David shares alternatives to the IF function, including IFS, CHOOSE, VLOOKUP, SUMIF, and others. David’s assertion is that if you’re nesting more than a couple of IF functions, there’s probably a more refined and resilient approach you can take.