The IF function and multiple IF statements in Excel are extremely powerful tools that allow you to manipulate and analyze your Excel data. The IF statement is based on the logical use of “IF” to create a type of filter to allow you to create functions and formulas that allow you to analyze or extract values from a specific set of data. The Excel Formulas & Functions – In depth course will show you how to use the various formulas and functions available in Excel.
We use the IF function in everyday life to make decisions in the same way that Excel uses the IF function to make decisions regarding your data. In real life for example, we may decide that “IF” we get a raise, we will go on holiday. This statement relies on us evaluating the condition and then taking action based on that evaluation, in the same way that Excel examines a condition and then takes further steps based on its evaluation.
The power of the IF statement lies in the fact that Excel allows you to use multiple IF statements to analyze your data. This tutorial will show you how to use multiple IF statements in your worksheets. To get the maximum value from this tutorial, you need to be able to use the basic Excel functions and features. The Excel 2013: Introducing Excel course from Udemy offers over 20 lectures that will teach you all the basics of Excel so that you have a solid foundation in using Excel.
The Basic IF Function in Excel
The basic IF function in Excel evaluates a condition and then performs a number of steps based on the result of that evaluation. The logic behind the IF function can be represented as follows:
The IF statement essentially evaluates a condition- if it finds the statement is true, then it goes on to the next set of code and if it finds the statement is false, then it executes another set of code. This structure means that you could create an IF statement and then if that statement evaluates to true, the code can wil then use another IF statement and so on. This is how you create multiple IF statements in Excel. If Then Statements in Excel Make Data Analysis Really Simple and this article will show you how to use IF statements in Excel.
How to Create a Multiple IF Statement in Excel
Let’s examine the following example: You are a teacher and you need to assign a grade to each student based on their test scores. If a student gets a test score of less than 50 then he is assigned an “E” grade. If a student gets between 50 and 60 then he is assigned a “D”, between 60 and 70 is assigned a “C”, between 70 and 80 is assigned a “B” and 80 or more is assigned an “A”.
This is what our student spreadsheet will look like:
We will use the IF statement syntax to create the various conditions we need to assign the different grades required.
Essentially what we are going to do is create an “IF” statement that checks if the test is 50 or lower. If the condition is true i.e. the mark is 50 or lower then we will assign a grade of “E” to that student. If the condition is false, then we will use a new IF statement to create a new condition that checks if the grade is between 50 and 60. If this condition is true it will assign a grade of “D”, but if the condition is false then we will create a new IF statement to check new conditions. In this way we will create a multiple IF statement to check for all the different conditions we need to assign the correct grade to the student. The Microsoft Excel 2013 Course Beginners/ Intermediate Training course will show you how to harness the power of Excel.
This is what the formula looks like to check each condition using the multiple IF statement in Excel:
Multiple “IF” statements in Excel can look and can become incredibly complex to follow. A good rule of thumb or tip to follow when creating multiple IF statements, is to write down the statement in plain English first. This will help you to create a structure that is logical and that you can use to create your Excel “IF” statement.
The resultant worksheet will look like this:
The Microsoft Excel 2013 Training Tutorial available from Udemy offers over 226 lectures and over eighteen hours of content that will ensure that you are able to take your Excel skills to the next level.