Execl in the table, I enter the equation, all of the following to a child care, appeared 0

Execl in the table, I enter the formula, following up to, the following line appeared 0, enter the function of the formula, then there # N / A, how to allow only 0 or # N / A is not, and the number of imported Also according to the findings of that formula, I would like to thank

increase IF () and iserror () function to determine.= If (iserror (you The formula ),””, your formula)

For example, to find the formula for vlookup (C1, “A1:B100”, 2,1)
can enter:
= if (iserror ( vlookup (C1, “A1:B100″, 2,1 )),””, vlookup (C1, “A1:B100”, 2,1)
)
a can.
error value Return on the value of the air, or they would implement the formula.