How can I make all the #VALUE! on the spreadsheet disappear?

's Computer Specifications

So instead of seeing #VALUE! the cell will be seen as empty/blank?

's Computer Specifications

=IF(ISERROR(your_formula),"",your_formula)

but it would be better to correct the root cause of the #VALUE error.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

"amirstal" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> So instead of seeing #VALUE! the cell will be seen as empty/blank?
>

's Computer Specifications

I got stuck trying to work it out.
Can you show me how to apply if the following is my formula:

=IF(AC11="a",AD11/AE11,IF(AC11="b",AE11/AD11,IF(AC11="c",AD11*AE11)))

Thanks.

Bob Phillips wrote:
> =IF(ISERROR(your_formula),"",your_formula)
>
> but it would be better to correct the root cause of the #VALUE error.
>
> --
> ---
> HTH
>
> Bob
>
> (change the xxxx to gmail if mailing direct)
>
>
> "amirstal" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > So instead of seeing #VALUE! the cell will be seen as empty/blank?
> >

's Computer Specifications

Try this:
=IF(ISERROR(IF(AC11="a",AD11/AE11,IF(AC11="b",AE11/AD11,IF(AC11="c",AD11*AE11)))),"",IF(AC11="a",AD11/AE11,IF(AC11="b",AE11/AD11,IF(AC11="c",AD11*AE11))))

theSquirrel

amirstal wrote:
> I got stuck trying to work it out.
> Can you show me how to apply if the following is my formula:
>
> =IF(AC11="a",AD11/AE11,IF(AC11="b",AE11/AD11,IF(AC11="c",AD11*AE11)))
>
> Thanks.
>
>
>
> Bob Phillips wrote:
> > =IF(ISERROR(your_formula),"",your_formula)
> >
> > but it would be better to correct the root cause of the #VALUE error.
> >
> > --
> > ---
> > HTH
> >
> > Bob
> >
> > (change the xxxx to gmail if mailing direct)
> >
> >
> > "amirstal" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > So instead of seeing #VALUE! the cell will be seen as empty/blank?
> > >

's Computer Specifications

Which one is the #VALUE, AD11 or AE11?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

"amirstal" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I got stuck trying to work it out.
> Can you show me how to apply if the following is my formula:
>
> =IF(AC11="a",AD11/AE11,IF(AC11="b",AE11/AD11,IF(AC11="c",AD11*AE11)))
>
> Thanks.
>
>
>
> Bob Phillips wrote:
>> =IF(ISERROR(your_formula),"",your_formula)
>>
>> but it would be better to correct the root cause of the #VALUE error.
>>
>> --
>> ---
>> HTH
>>
>> Bob
>>
>> (change the xxxx to gmail if mailing direct)
>>
>>
>> "amirstal" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > So instead of seeing #VALUE! the cell will be seen as empty/blank?
>> >
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
spreadsheet tab disappear	inungh	Microsoft Excel Programming	4	19th Dec 2008 09:02 PM
make textbox disappear	=?Utf-8?B?Q2Fyb2w=?=	Microsoft Word Document Management	3	8th Mar 2007 08:35 PM
make BCC disappear	=?Utf-8?B?YmlsbHlfc2hhdw==?=	Microsoft Outlook Installation	2	24th Jul 2006 05:40 AM
How do I make it disappear?	Ralphael1	Microsoft Excel New Users	1	12th Oct 2005 12:19 AM
Re: Colored tabs disappear when opening XP spreadsheet with Excel 2000	J.E. McGimpsey	Microsoft Excel Misc	0	30th Sep 2003 03:56 PM