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.