I came over this strange problem i cant seem to figure out.
32 32,2 =ABS(B6-C6) =D6 0,2 =IF(E6<=F6;"OK";"Fault")
32,00 32,20 0,2 0,2 0,2 Fault
Formula clearly states that if 0,2<=0,2 then OK but it calculates as Fault instead???
if i just write the number 0,2 instead of either =ABS(B6-C6) or =D6 the logic <= in the if statement computes correctly and shows OK.
I have checked the formatting of the cells and all cells registers as numbers.
The really strange part is this: this fault does not occur for numbers that are less then 32, I have tested several combinations like 30 30,2 where the difference is exactly the same with the identical difference but it shows up as OK.
When the numbers are 31,9 32,1 with the difference 0,2 it fails, and so does it fail for all numbers larger than 32 with difference 0,2 but it is OK for all numbers less than 32 with difference 0,2.
I need help seeing the logic here.... Any ideas on what i am overlooking?
Bookmarks