Hi

I would like to ask for assistance setting a formula for a worksheet I am working on.

In colum A answers are from 1 tol 7 but colum b only requires answer from people in category 1 and 2 in cat a. How do I automatically fill colum b with the words no response if col a answers 3 to 7. Example below.

A B
3 No response
4 No response
1 Yes

I have been trying work this out for a while and I am new to using formulas.
Any help gratefully received.
Thank you.

Robert