Excel Videos

Video – How to Make a Simple IF Formula in Excel

ByDebra Dalgleish

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.

if function checks for empty cell

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 IF Function Examples

• 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

• VLOOKUP Function Examples

• Lookup Functions Compared

________________________

Similar Posts