IF Function

The IF function displays either text, numbers or the result of a formula based on certain criteria. For example, if you have students  you can get the IF function to display whether or not they passed or failed based on their exam result. It can also be used say for a tax calculation depending on which tax bracket you fall into. The tutorial below works for all versions of Excel.