Tuesday Tips: If Rule in Excel

how to use the if rule in excel

Today’s Tip: IF Rule in Excel

Are you ever in a situation where you need to check that data is the same? Do you ever need to figure out if criteria was met (e.g. passed or failed) based on a simple variable? The IF Rule in excel can provide you an easier way to complete both of those functions.

In excel, the IF rule can be used in a couple of ways. I will teach you the basics of the two ways I most commonly use this rule. For my example, I will use a list of “student results”. For this example we will assume a pass mark is 50, and the only results are “Pass” or “Fail”.

Step 1: Open your list and, if required, copy and paste it into Excel.

IF Rule Step 1 - Open List

Step 2: Select the cell you wish your information to land in. Press the “function” button and search for the IF rule.

 

Note: This will come up under Most Recently Used once you have used it, but for the first time you will need to search for it.

IF Rule Step 2 - Select Function

Step 3: Set the parameters of the data you’re wishing to test. For example, does every mark below 50 result in a fail and above 50 a pass? If so, you would set your test as “Is this data greater than 50?” or “*cell*>50″. Then enter the values for if the condition is true (e.g. if the mark is over 50 it’s a pass), and false (e.g. under 50 it is a fail).

IF Rule Step 3 - Enter Parameters

 

 

The below is an example of the same thing, however I’m testing if the student number of these two sets of data matches.

IF Rule Step 2 - Select Function Example 2

Step 4: Click on the bottom right hand corner of the cell containing the formula and double click to auto-fill the rest of the data.

IF Rule Step 4 - Drag Formula

Step 5: Done!

IF Rule Step 5 - View Results

Often in addition to using this formula, I use conditional formatting, which I will go into another day.

 

  • Gary

    As much as I love reading your stuff Tamsin, this is the best :-) Thank you.

    • https://kikiandtea.com/ Tamsin Howse

      Hahaha! I’ve only just scratched the surface on Excel, there’s more to come!

      • Gary

        Excellent. I hoe you have a great day.

  • Renee at Mummy, Wife, Me

    Excel is always something I wish I knew how to use better. I only know the basics and do have to use spreadsheets quite a lot at work. Fortunately, I don’t have to do too many calculations :) Visiting via #teamIBOT

    • https://kikiandtea.com/ Tamsin Howse

      Try this! It’s actually not that hard.

  • http://essentiallyjess.com/ EssentiallyJess

    I can’t remember the last time I even looked at excel! I keep track of IBOT reading on numbers, but that’s about as much spreadsheet work as I have done in years.

    • https://kikiandtea.com/ Tamsin Howse

      I use excel a LOT! Thanks for coming over! I visited a bunch of the IBOTs but couldn’t comment as I was pulled away for a meeting.