IF function in Excel doesn't work properly

Question

Hi,

I have put a simple IF function in my spreadsheet, checking if the cell value is less or equal than 0.1, if true return "PASS" , otherwise return "FAIL". But the equal condition doesn't seem to take effect:

I used the same formulae and pointed it to a cell in which I simply typed 0.1 and it worked fine. However, it doesn't want to work when it is pointing to a cell whose value is result of another function.

Does anyone have any idea what I am missing here?

Cheers, Leyla

Answer 1

re: still failing

set the number format on the failed cell out to 15 decimal places.
You will immediately see whether the number is > 1.

NLtL

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU (free excel programs)

Answer 2

Just an idea:

=IF(ABS(E21)<=0.1,"Pass", "Fail")

I might apply Round to the cell to take care of small precision errors, as the function may actually hold a value like 0.1000001

Answer 3

Thank you. It was indeed a non-zero digit at 11th decimal place