Excel Formulas to Check If Cell Value is Greater than Given Criteria!!
Tags: excelformula, excelformulas
Published: 2021-02-18 09:00:41

---
title: Excel Formulas to Check If Cell Value is Greater than Given Criteria!!
published: true
date: 2021-02-17 12:03:20 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-if-cell-value-is-greater-than-given-criteria/
---

The **IF function** is a **built-in function** in Excel that is categorized as a **Logical Function**. This page will show the simple formula to **check if the cell value is greater than the given criteria** and take some action based on the result. 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)

![If cell value is greater than](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/If-cell-value-is-greater-than.png)<figcaption id="caption-attachment-21981">If the cell value is greater than</figcaption>
## General Formula:

- You can use the below formula to take one action when a cell is greater than a certain value.

**=[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)(A1>X,”Yes”,”No”)**

## Syntax Explanations:

- **IF** – The Excel **[IF Function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)** will help 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.
- **A1** – It represents the input value 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.

- Here, we will give the input values in **Column B** and **Column D**.

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

- Now we need to find the result of the students based on their marks.
- 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 then press the **“Enter”** key.

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

- Finally, the result will be shown in the selected cell as per the below image.

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

## Wind-Up:

In this way, we have checked the values from the cells based on certain criteria in Excel. If you feel this article is useful to you, then leave **feedback** in the below **comment** section. Thank you for Reading!! To learn more **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Count Number of Cells with String Length Greater than X!!](https://geekexcel.com/count-number-of-cells-with-string-length-greater-than-x/)**
- **[Formulas for Counting the Cells Greater than a Given Values in Excel!!](https://geekexcel.com/formulas-for-counting-the-cells-greater-than-a-given-values-in-excel/)**
- **[Excel Formulas to Sum the Values Greater than a Certain Date!!](https://geekexcel.com/excel-formulas-to-sum-the-values-greater-than-a-certain-date/)**
- **[Excel Formulas Used to Calculate the Subtotal by Invoice Number!!](https://geekexcel.com/excel-formulas-used-to-calculate-the-subtotal-by-invoice-number/)**