If #1, #4, and either #2 or #3 are yes, then object is hazardous)

[z75455]

This is the question.

[TABLE="width: 444"]
<tbody>[TR]
[TD="colspan: 27"]5. Based on the evaluation above is the object a food safety hazard? (If #1 , #4 , and either #2 or #3 are yes, then object is hazardous)[/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

I would like cell A12 to show the text "object is hazardous" if these conditions are meet=if A1 & a4 And either A2 or A3 are yes.

Thank you in advance for your help.

 

[shg]

=and(a1, a4, or(a2, a3))

 

[Scott T]

Is you did not say what should be displaed if the conditions are not meet this will show blank

=IF(AND(A1="yes",A4="yes",OR(A2="yes",A3="yes")),"object is hazardous","")

 

[z75455]

=and(a1, a4, or(a2, a3))

Thank you!

 

[z75455]

Thank you

 

[z75455]

Solved!