blank cells

  • Thread starter Thread starter rudy
  • Start date Start date
R

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

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
 
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
 
rudy said:
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?
Click to expand...
I use:

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

Peter
 
Back
Top