Something similar to the formula below will work:

=IF(ISERROR(B1),"",B1)

Replacing B1 with you reference cell.

Or you could use it in the cell the contains the formula:

=IF(ISERROR(Your_Formula),"",Your_Formula)

Hope this helps.
--
Kevin Backmann


"P. Zicari" wrote:

Is there a way to get a cell that is referencing a formula to not show #value
before there is datat that will complete the cell. I am using Excel 07.

Thanks in advance.