how do I skip blank cells when writing formulas

's Computer Specifications

I'm using Excel 2003. I need to add a value to a large range of cells. Most
cells contain numbers greater than zero, some contain "0", and others are
blank. When I write formulas, it seems like blank cells are assumed to
contain "0". I need to be able to add something to the cells with a "0",
while leaving the blank cells blank. Is there a way to do this?

's Computer Specifications

"KatB" <(E-Mail Removed)> wrote in message
news:2961883E-505C-40E5-BFDD-(E-Mail Removed)...
> I'm using Excel 2003. I need to add a value to a large range of cells.
> Most
> cells contain numbers greater than zero, some contain "0", and others are
> blank. When I write formulas, it seems like blank cells are assumed to
> contain "0". I need to be able to add something to the cells with a "0",
> while leaving the blank cells blank. Is there a way to do this?

=IF(A1="","",A1+your value)
--
David Biddulph

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to skip cells with formulas in data entry?	LindaB	Microsoft Excel Misc	1	6th Mar 2008 05:05 PM
Number Cells skip blank cells, Excel 2000 & 2003	jfcby	Microsoft Excel Programming	4	31st Jul 2007 03:02 PM
Skip cells and copy formulas	nsharish20@gmail.com	Microsoft Excel Misc	5	13th Feb 2007 06:50 PM
skip blank rows when pasting formulas	=?Utf-8?B?TmV3c2dhbA==?=	Microsoft Excel Worksheet Functions	1	22nd Jun 2005 10:13 PM
How do I skip blank cells when copying over a range of cells?	=?Utf-8?B?dGF3ZWxscw==?=	Microsoft Excel Misc	2	7th Jun 2005 09:36 PM