The IF function in Excel is a really useful one to be aware of as you can use it to help you to quickly analyse your data. In this example, I use the IF function to get Excel to tell me if student grades are a pass or a fail. This is a very simple example to get you started, why don’t you have a play with the IF function with your data and see what you can get it to do?
Featured image: “If” by Jonathon Colman licenced under CC BY-NC-ND 2.0
#1minuteCPD 
Great video – the IF function is a great tool to have in your back pocket. The big 3 (SUMIFS – COUNTIFS – AVERAGEIFS) as I like to call them will take you far with your spreadsheets.
LikeLike