blank cells

[rudy]

my table has columns with formulas. some of the rows are
blank. the formulas do not apply to the blank rows. in
some of the colums, in blank cells a zero prints and in
other columns a $ sign prints in empty cells , and others
get "#value!" while some remain empty.

my question is this - if there is no data, I would like
the cells to remain blank. how do I accomplish this?

 

[Chris R. Lee]

my table has columns with formulas. some of the rows are
blank. the formulas do not apply to the blank rows. in
some of the colums, in blank cells a zero prints and in
other columns a $ sign prints in empty cells , and others
get "#value!" while some remain empty.

my question is this - if there is no data, I would like
the cells to remain blank. how do I accomplish this?

Unfortunately, current versions of XL don't handle the 'blank' or 'empty'
attribute properly. "Professional" packages like RS/1 did this a quarter of
a century ago.

For the moment the best solution is to pose your question as specifically as
possible in microsoft.public.excel.worksheet.functions, where someone with
lots of patience will find a workaround.

Regards

 

[CLR]

Hi Rudy............

One way would be to actually delete the formulas from the blank
rows.............
Select > Right-click > Clear contents.............another might be to change
the font color to match the cell background on the blank rows........that
way you couldn't see the objectionable results..........

Vaya con Dios,
Chuck, CABGx3

 

[Peter]

my table has columns with formulas. some of the rows are
blank. the formulas do not apply to the blank rows. in
some of the colums, in blank cells a zero prints and in
other columns a $ sign prints in empty cells , and others
get "#value!" while some remain empty.

my question is this - if there is no data, I would like
the cells to remain blank. how do I accomplish this?

I use:

=IF(ISBLANK(B1)=TRUE," ",[your formula])

Peter