Using IF across multiple sheets

Hello.

I have tried searching for this on the forum but did not find a solution. If I am missing an already posted solution, please direct me to it.

The issue: I am trying to compare the value of cell B2 from three different sheets. The value can only be either Y or N. In my fourth sheet, I want to make B2 equal to Y if atleast one of the other B2s is Y, else it should be N.

Thanks.

There are several ways that you could do this - here is one of them:

=IF(LEN(SUBSTITUTE(Sheet1!B2&Sheet2!B2&Sheet3!B2,"Y",""))<3,"Y","N")

Hope this helps.

Pete

Thank you both. I found L-Drr's solution to be more intuitive.