Is there some way to get #VALUE! recognized as one of the conditions of an IF
function argument? For example, if D3 shows #VALUE! (as the result of a
"value error"), then one could ask, =IF(D3=#VALUE!,"bark","bite") or possibly
=IF(D3="#VALUE!","bark","bite"), and the result would be "bark" (since D3
really does equal "#VALUE!").
Bookmarks