In earlier versions of XL, you would have to do it like this:

=IF(ISERROR(your_formula),"",your_formula)

which you might like to use if the file is to be used by someone with
an earlier version. However, in XL2007 you can do it like this:

=IFERROR(your_formula,"")

Hope this helps.

Pete

On Apr 15, 7:05*pm, 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.