» Correcting Formatting Errors

Problem:
"List1 (A12:A14) contains three values that appear to be zeros.
Column B contains a formula checking whether the corresponding value in List1 does, in fact, equal to zero or not.
The formula returns a string indicating the result.
According to the formula, the first two values in List1 (A12:A13) are not zeros.
Therefore, using those values in our calculations will result in an error."

Solution:

The value in A12 is in fact a text and not a numerical value (the string ""$0.00"" was actually typed in, rather than just displayed).
To convert the text value in A12 into a numerical value, use this formula:
=IF(VALUE(MID(A2,2,99))=0,""Zero"",""Not a Zero"")
The value in A13 is in fact 0.0006, formatted to display two decimal places only.
To round it down to zero, use this formula:
=IF(ROUND(A3,2)=0,""Zero"",""Not a Zero"")
Once correcting the values in List1 (Corrected List1), they should all be recognized as zeros by our formula.

Screenshot // Correcting Formatting Errors