Hide #VALUE! error in cell?
I have a very long formula that depends on other cells to be filled in before
it shows a value. When those cells are not filled in, the #VALUE! error
appears. That error effects the rest of the sheet as it is needed for other
cells to work properly.
I saw someone posted:
=IF(ISERROR(your_formula),"",your_formula)
When I entered my formula, it told me there was an error in that formula,
which of course meant my problem wasnt fixed.
Any help would be appreaciated
|