Table cells data validation with formula and list

I have a table with 10 questions that require a yes/no answer, and I'm fine abbreviating with a "y" or an "n". My initial version has data validation with a list which has a lookup with a 'y' or an 'n' (blank cells not allowed as all 10 must be answered). But I expect many to be answered by the end users with ALL 10 questions with a 'y' - so to ease data entry, I created another column ( [All Correct?] ) and placed it prior to these questions which ask if all answers are yes, and put a y/n data validation list (y/n) in that cell as well. In my '10 questions' cells, I placed the following formula:

Formula:

Please Login or Register  to view this content.

Of course, now the problem is the questions cells return an error with the formula in them. Even when [AllCorrect?] is 'y', the question cells return on error because they display 'y' but they still contain the formula. So I need some sort of formula (in the cell itself and not through data validation?) to allow only a 'y' or an 'n' OR the formula to make them all 'y' when the [AllCorrect?] cell is y. VBA is not an option for this workbook.

A cell can contain either a value or a formula, but not both. Any attempt to make that happen will probably wind up with a circular reference. VB is the only solution.