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

re: "what am I missing"

You are missing the formula.
You are missing the column the formula is checking.
You are missing the ability to quickly tell if a number is treated as text,

. because you have centered values.

'---
NLtL

Answer 4

Thanks for your reply.

I removed the centering and I am pretty sure the number is treated as number:

In second table I bumped the value of 85.1 by 0.001 to push the difference just below 0.1, and now it's giving me a PASS. Whereas, as per my formulae it should give me a PASS when the difference is exactly 0.1 too.

I don't understand what you mean when you say I am missing the column the formula is checking, it's Column "E" Row 21.

Answer 5

Thanks heaps. Round function fixed it!