Thread: [Solved] Zero (0) in cell
View Single Post
 
Old 01-19-2011, 03:44 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

The way I interpret the question (and I could be wrong!) is if all of the precedent cells are empty then to 'not display a result', whilst if any of the cells contain a number then a result should be displayed (including 0 if that is a result).

To do that I'd use a formula (or variation thereof) like this:
Code:
=IF(COUNT(C3:D3),SUM(C3:D3),"")
Although, to be honest, the empty string causes problems if further arithmetic is performed from it. In my worksheets, I'd keep it simple and just display the 0 all of the time.

My 2c...
Reply With Quote