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.

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.

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.