#1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default #VALUE!

Is there a way to hide the "#value!" so it does not show in the cell?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,355
Default #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?

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 703
Default #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?


  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 245
Default #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?


  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 563
Default #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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"