Using IF formulas in excel can be an easy way to apply logic to any excel file – whether you want to evaluate certain criteria to flag, or check if your data is falling within a certain range, the basic IF formula can do all of this in a few simple clicks.
In this video series, I cover several different types of IF formulas, so you can use the basic IF logic to return a specific result, or you can also use IF logic to return a certain calculation such as sum total, counts, max or min of various data sets.
Once you learn the basics of IF formulas, you’ll see how easy it is to utilize. Most of my examples are using HR or compensation sample data with different templates you can find right here.