| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I skip blank cells when writing formulas
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I skip blank cells when writing formulas
"KatB" wrote in message
... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Skip blank cells in diagrams | Charts and Charting in Excel | |||
| CSV file with 13space characters in blank cells | Excel Discussion (Misc queries) | |||
| enter numbers in blank cells | Excel Worksheet Functions | |||
| how to skip the blank cells | Excel Discussion (Misc queries) | |||
Linear Mode
