**Excel** is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in **Excel**. Sometimes we want our dataset to arrange in a way that hides all the values lesser than 0. We can easily do that in **Excel**. In this article, I will illustrate **2** suitable examples in **Excel** to show only if greater than **0**. That means, **Excel** will show values only if the values are greater than **0**.

## Download Practice Workbook

Download this workbook and practice while going through the article.

## 2 Examples to Show Cell Only If Value Is Greater Than 0

This is the dataset for today’s article. We have some numbers. I will show how you can demonstrate only the values greater than **0**.

### 1. Show Only When Value Is Greater Than 0

First of all, I will explain to you how to show a number only when the value is greater than **0**. For this example, I will use **the IF function**. Let’s follow the instructions below to learn!

__Steps:__

- Go to
**C5**and write down the following formula

`=IF(B5>0,B5,"")`

- Then, press
**ENTER**to get the output.

__Formula Explanation__

- Here,
**B5>0**is the**logical test**. - Since the statement is
**TRUE**,**Excel**will return**12**as output. Otherwise, it would have shown**nothing.**

- Then, use
**Fill Handle**to**AutoFill**up to**C12**.

** **

Notice that for **-37**, **Excel** returned nothing.

**Read More: ****Excel IF Statement Between Two Numbers (4 Ideal Examples)**

### 2. Display Only When Sum Is Greater Than 0

Now, I will show another example, Now, I will take **2** numbers and add them. After that, **Excel** will show only those sum values that are greater than **0**.

The new dataset looks like this.

Here are the steps to follow.

__Steps:__

- First of all, select cell
**D5**and write down the following formula

`=IF(SUM(B5:C5)>0,SUM(B5:C5),"")`

- After that, press
**ENTER**to get the output.

**Formula Breakdown**

**SUM(B5:C5)>0**→ This is the logical statement.**Output:**TRUE

**SUM(B5:C5)**→ This will calculate the sum of**B5**and**C5**.**Output:**55

**IF(SUM(B5:C5)>0,SUM(B5:C5),””)**→ Since the logical statement is**TRUE**, the output will be**SUM(B5:C5)****Output:**55

- Then, use
**Fill Handle**to**AutoFill**up to**D12**.

**Read More: ****How to Find Sum If Cell Color Is Green in Excel (4 Easy Methods)**

## Conclusion

In this article, I have illustrated **2** suitable examples in **Excel** to show only if greater than **0**. That means, **Excel** will show values only if the values are greater than **0**. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below. Please visit **Exceldemy** for more useful articles like this.

## Related Articles

**How to Use Conditional Formatting If Statement Is Another Cell****Use If Then Else Statement in Excel VBA (4 Examples)****Prepare IF Statement Contains Multiple Words in Excel****How to Use Wildcard with If Statement in Excel (5 Methods)****Use IF Function with OR and AND Statement in Excel****Use Multiple IF Statements in Excel Data Validation****How to Check If Cell Contains One of Several Values in Excel**