Excel Formulas to Check the Cell Value Based on IF Else Condition!!
Tags: excelformula, excelformulas
Published: 2021-02-20 10:18:34

---
title: Excel Formulas to Check the Cell Value Based on IF Else Condition!!
published: true
date: 2021-02-20 06:24:49 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-check-the-cell-value-based-on-if-else-condition/
---

The **IF Function** is a **built-in function in Excel** that is categorized as a **Logical Function**. Sometimes, you need to test the values based on certain conditions and then return the result for both True and False results. Do you have any good methods for solving this task in Excel? In this article, I introduce some formulas which can quickly solve this **IF else condition in Excel**.

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)

[![If Else](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/If-Else.png)](https://geekexcel.com/excel-formulas-to-check-the-cell-value-based-on-if-else-condition/if-else/#main)<figcaption id="caption-attachment-22034">If Else</figcaption>

## General Formula:

- To test a condition, and take one action if the condition is **[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/),** and another action if the condition is **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/),** use the below formula.

**=[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)(test value, true result, false result)**

## 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.
- **Test Value** – It is the input data from your worksheet.
- **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:

Refer to the below example image.

- First, we will enter the input value in **Column B** and **Column C**.

![Input Ranges](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Input-Ranges-19.png)<figcaption id="caption-attachment-22031">Input Ranges</figcaption>

- Then, 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.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Enter-the-formula-21.png)<figcaption id="caption-attachment-22032">Enter the formula</figcaption>

- Finally, we will get the results in the selected cell.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Result-24.png)<figcaption id="caption-attachment-22033">Result</figcaption>

## Closure:

On this page, we have described the simple way to **test the cell value with the If else condition and return the values based on its result Excel**. Please feel free to state your **query** or **feedback** for the above article. To learn more, check out  **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Check If Cell Contains All Values from a Range in Excel Office 365!!](https://geekexcel.com/check-if-cell-contains-all-values-from-a-range-in-excel-office-365/)**
- **[Excel Formulas to Check the Values If Cells Begin with Given Criteria!!](https://geekexcel.com/excel-formula-if-cells-begin-with-given-criteria/)**
- **[Excel Formulas to Match Occurrence Does not begin with Specific Value!!](https://geekexcel.com/excel-formulas-match-occurrence-does-not-begin-with/)**