ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   #VALUE! (https://www.excelbanter.com/new-users-excel/253037-value.html)

dwolf

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

Barb Reinhardt

#VALUE!
 
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?


Per Jessen[_2_]

#VALUE!
 
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?



AltaEgo

#VALUE!
 
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?



Bernard Liengme[_2_]

#VALUE!
 
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?




All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com