Zero (0) in cell

		Microsoft Office Forums > Microsoft Excel > Excel
Zero (0) in cell

01-18-2011, 09:29 PM

ConneXionLost ConneXionLost is offline

Windows XP Zero (0) in cell

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

Quote:

Originally Posted by macropod

No, it'll only hide 0s in the cells to which the custom format is applied.

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

Also,

Quote:

Originally Posted by macropod

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

Your formula would work better as:

Code:

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

to avoid the embarrassment of 0+4=""

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:37 PM.