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

### Method 1 – Showing Only When the Value Is Greater Than 0

Steps:

• Go to C5 and enter the following formula:
`=IF(B5>0,B5,"")`
• Press ENTER to get the output.

Formula Breakdown

• Here, B5>0 is the logical test.
• Since the statement is TRUE, Excel will return 12 as output. Otherwise, it would have shown nothing.
• Use Fill Handle to AutoFill up to C12.

Notice that for -37, Excel returned nothing.

Read More: Excel IF Statement Between Two NumbersÂ

### Method 2 – Displaying Only When the Sum Is Greater Than 0

The new dataset looks like this.

Steps:

• Select cell D5 and enter the following formula:
`=IF(SUM(B5:C5)>0,SUM(B5:C5),"")`
• 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
• Use Fill Handle to AutoFill up to D12.

## Related Articles

Get FREE Advanced Excel Exercises with Solutions!
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF