Hi need help with this simple task.
3 cells A1 A2 & A3,
if cell a2 has the number 1 in it I need cell A1 to display yes,
if cell a3 has the number 1 in it I need cell A1 to display no,
If both cells are blank I need A1 to be blank.

Thanks Much...
Diane

maybe...

=if(a2=1,"yes",if(a3=1,"no",if(and(a2="",a3=""),"","what goes here")))

What happens if both a2 and a3 contain 1?

What happens if A2 or A3 are not blank, but don't contain 1?

Diane wrote:
>
> Hi need help with this simple task.
> 3 cells A1 A2 & A3,
> if cell a2 has the number 1 in it I need cell A1 to display yes,
> if cell a3 has the number 1 in it I need cell A1 to display no,
> If both cells are blank I need A1 to be blank.
>
> Thanks Much...
> Diane

--

Dave Peterson

Hi & Thanks
When both cells A2 & A3 are blank A1 stays blank.
Only 1 cell A2 or A3 will have the number 1 in it.
Thanks dave


On Wed, 05 Sep 2007 06:20:05 -0500, Dave Peterson
<(E-Mail Removed)> wrote:

>maybe...
>
>=if(a2=1,"yes",if(a3=1,"no",if(and(a2="",a3=""),"","what goes here")))
>
>What happens if both a2 and a3 contain 1?
>
>What happens if A2 or A3 are not blank, but don't contain 1?
>
>Diane wrote:
>>
>> Hi need help with this simple task.
>> 3 cells A1 A2 & A3,
>> if cell a2 has the number 1 in it I need cell A1 to display yes,
>> if cell a3 has the number 1 in it I need cell A1 to display no,
>> If both cells are blank I need A1 to be blank.
>>
>> Thanks Much...
>> Diane

Thanks Dave, worked great...
Diane "Di"

On Wed, 05 Sep 2007 06:20:05 -0500, Dave Peterson
<(E-Mail Removed)> wrote:

>maybe...
>
>=if(a2=1,"yes",if(a3=1,"no",if(and(a2="",a3=""),"","what goes here")))
>
>What happens if both a2 and a3 contain 1?
>
>What happens if A2 or A3 are not blank, but don't contain 1?
>
>Diane wrote:
>>
>> Hi need help with this simple task.
>> 3 cells A1 A2 & A3,
>> if cell a2 has the number 1 in it I need cell A1 to display yes,
>> if cell a3 has the number 1 in it I need cell A1 to display no,
>> If both cells are blank I need A1 to be blank.
>>
>> Thanks Much...
>> Diane