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