The IF test is one of the most common functions used in Excel and once you get to know how to use it, you will always find a reason to! An IF test will check if a condition is met and will return a value if True and another value if False.