# Show Cell Only If Value Is Greater Than 0 in Excel (2 Examples)

Get FREE Advanced Excel Exercises with Solutions!

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.

## 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

### 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. ## 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.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems. Akib Bin Rashid

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  