=IF(COUNTIF(A2:D2,"Y")=4,"Y","N")
The only caveat there, is if there is potential for it to be be blank (neither an "N" or a "Y" for an entry).If with an N the result is N, it can be:
Excel Formula:=IF(COUNTIF(A2:D2,"N"),"N","Y")
What is the logic for the formula you want created?
What are the conditions that it should show a "Y"?
Is it only when all four cells are also "Y"?
If so, you can use:
Excel Formula:=IF(COUNTIF(A2:D2,"Y")=4,"Y","N")
Yes, please provide a picture of all the different combinations and expected outputs for each one.
=IF(AND(COUNTIF(E45:H45,"Y")=4,OR(I45="Y",I45="#N/A")),"Create Shipper","Not complete")
Is the value in column I the literal text value "#N/A", or is it the error code #N/A (it makes a BIG difference!).
If you aren't sure, find some cell that has that value in it. Let's say it is I50. Enter this formula in any cell and see what it returns:
=ISNA(I50)
If that returns TRUE, then you are dealing with the erorr code and not a literal text value.
If it is a literal text value, this formula should work (example is for row 45):
Excel Formula:=IF(AND(COUNTIF(E45:H45,"Y")=4,OR(I45="Y",I45="#N/A")),"Create Shipper","Not complete")
If it is an error code, the formula will end up being a bit more complex.