I have a spreadsheet with 6 columns of data. If any of say A2, B2, C2, D2 or E2 equal y, then the 6th column will be n. However if A2 and B2 and C2 and D2 and E2 ALL equal n then the 6th column will be Y.

I have got the IF statement working for the first section:

=IF(A2="y","N",IF(B2="y","N",IF(C2="y","N",IF(D2="y","N",IF(E2="y","N","")))))

How do I incorporate the second part into the formula?

Thanks in advance.