If(AND(Bx="xxx")*and(bx="aaa")*and(bx="bbb")*and( bx="ccc")*and(px="r"),"Y","N"))

If you remove the last ")" and replace the "x" with a valid row number your
formula is logically correct.

However, you might want to try it like this:

=IF(AND(B1="xxx",B2="aaa",B3="bbb",B4="ccc",P1="r" ),"Y","N")

Use the correct row numbers in the cell references.

--
Biff
Microsoft Excel MVP


"Terri Farm" wrote in message
...
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