How Do You Hide The #Value

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

How do you hide the "#value" in a cell. I would like the
cell to appear blank untill the formula returns a number.
 
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)
 
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
 
Back
Top