Excel Formulas To Find the Value Based on Nested IF Condition!!
Tags: excelformula, excelformulas
Published: 2021-03-01 11:51:35

---
title: Excel Formulas To Find the Value Based on Nested IF Condition!!
published: true
date: 2021-03-01 11:44:16 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-find-the-value-based-on-nested-if-condition/
---

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](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Nested If Example](https://geekexcel.com/wp-content/uploads/2021/03/Nested-If-Example.png)](https://geekexcel.com/?attachment_id=22176#main)<figcaption id="caption-attachment-22176">Nested If Example</figcaption>

## 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](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)(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](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)** helps to return one value for a **[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)** result, and another for a **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)** 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**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/03/Input-Ranges.png)<figcaption id="caption-attachment-22177">Input Ranges</figcaption>

- Now we are going to find the student’s grade points based on their scores.

![Criteria](https://geekexcel.com/wp-content/uploads/2021/03/Criteria.png)<figcaption id="caption-attachment-22178">Criteria</figcaption>

- So apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section and press the **“Enter”** key.
- Finally, it will display the result as per the below image.

![Result](https://geekexcel.com/wp-content/uploads/2021/03/Result.png)<figcaption id="caption-attachment-22179">Result</figcaption>

## 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](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Excel Formulas to Check If the Cells Contain Certain Text!!](https://geekexcel.com/excel-formulas-check-if-cells-contain-certain-text/)**
- **[Excel Formulas to Check the Values If Cells Begin with Given Criteria!!](https://geekexcel.com/excel-formula-if-cells-begin-with-given-criteria/)**