any way to do this in bulk? as in 100 in one go?
loads of different forulas in the sheet.

"Gary''s Student" wrote:

You are correct. Although its not a REAL error, its enough to screw-up and
ADD or AVERAGE across a range of cells. That's why we should mask it out.
--
Gary''s Student - gsnu200908


"james" wrote:

i dont think its an error, just that unused fields are not filled in.

"Gary''s Student" wrote:

In general if your_formula give an error, then use:

=IF(ISERROR(your_formula),"",your_formula)
--
Gary''s Student - gsnu200908


"james" wrote:

getting the)
what about stopping a cell saying; #VALUE!
i have about 100 clees doing this when unused rows are left blank, any way
of doing this in bulk?