Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I make all the #VALUE! on the spreadsheet disappear?
So instead of seeing #VALUE! the cell will be seen as empty/blank?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to make a form self disappear | Excel Programming | |||
How to make excel disappear! | Excel Discussion (Misc queries) | |||
How do I make it disappear? | New Users to Excel | |||
Make a button disappear | Excel Programming | |||
how to make dropdown arrow disappear in vba | Excel Worksheet Functions |