Still not worded as clear as I would like, but let me take a guess. When you
say...

data in column b equals "57C", "77C","157c","858C"

do you mean the value in the cell in column b equals *either* "57C",
"77C","157c" *or* "858C"? If yes, then try this formula in row 2 and copy it
down as needed...

=IF(AND(OR(B2={"57C","77C","157c","858C"}),P2="r") ,"Y","N")

--
Rick (MVP - Excel)


"Terri Farm" wrote in message
...
OK. I started off in row 2 with the formula and just copy it down to the
bottom of my data. What I am trying to accomplish is get a "Y" returned
when
the data in column b matches my criteria and also matches my criteria in
column p. If the data in column b equals "57C", "77C","157c","858C" and
the
data in column p equals "r" for that specific row, i want a "y" to be
returned. I am getting an "n". If I take out all of the different
criteria
for column b specified in my formula except the one that actually matches
what's there, I am getting the desired result of "y".

"Rick Rothstein" wrote:

Showing us your non-working formula is always a good idea, but you need
to
couple that with a *full* explanation of what you expected that formula
to
do. Showing actual examples (using real cell addresses as opposed to
using
and 'x' as the row number) is also a good idea. The problem I am having
with
trying to figure out what your formula is supposed to be doing is it
looks
like you want the same cell (Bx) to be equal to "xxx", "aaa", etc. all at
the same time... that doesn't make sense to me.

--
Rick (MVP - Excel)


"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