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