Attend upcoming webinar and earn continuing education credits. Excel Logic Formulas: IF, AND, OR, and More | | | | | | | March | | 31 | 1 pm - 2:40 pm ET | | Presenter: David Ringstrom, author and nationally recognized Excel instructor | | Credits: CPE (Credit Details) | | Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. | | Viewing Options: View on your computer, tablet, or smartphone | | | | | | | | | | While many Excel users rely on the IF function, they're often unaware of ways to improve the integrity of decision-making formulas. In this practical webinar, you will learn how to apply the IF function and its powerful alternatives such as IFS, CHOOSE, VLOOKUP, and SUMIF functions. Upon completion of this course, you will be able to: - Transform SUM, MIN, and MAX into multi-criteria array formulas
- Define the pros, cons, and limitations of nesting IF functions
- Use the SUMIF function to summarize data based on a single criterion
- Compare IFNA, IFERROR, and ISERROR functions and learn which versions of Excel support these worksheet functions
- Compare the MIN, SMALL, MAX, and LARGE functions
- Use the SUMIFS function to sum values based on multiple criteria
- Use the IFERROR function to display something other than an #N/A error value when VLOOKUP can't find a match
- Identify the range of IS functions that can be used within IF statements to test for various conditions within a worksheet
- Use the COUNTIF function to determine the number of times an item appears on a list
- Apply the MINIFS function in Excel 2016
- Use the IF function to compare two cells directly to return TRUE or FALSE values
- Avoid the complexity of nested IF statements with Excel's CHOOSE function
| | | | | | | David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. | | | | | | | | | ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 1,000 on-demand courses | | | | | |