Results showing 0.00 and (0.00)

**hvaleagues** · 08-19-2011, 10:41 AM

I have a column that I use to check by my entries into other columns and should produce all 0's (unless I made a mistake somewhere). This column however produces both 0.00 and (0.00), I understand that the (0.00)'s are probably a result of the cell result actual being (0.0002) or some other fractional negative, however when I change all the numbers used in the calculation of that cell and format it for 20 decimal places, they are no small fractional values anywhere.

What formula can I use to have it show both 0.00 and (0.00) as 0.00? Here is my current formula:

=IF(DZ2="","",SUM(O2-DZ2))

Secondly, I would like to use conditional formatting to highlight cells in that column that are not equal to 0.00. That way I can call attention to any errors.

I guess if I solve the first issue, then the conditional formatting will be much easier.

**shg** · 08-19-2011, 10:54 AM

=if(dz2="","", round(o2-dz2, 6))

**gjlindn** · 08-19-2011, 10:56 AM

Please Login or Register  to view this content.

This impacts all negatives, showing them as a positive, but in your case it probably doesn't matter since anything that does not equate to zero is what you're testing for. Let me know if you can't get the conditional formatting to work.

**hvaleagues** · 08-19-2011, 02:09 PM

First off thanks to both of you, for your prompt answers. Both methods work and I have solved my first issue. However, now I am stuck on the conditional formatting part. Thanks to your formulas I have gotten rid of the (0.00)'s and now have a column full of 0.00 and blank cells. I want to highlight any any cell that is not either a 0.00 or a blank cell. I can't seem to get the blank cell thing to work with conditional formatting. Is there a trick to that?