#VALUE!

[dwolf]

Is there a way to hide the "#value!" so it does not show in the cell?

 

[Barb Reinhardt]

One way is to put a conditional format and look for

=ISERROR(A1)

where A1 is the cell of interest. You can change the font to white.
Alternatively, you could put

=if(iserror(Your formula),"",Your formula)

 

[Per Jessen]

Hi

Try something like this:

=If(IsError(yourFormula),"",yourFormula)

Hopes this helps.
....
Per

 

[AltaEgo]

As per the others. However, in some instances, you may be able to work
around the problem using inbuilt functions. Examples:

Data
A1 = 1
A2 = text
A3 = 3

=A1+A2+A3 will return #value! whereas =Sum(A1:A3) will return 4.
= A1*A2*A3 will return #value! whereas =Product (A1:A3) will return 3

 

[Bernard Liengme]

1) alter your formula
=IF(ISERROR(your_formula),"", your_formula)
example
IF(ISERROR(A1/B1),"",A1/B1)

2) use conditional formatting to hide #VALUE
suppose the cell is B5; then use formula in conditional formatting
=ISERROR(B5) and set the font color the same as the cell background thereby
making it invisible (except when the cell is selected) .

Method 1 is best if you are printing the worksheet
best wishes