Thread: [Solved] not showing blank cell
View Single Post
 
Old 03-13-2014, 12:45 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

No problem. Just killing time. ;-)

You can suppress display of zeros for any particular spreadsheet.

File: Options: Advanced

Go about half way down to Display Options For This Worksheet. Make sure the worksheet you want is selected in the dropdown. Uncheck the box for Show A Zero In Cells That Have A Zero Value.

Otherwise, if you want to do it by equations, change the first to be:
=IF(OR(D3=0,E3=0),"",D3*E3)

If you don't have negative numbers:
=IF(MIN(D3:E3)=0,"",D3*E3)
or
=IF(MIN(D3:E3)>0,D3*E3,"")

Or you could conditionally format any cells that have a zero value to have the same font and background color.

Lots of ways to do this. The first is preferable. Less moving parts. :-)
Reply With Quote