function to check rows
 

I have the following example of rows

A B C D(function)
Y N 234 N
Y Y 234 Y
N Y 234 Y
N Y 234 Y
N Y 234 Y
Y N 435 N
Y N 435 N
Y N 435 N
Y N 435 N

I would like for D to have a function where it will return either Y or
N. It would return Y if B contained Y for the set of numbers... ie 234
or 435

Would someone provide me with some help. I have this if function.
Maybe this could be expanded?

=IF((AND(J2="N",D2="Y")),"Y","N")


--
exceluser2
------------------------------------------------------------------------
exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338
View this thread: http://www.excelforum.com/showthread...hreadid=556241

function to check rows
 

Hi!

Try this:

=IF(AND(B1="Y",OR(C1={234,435})),"Y","N")

Biff

"exceluser2" wrote
in message ...

I have the following example of rows

A B C D(function)
Y N 234 N
Y Y 234 Y
N Y 234 Y
N Y 234 Y
N Y 234 Y
Y N 435 N
Y N 435 N
Y N 435 N
Y N 435 N

I would like for D to have a function where it will return either Y or
N. It would return Y if B contained Y for the set of numbers... ie 234
or 435

Would someone provide me with some help. I have this if function.
Maybe this could be expanded?

=IF((AND(J2="N",D2="Y")),"Y","N")


--
exceluser2
------------------------------------------------------------------------
exceluser2's Profile:
http://www.excelforum.com/member.php...o&userid=31338
View this thread: http://www.excelforum.com/showthread...hreadid=556241