#1   Report Post  
Old January 11th 10, 09:00 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 3
Default #VALUE!

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

  #2   Report Post  
Old January 12th 10, 03:16 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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  
Old January 12th 10, 03:19 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
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  
Old January 12th 10, 11:17 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
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  
Old January 12th 10, 04:37 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
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 11:06 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017