Hello, I have a column of cells into which I want to calculate some basic pass/fail criteria based on this formula
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?
Code:
=IF(ISBLANK(C28),"",IF(D28>0.1,"Fail","Pass"))
..any idea what's going on?