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?
|