IF formula

[bobby30]

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

[Sandy Mann]

Try:


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

--
HTH

Sandy
In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk


"bobby30" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[CLR]

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

Vaya con Dios,
Chuck, CABGx3


"bobby30" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>