I usually prefer to hide error using "" in IF construction, something like
However, if you have another formula, which depends on this cell, it turns #VALUE !, when the error is hidden. So "" does not make the cell empty. I wonder if there is any other solution to display the cell empty, which will play nicely with formulas, where it is used?
Code:
=if(iserror(),"",())
However, if you have another formula, which depends on this cell, it turns #VALUE !, when the error is hidden. So "" does not make the cell empty. I wonder if there is any other solution to display the cell empty, which will play nicely with formulas, where it is used?