Excel keeps 15 places of precision. Depending on your data, try to set your
formula to look at + or - one more place of precision than expected.

For example, I use a formula like: =IF(ABS(A1)<.001,"true","false") when
working with data that is has 2 places of precision (like dollar amounts).

LK

"Becky" wrote:

I am pulling my hair out at this point and need some help.

I have a worksheet with many cells and calculations.
I have calculations performing on results of a calculation. In then end of
all of this I have a If statement that says IF(Y4=0,"Yes","No")
In the function argument box it says that Y4 is false and the result inthat
cell is 0.
So it is telling me that 0 is not equal to 0.

I don't get it. This was a sheet I got from an end user and at first I
thought it was her formatting so I copied the contents and pasted the values
and did the calculations my self. Still same result. Then I started the
whole sheet over from scratch and still same result.

If this is not clear I can post the cells and their contents. Just let me
know what you need.