| 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 | |||
Hybrid Mode
