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

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

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

=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" wrote in message
oups.com...
So instead of seeing #VALUE! the cell will be seen as empty/blank?

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

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" wrote in message
oups.com...
So instead of seeing #VALUE! the cell will be seen as empty/blank?

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

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" wrote in message
oups.com...
So instead of seeing #VALUE! the cell will be seen as empty/blank?

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

Which one is the #VALUE, AD11 or AE11?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


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