D
dwolf
Is there a way to hide the "#value!" so it does not show in the cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
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)
=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)
P
Per Jessen
Hi
Try something like this:
=If(IsError(yourFormula),"",yourFormula)
Hopes this helps.
....
Per
Try something like this:
=If(IsError(yourFormula),"",yourFormula)
Hopes this helps.
....
Per
A
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
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
B
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
=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