IF And function

Copper Contributor

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.

1 Reply

@bgbur 

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")