Thank you! I'll give it a try.

"Brian Taylor" wrote:

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.