We've been asking for some kind of BLANK() or NULL() worksheet function for
some time. Haven't gotten it, so no, there's no way to do this. Unless of
course you want to use VBA to clear the cells with errors, and then if the
data changes, you need to repopulate the cells with formulas.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"hello" wrote in message
...
My question is similar to many others in this discussion group, but I have
searched pretty thoroughly and not found the answer to my exact
question...

What I want to do is to leave a cell completely blank if the result of an
ISERROR test (shown below) is true. I need that cell to be completely
blank,
because in another cell I have an INDIRECT formula that relies on the
COUNTA
function that refers to this first cell. If the IF(ISERROR...) formula
deposits a "" in a cell, it will be counted in the COUNTA formula, and
INDIRECT will pull the (nonexistent) value from this cell.

(This formula is on a sheet named calc)
=IF(ISERROR((raw!K285),"",(raw!J285-(raw!K285/raw!K273-1)*100))

=INDIRECT(CONCATENATE("'calc'!f",COUNTA(calc!$F:$F )+23))

Is there a way to do this? Thank you!