We can use the **IF Function** to check if a cell has a value that is greater than the specified **criteria**. The **IF function** returns **TRUE** if the condition is met and **FALSE** if otherwise. The steps below will walk through the process.

*Figure 1: How to Check if a Cell is Greater Than*

**Syntax**

**=** **IF(logical_test,[value_if_true],[value_if_false])**

**Formula**

**=IF(C4>1000,"Pass","Fail")**

**Setting up the Data**

- We will set up the data by inputting the
**WEIGHT**into**Column A** - We will input the
**cost per kg**into**Column B** **Column C**contains the result of the multiplied values in**Column A**with**Column B****Column D**is where we want the formula to return the result**if the cells in Column C**are**greater than 1000**

* Figure 2: Setting up the Data*

**If a Cell is Greater than 1000**

- We will click on
**Cell D4** - We will insert the formula below into the cell

**=IF(C4>1000,"Pass","Fail")** - We will
**press the enter key**

* Figure 3: Result for Cell D4 Indicating it is Less Than 1000*

- We will click on
**Cell D4**again - We will
**double-click**on the fill handle (**the small plus sign at the bottom right of Cell D4**) and drag down to copy the formula into the other cells

* Figure 4: Result for Column D with the IF function*

**Explanation**

**=IF(C4>1000,"Pass","Fail")**

The logical test is checked if the value of IS **Cell C4** is **GREATER THAN 1000. **If this is** TRUE, **the **IF Function** returns **PASS** and **FAIL** if otherwise.

**Instant Connection to an Expert through our Excelchat Service**

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

## Leave a Comment