Forum Discussion
IF And function
I am having issues with the use of both <= and >=. I can get one condition to work if it is equal, but not the other. Line 977 is the issue.
Use
=IF(AND(ROUND(C2,4)<=ROUND(A2,4),ROUND(C2,4)>=ROUND(B2,4)),"Pass","Fail")
or
=IF(AND(ROUND(C2-A2,4)<=0,ROUND(C2-B2,4)>=0),"Pass","Fail")