[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

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

amirstal

12/11/2006 7:49:00 PM

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

Bob Phillips

12/11/2006 8:17:00 PM

0

=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" <amirstal@yahoo.com> wrote in message
news:1165866526.080325.306250@j44g2000cwa.googlegroups.com...
> So instead of seeing #VALUE! the cell will be seen as empty/blank?
>


amirstal

12/12/2006 2:53:00 AM

0

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" <amirstal@yahoo.com> wrote in message
> news:1165866526.080325.306250@j44g2000cwa.googlegroups.com...
> > So instead of seeing #VALUE! the cell will be seen as empty/blank?
> >

theSquirrel

12/12/2006 6:24:00 AM

0


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" <amirstal@yahoo.com> wrote in message
> > news:1165866526.080325.306250@j44g2000cwa.googlegroups.com...
> > > So instead of seeing #VALUE! the cell will be seen as empty/blank?
> > >

Bob Phillips

12/12/2006 9:41:00 AM

0

Which one is the #VALUE, AD11 or AE11?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"amirstal" <amirstal@yahoo.com> wrote in message
news:1165891962.096656.151800@n67g2000cwd.googlegroups.com...
>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" <amirstal@yahoo.com> wrote in message
>> news:1165866526.080325.306250@j44g2000cwa.googlegroups.com...
>> > So instead of seeing #VALUE! the cell will be seen as empty/blank?
>> >
>