@BW29, please note that your thread title falls foul of Forum Rules.
Your post title should accurately and concisely describe your problem - in this case perhaps something along the lines of: "Inconsistent IF Results"
(I appreciate in this instance it probably isn't obvious how to best describe given the Rounding issue is not obvious - on that basis I have on this occasion modified for you).
Please also avoid posting in CAPS - this is in forum-geek terms interpreted as shouting.
Regards solution - you can just round the result:
D1:
=IF(ROUND(C1,3)>0.015,"FAIL","PASS")
or, if you prefer to dispense with C1 altogether:
D1:
=IF(ROUND(A1-B1,3)>0.015,"FAIL","PASS")
Note the use of SUM in SUM(A1-B1) is superfluous.
Thanks
Bookmarks