How Do You Hide The #Value

[Ray]

How do you hide the "#value" in a cell. I would like the
cell to appear blank untill the formula returns a number.

 

[Vasant Nanavati]

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

 

[Peo Sjoblom]

Why do you get a value error in the first place? If you try to do a
calculation with a text string you will get a value error since you
didn't post the formula that returned the error it's hard to know,
the long way is to do

=IF(ISERROR(formula)),"",formula))

however to get value errors is mainly due to less than good design.



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Kevin H. Stecyk]

Ray,

One way,

=if(iserror(YourFormula), "", YourFormula)

Effectively, if there is an error, it displays a blank. If there is no
error, it evaluates.

Hope that helps.

Kevin