Multiple IF Statements in Excel


Home >> How to Use Excel Tutorial >> Excel Formulas List >> 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 step-by-step.

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 step-by-step 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 step-by-step 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

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

    Multiple IF Statements in Excel - Screenshot of Step 1

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

    Multiple IF Statements in Excel - Screenshot of Step 2

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

    Multiple IF Statements in Excel - Screenshot of Step 3

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

    Multiple IF Statements in Excel - Screenshot of Step 4

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

    Multiple IF Statements in Excel - Screenshot of Step 5

  6. Type cell content if all the condition are evaluated false

    Multiple IF Statements in Excel - Screenshot of Step 6

  7. Type close bracket sign

    Multiple IF Statements in Excel - Screenshot of Step 7

  8. Press Enter
  9. The process is done!

    Multiple IF Statements in Excel - Screenshot of Step 9



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.



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert