Forgot the IF and misplaced parens.

=IF(ISERROR(formula),"",formula)


Gord

On Tue, 02 Dec 2008 14:20:15 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Generally you check for empty or not numeric cells and return a blank cell
instead of the error.

Or the simpler =ISERROR(formula),"",(formula)

But note that the ISERROR will mask any error.

What formulas do you have that return the #VALUE! error?


Gord Dibben MS Excel MVP


On Tue, 2 Dec 2008 13:06:07 -0800, Sol
wrote:

I have created an "Invoice" template to allow me to bill my client for work
done on an hourly basis. The template calculated the total cost for each job
and the total of all costs. However, in the cells that contain the
calculated values appears #VALUE! until the hours and rates are entered. Is
there a way to suppress that legend? This is important because the template
will generally show more rows than is needed for most clients.