function to check rows

E

exceluser2

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 o
N. It would return Y if B contained Y for the set of numbers... ie 23
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"
 
Top