Table cells data validation with formula and list

[HeyInKy]

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:

=IF([All Correct?]="y","y","")

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.

[sandy666]

Change your table to structured table and try this one: =IF([@[All correct]]="yes","yes","")

[dflak]

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.

[HeyInKy]

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.

That's what I was afraid of... thanks!

[sandy666]

Maybe I should type some details
A column - Questions
B column - Answers
C column - All Correct? (formula) C2: =IF([@[Answers]]="yes","yes","")

Questions, Answers, All Correct? are headers

[HeyInKy]

@sandy666 - I think I get it, but I don't think that's solving my problem. Thank...