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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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