The IF Functions

The various IF functions in Excel are fantastic. They let you write one formula that will return multiple different results depending on your data or they let you perform basic mathematical calculations like count, sum, average, and more but only on those results that meet your criteria. They are well worth learning.
* * *
The Easy Excel Essentials series of titles are meant to cover one specific topic that is excerpted from the main Excel Essentials series. This content was taken from 50 Useful Excel Functions which covers the basics of formulas and functions in Excel as well as fifty of the most useful Excel functions.