=IF(A1="","",IF(OR(A1=1,A1=2),"Yes","No response"))
Vaya con Dios,
Chuck, CABGx3
"bobby30" wrote in
message ...
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
--
bobby30
------------------------------------------------------------------------
bobby30's Profile:
http://www.excelforum.com/member.php...o&userid=35301
View this thread: http://www.excelforum.com/showthread...hreadid=550822