Formula help

[BlurredVision]

I'm looking for a way to accomplish the following

If question 1 is equal to No and question 2, 3, 4 are equal to yes, then 'true' else 'false'.

Here is want the data looks like

Table: ANS QUES
Row 1) No 1
Row 2) Yes 2
Row 3) Yes 3
Row 4) Yes 4

Thanks for any help given

 

[MIChad76]

Might want to use an array that reads the values into the array then displays true or false...