Inconsistent "greater than" and "less than" calculations

**wpryan** · 02-10-2015, 08:46 AM

Hello, I have a column of cells into which I want to calculate some basic pass/fail criteria based on this formula

Code:

=IF(ISBLANK(C28),"",IF(D28>0.1,"Fail","Pass"))

The data for D28 is coming from another calculation, which is working correctly. If the result of the calculation is exactly 0.1, then most of the time I get a "Pass" return - which is incorrect (0.1 is not greater than 0.1). I say most of the time because although it happens this way most of the time, there are certain cells which give the correct answer.

..any idea what's going on?