how do I skip blank cells when writing formulas

G

Guest

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?
 
D

David Biddulph

KatB said:
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?
Click to expand...

=IF(A1="","",A1+your value)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use & with two formulas 2
sumif returns blank if all cells blank 7
How to reference last non-blank cell value from a column cells? 2
Conditional Formatting 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Blank Cells vs. Zero Values 2
Counting blanks as zeros 1
How do I get Rid of the Circumflex Accent (Caret) 2

Top