writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 21:
Line 21: − +
→Examples
*=AND(2+3<10,-4-5<0) = TRUE
*=AND(2+3<10,-4-5<0) = TRUE
*=AND(1/2=0.5,1*-2=2) = FALSE
*=AND(1/2=0.5,1*-2=2) = FALSE
*=AND(a+b=c,d+e=f)=NAN, because L1,L2 are not a logical values
*=AND(a+b=c,d+e=f)=NAN, because l1,l2 are not a logical values
*Let A1= 70, =AND(50<A1,A1<125)=TRUE, because 70 is lies between 50 and 125
*Let A1= 70, =AND(50<A1,A1<125)=TRUE, because 70 is lies between 50 and 125