Value correction

P

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.
 
K

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.
 
P

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
 
Top