AND function does not work
biwithse7en
Forums
Hi,
I have a dilema with building this equation to extract certain items in my population.
My population contains the following column and I just want to extract [3] and [4] out.
Category
[1]
[2]
[3]
[4]
My equation is Category =="[3]" .And. Cateogory =="[4]". This is a valid equation, however my extraction is blank. I was able to extract individual [3] and [4].
does anyone know why? Any input would be appreciative.
Thank you.
.AND. means that they both
.AND. means that they both have to be there to be true. I think you are looking for .OR. as you are looking for transactions with a 3 or a 4 or both.