I have been trying for over an hour to get a formula to work. There are 4
specific items included in a column and 1 item in another column that if all
of these meet the criteria, i want a "Y" returned. I am using
If(AND(Bx="xxx")*and(bx="aaa")*and(bx="bbb")*and(b x="ccc")*and(px="r"),"Y","N"))
and I am not getting the "Y" result when the data in bx has the required yes
criteria. what am i doing wrong? I have tried many other ways and nothing
is working