[Error messages]

Sometimes something regarding using formulas can go wrong and an error message will appear, but there is no reason to be worried, because again Excell will help us to fix it.

First of all, we can figure it out by the error message that appears in the cell where the formula is (a text that has in from an #). The most common messages are :DIV/O, N/A, NAME, NULL, REF, VALUE. Or more useful for us can be the error checker from the Formulas tab – Error Checking Button.