What to Show If True - If the statement contains what we're checking for, what should the cell show?.Something to Check - Basically, what should the IF statement check for? We could check to see if a cell equals a certain number, or to see if it contains a certain string of text, for example.There are three key parts to a successful IF statement: Watch this video to walk through building IF statements, and then check out the tutorial below for written instructions.īefore we move on with the tutorial, I'd recommend downloading the free example workbook I've created for this tutorial. In this screencast, you'll see how I use IF statements in Excel to make a spreadsheet smarter. How to Use Excel IF Statements (Video Tutorial) In this tutorial, I'll teach you how to use them. An IF formula lets us build in logic to our spreadsheet. We can give a cell different choices for what to show based on a condition. This simple IF statement example looks at the score in column B and reminds me if I'm passing or failing a class based on the score.Īn Excel IF formula makes your spreadsheets much smarter.

I can write an IF statement formula to look at the final grade, and then print 'passing' or 'failing' based on the score. I want to remind myself if I'm passing or failing a class with a simple 'passing' or 'failing' text.

Imagine that we have a spreadsheet with a list of scores from our school courses. What happens when we need to build options into our spreadsheet? This is where if statements really come into play. A spreadsheet is really just a tool for organizing, calculating, and reviewing your data with. Excel is one of the most powerful and easiest-to-use tools for working with data.

How to use if then formula in excel