How do I avoid repeating calculation in IF function?
"T. Valko" wrote in message
...
It all depends on what your formula looks like.
Sometimes, instead of repeating the formula like this:
=IF(ISNA(formula),"",formula)
You can reduce the error trap to the specific portion of the formula that
actually generates the error.
There is an easier way.
Put the formula in a different cell, then test the result of that.
For example, instead of putting
=IF(ISNA(VLOOKUP(A1,X:Y,2,0)),"",VLOOKUP(A1,X:Y,2, 0))
in cell B2, put
=VLOOKUP(A1,X:Y,2,0)
in B1, and
=IF(ISNA(B1),"",B1)
in B2.
|