I am having a problem with a formula and I want to fix it. I have two columns, both with a sum figured from a formula. The third column then takes the difference from those two colums. It's a simple formula. Every once in a while when the third column (the difference in the first two) is a 0 I get an error in that column. However, this happens frequently and I have other situations where it will figure the 0 without the error, same exact formulas. Anyone know how to fix it, or what causes this? It's driving me nuts that I can't figure it out. A co worker says she has the same problem with one of her spreadsheets. We both know excel pretty well, but apparently can't figure out the easy stuff.
This is the error code I get:
9.09E-13