Excel IF Function Overview

Description

Microsoft Excel's IF function is one of the most powerful functions in Excel. It allows you to set a cells value based on the result of evaluating a "condition". A condition is essentially a question where the answer is always either true or false. For example, the expression A1 < 10 is a condition that tests whether the cell A1 is less than 10. If it is, it will return true; if it is not, it will return false. This is a good example of the type of question that Excel's IF function can handle.

Arguments

1. Condition to be tested. For example, A3 >= B5.
2. Answer to return if condition is true. This can be anything you like (e.g., another cell, a formula, a number, a date, etc.).
3. Answer to return if condition is false. Again, this can be anything you like.

When to use

You should use Excel's IF function whenever you want a cells value to change depending on the answer to a question. For example, I want to show "good" for people who received an A or a B in the class and "bad" for anyone who received a lower grade.

Still Need Help?

If you like this course, you may also be interested in other courses we offer.