#VALUE!

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

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)
--
HTH,

Barb Reinhardt



"dwolf" wrote:

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

Hi

Try something like this:

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

Hopes this helps.
....
Per

On 11 Jan., 21:00, dwolf wrote:
Is there a way to hide the "#value!" so it does not show in the cell?

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

--
Steve

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

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

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