you can use iserror function or iserr function.

=if(iserr(your formula),"",your formula)

On Oct 21, 12:10*am, 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?