The IF Functions are some of the most powerful functions in Excel. A basic IF or IFS function can allow complex decision tree-style analysis and functions like SUMIFS and COUNTIFS allow you to calculate the sum or count of a series of results only when certain criteria are met.
Learning how to effectively use the IF Functions can save a substantial amount of time and effort as well as supporting more complex decision-making and analysis.
* * *
The Easy Excel Essentials 2019 series of titles are for intermediate-level users who want to focus on one specific topic such as PivotTables, Charts, Conditional Formatting, or the IF Functions.
The content of each title is extracted from either Excel 2019 Intermediate or Excel 2019 Formulas & Functions which cover intermediate-level Excel topics in more detail. These books are written using Excel 2019 and assuming that a user is working in that program. If you are using an older version of Excel, the Easy Excel Essentials series may be a better choice since it was written using Excel 2013 and for a more general audience of Excel users.