Zero (0) in cell

macropod · #5 01-18-2011, 09:47 PM

Quote:

Originally Posted by ConneXionLost

Please note the OP's question; the part where it refers to "cell formatting".

Your point being?

Your advice:

Quote:

it will hide ALL zeros

is plain wrong. It will only hide 0s in the cells to which the custom format is applied - not all cells in the worksheet.

As for:

Quote:

Originally Posted by ConneXionLost

Your formula would work better as:

Code:

IF(AND(A1=0,B1=0),"",A1+B1)

to avoid the embarrassment of 0+4=""

I was quite deliberate in using the OR statement, for the reasons I gave. With your variant, if -A1=B1, you'll still get a 0 display.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM
How can I make a cell color RED under the Today's date cell?	Learner7	Excel	2	07-08-2010 12:52 AM
Help reg Protection of cell.	aligahk06	Excel	1	09-02-2009 05:45 PM
Cell formatting	Niko	Excel	5	04-23-2009 12:05 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM