Testing for two or more alternate conditions by way of the OR function.Facilitating decision making within Excel formulas by way of the IF function.David also provides an Excel workbook that includes most of the examples he uses during the webcast. He’ll draw your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. The presentation also explores techniques useful in verifying that formulas such as nested IF statements are working properly.ĭavid demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. David shares alternatives to the IF function, including IFS, CHOOSE, VLOOKUP, SUMIF, and several other worksheet functions. David explains what can go awry with the IF function and ways to improve the integrity of decision-making formulas. Excel expert David Ringstrom, CPA, begins with a brief discussion of the IF function and then takes you step-by-step beyond the basics.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |