IF formula

[bobby30]

Hi

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

In colum A answers are from 1 tol 7 but colum b only requires answe
from people in category 1 and 2 in cat a. How do I automatically fil
colum b with the words no response if col a answers 3 to 7. Exampl
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 usin
formulas.
Any help gratefully received.
Thank you.

Rober

 

[Sandy Mann]

Try:


=IF(A1="","",IF(A1>2,"No Response",""))

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[CLR]

=IF(A1="","",IF(OR(A1=1,A1=2),"Yes","No response"))

Vaya con Dios,
Chuck, CABGx3