In Excel, the IF function is mainly used to test certain criteria and to perform different actions depending on the result. Sometimes you can use one IF function inside another to test multiple conditions. That is called as Nested IF condition. Here, we will show the simple formula used to find the value based on the Nested IF Condition in Excel. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula:
- The IF function can be placed inside another IF function to handle multiple conditions.
- You can use the below formula to perform the “Nested IF” action in Excel.
=IF(Value 1,Result 1,IF(Value 2,Result 2,IF(Value 3,Result 3,IF(Value 4,Result 4,Result 5))))
Syntax Explanations:
- IF – In Excel, the IF function helps to return one value for a TRUE result, and another for a FALSE result.
- Value – It represents the input value of the cell.
- Result – It is the value that is displayed in the selected cell.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Example:
Let’s consider the below example.
- Here we will enter the input values in Column B and Column C , also given the criteria table in Column F and Column G.
- Now we are going to find the student’s grade points based on their scores.
- So apply the above-given formula to the formula bar section and press the “Enter” key.
- Finally, it will display the result as per the below image.
Wrap-Up:
From this tutorial, you can get some clarification on how to use the “Nested IF” condition in Excel. Hope you like this article. Please feel free to share your comments. Thank you so much for visiting our site!! To learn more, check out Geek Excel *and Excel Formulas *!!
Top comments (0)