hide formula in cells till data is available for calc

  • Thread starter Thread starter kiwi
  • Start date Start date
K

kiwi

I recall being able to copy a formula in a column and hiding it until data
becomes available to complete the calculation. This way you don't have a
series of #value# in the work sheet.
The formula contains an absolute reference as well.

Thanks,

Kiwi
 
A look at your formula would have been nice.

=IF(cellref="","",do something) traps for cellref having no data.


Gord Dibben MS Excel MVP
 
Back
Top