Value correction

[P. Zicari]

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.

 

[Kevin B]

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.

 

[Pete_UK]

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