EXECL table can not be calculated from a formula error values can be automatically converted to …

Made a EXECL table, is calculated using the formula the result of many wrong value # DIV / 0!, The day may not seem very attractive, there is no way you can directly to this # DIV / 0! Converted into 0 or blank way to do that?

in your formula to determine the outside add a layer of iserror .= IF (ISERROR (your formula), 0, your formula like = IF )========== (ISERROR (VLOOKUP (“Joe Smith”, A:B, 2,0 )),””, VLOOKUP (“Joe Smith”, A:B, 2,0))