Hello everyone,
I'm stuck at solving this formula issue (and i don't know if i'm using the correct one). Thus, i'm reaching help from expert out there to help me.
I have this condition that i should meet;
.
.. (OD1-OD2)<0.0005, (OD2-OD3)<0.0005, (OD3-OD4)<0.0005, (O4-OD5)<0.0005 (Only when all this condition meet, the result will show pass)
The formula that i used is ;
=IF(AND((OD1-OD2)<0.0005,(OD2-OD3)<0.0005,(OD3-OD4)<0.0005,(OD4-OD5)<0.0005),"Pass","Fail")
But, i'm having problem since the formula will judge as Pass even one of the condition is negative. eg; -0.0005
So i need help to alter my formula to judge as Fail if any condition got any negative less than 0.0005.
OD.PNG
Bookmarks