Microsoft Excel is widely used from business professionals to students. Through its ability to efficiently manage, analyse and visualise data, it has become a leading tool in most office settings.

It has myriad features that allow users to enhance productivity and accuracy to help streamline workflow and help make informed decisions. Considering the constant updates to Excel and abundant tools available, it can be difficult to keep up with the latest tools and shortcuts available that will help you with your tasks.

There are many useful formulas you can utilise in Excel however one of the more useful is the IF formula.

This performs a test on a condition and returns values for TRUE and FALSE.