Try this:

=IF(OR(P7:R7="Y",P7:R7="N/A"),"Y","N")

This is an array formula and will need to be entered using cntrl +
shift + enter.