i am trying to use a cell to validate date below it.

if i have finished all the child tasks below that relate to the overall completion of the parent task, then I want it to say Yes

If all the child tasks are not complete, then i want it to say No.



Example;

I used this IF statement and all i get (no matter what is in the cells B11-B14) is #VALUE!
if i put all yes' or a combination of Yes or No ... nothing changes

=IF(B11:B14,"Yes","No")

cells B11 through B14 have data validation on them so that the only thing you can enter in the cells is a Yes or a No