Select Page

Excel Video 146 introduces the IF function, a powerful tool to add versatility to your formulas. We’ll start with two basic examples. The structure of the IF function is =IF(logical test, value if the test is true, value if the test is false). The logical test can be a wide variety of conditions or statements. Based on whether or not the test is true or false, you can decide how Excel responds.
Watch for an example with text and with numbers. You might also find it helpful to know how to leave a cell blank. Do that by just putting two quotes back to back, like this “”. Stay tuned. Once you’re comfortable with IF, you can combine IF with a wide variety of functions to create very powerful formulas.