Why the formula with #REF! still produces 0 value

Originally Posted by Sambo kid

Just tried to reproduce your formula and entered stuff in the reference cells, got a value, then when I delete what is in your C cell reference I just get #DIV/0! Not sure why you are getting the ref error. You deleting the whole column?

No, I just deleted the cell only

Is there a way to use a formula to check if that cell's FORMULA contains any illegal error text, e.g. #REF!?