Video – How to Make a Simple IF Formula in Excel
Use the Excel IF function when you want to test something. The IF formula will show one result if the test result is True, and a different result if the test result is False.
For example:
- Check if cell D7 is empty.
- If it is, the result is an empty string.
- If not, multiply C7 times D7.
Video: Simple IF Formula in Excel
In the short video below, I show the steps for setting up a simple IF formula.
Video Timeline
- 0:00 Introduction
- 0:13 Do a Test
- 0:39 Order Form
- 0:55 Simple IF Formula
- 1:39 Test the Formula
Get the Sample File
For more IF formula examples, and to get the sample Excel workbook, go to the IF Function Examples page on my Contextures site. The zipped file is in xlsx format, and does not contain any macros.
- Nested IFs: The examples on that page also show how to created nested IF formulas, where two or more IF functions are used, to create multiple tests.
- IFS: And if you’re using Excel 365, there are examples for the new Excel IFS function.
Related IF Function Articles
• Excel Nested IF Formula Horror Stories
And instead of creating long, complicated, multi-level nested IF formulas, considering using a lookup formula instead.
• INDEX / MATCH Function Examples
________________________