Multiple IF Statements in Excel
In this tutorial, you will learn how to use multiple IF statements in excel. The understanding of this nested IFs statements concept is useful if you want to evaluate data condition stepbystep.
If you haven’t understood how to use IF singularly, then learn it first in this Compute Expert tutorial.
Why do We Need to Learn Nested IF Function?
In the spreadsheet data processing, often we need to do condition evaluation. We want to get a particular data for a condition and another particular data for another one. Sometimes we need to do the evaluation process stepbystep if there are more than one evaluation criteria. For that, we must understand how to do it in our spreadsheet so the evaluation result won’t be wrong.
As an example of this need in our work, let’s imagine a situation. Let’s say we process classification for the regions where our company sell its products. There are some leveling for the classification based on the sales numbers. If there are many regions that need to be classified, then we need a practical way to do the process. This won’t be easily done if we decide to do it manually or classifying them one by one. It will take a very long time to do it.
To make the process faster and easier, you can use multiple IF statements in excel. The understanding of this is important if you often do a condition evaluation process in your data processing. There should be many cases where this is needed in the spreadsheet. So, you should understand how to do it well.
What is Multiple IF Statements in Excel?
Multiple IF statements in excel is a function used to evaluate condition stepbystep with more than one criteria. It is IFs that are used more than once in one writing.
As with the singular form, this formula has a similar input general description:
=IF(logical_test, value_if_true, value_if_false)
Note:
 logical_test = the condition to be evaluated
 value_if_true = the result if it is right
 value_if_false = the result if it is wrong
How to Create Nested IF Statement Excel?
The following will explain how to do multiple IF statements in excel. If you have understood how to use its singular form, then it shouldn’t be too hard for you to understand.
Creating Excel Multiple IF Statement

Type equal sign ( = ) in the cell where you want to put the result in

Type IF (can be with large and small letters) and open bracket sign after =

Type the first condition which you want to be evaluated to determine cell content then type comma sign ( , )

Type cell content if the condition is evaluated true then type comma sign

Repeat steps 24 for the next condition and cell content according to that condition evaluation. Input them until all of them have been inputted

Type cell content if all the condition are evaluated false

Type close bracket sign
 Press Enter

The process is done!
Exercise
After you have understood how to do multiple IF statements in excel, now is the time you do an exercise! This exercise should help to sharpen your understanding!
Download the exercise file and answer all the following questions. Download the answer key file if you have done the exercise and want to check your answers. Or probably you are confused about how to answer and want to see the answers to help you!
Link of the exercise file:
Download here
Questions
 What is the score letter for each student in test 1?
 What is the score letter for each student in test 2?
 What is the score letter for each student in test 3?
Link of the answer key file:
Download here
Additional Note
If you need to evaluate more than one condition simultaneously or in one level, use AND or OR to help you.