Multiple Conditions in a cell

=IF(AND(A1="x",B1="y"),C1)



Regards,

Peo Sjoblom



"Maya" wrote:

> I am trying to get information from Cell A and Cell B and then sum Cell C. I
> cannot seem to link conditions and need help please

I have
=if(and(a1="1",b1="y"),c1)
and all I get is "FALSE"
what am I doing wrong

"Peo Sjoblom" wrote:

> =IF(AND(A1="x",B1="y"),C1)
>
>
>
> Regards,
>
> Peo Sjoblom
>
>
>
> "Maya" wrote:
>
> > I am trying to get information from Cell A and Cell B and then sum Cell C. I
> > cannot seem to link conditions and need help please

If the 1 in A1 is a number, remove the quotes from around the 1 in your
formula:

=IF(AND(A1=1,B1="y"),C1

Art

"Maya" <[email protected]> wrote in message
news:[email protected]...
>I have
> =if(and(a1="1",b1="y"),c1)
> and all I get is "FALSE"
> what am I doing wrong
>
> "Peo Sjoblom" wrote:
>
>> =IF(AND(A1="x",B1="y"),C1)
>>
>>
>>
>> Regards,
>>
>> Peo Sjoblom
>>
>>
>>
>> "Maya" wrote:
>>
>> > I am trying to get information from Cell A and Cell B and then sum Cell
>> > C. I
>> > cannot seem to link conditions and need help please

=IF(AND(A1="x",B1="y"),C1)



Regards,

Peo Sjoblom



"Maya" wrote:

> I am trying to get information from Cell A and Cell B and then sum Cell C. I
> cannot seem to link conditions and need help please

I have
=if(and(a1="1",b1="y"),c1)
and all I get is "FALSE"
what am I doing wrong

"Peo Sjoblom" wrote:

> =IF(AND(A1="x",B1="y"),C1)
>
>
>
> Regards,
>
> Peo Sjoblom
>
>
>
> "Maya" wrote:
>
> > I am trying to get information from Cell A and Cell B and then sum Cell C. I
> > cannot seem to link conditions and need help please

If the 1 in A1 is a number, remove the quotes from around the 1 in your
formula:

=IF(AND(A1=1,B1="y"),C1

Art

"Maya" <[email protected]> wrote in message
news:[email protected]...
>I have
> =if(and(a1="1",b1="y"),c1)
> and all I get is "FALSE"
> what am I doing wrong
>
> "Peo Sjoblom" wrote:
>
>> =IF(AND(A1="x",B1="y"),C1)
>>
>>
>>
>> Regards,
>>
>> Peo Sjoblom
>>
>>
>>
>> "Maya" wrote:
>>
>> > I am trying to get information from Cell A and Cell B and then sum Cell
>> > C. I
>> > cannot seem to link conditions and need help please

=IF(AND(A1="x",B1="y"),C1)



Regards,

Peo Sjoblom



"Maya" wrote:

> I am trying to get information from Cell A and Cell B and then sum Cell C. I
> cannot seem to link conditions and need help please

I have
=if(and(a1="1",b1="y"),c1)
and all I get is "FALSE"
what am I doing wrong

"Peo Sjoblom" wrote:

> =IF(AND(A1="x",B1="y"),C1)
>
>
>
> Regards,
>
> Peo Sjoblom
>
>
>
> "Maya" wrote:
>
> > I am trying to get information from Cell A and Cell B and then sum Cell C. I
> > cannot seem to link conditions and need help please

If the 1 in A1 is a number, remove the quotes from around the 1 in your
formula:

=IF(AND(A1=1,B1="y"),C1

Art

"Maya" <[email protected]> wrote in message
news:[email protected]...
>I have
> =if(and(a1="1",b1="y"),c1)
> and all I get is "FALSE"
> what am I doing wrong
>
> "Peo Sjoblom" wrote:
>
>> =IF(AND(A1="x",B1="y"),C1)
>>
>>
>>
>> Regards,
>>
>> Peo Sjoblom
>>
>>
>>
>> "Maya" wrote:
>>
>> > I am trying to get information from Cell A and Cell B and then sum Cell
>> > C. I
>> > cannot seem to link conditions and need help please

I am trying to get information from Cell A and Cell B and then sum Cell C. I
cannot seem to link conditions and need help please

=IF(AND(A1="x",B1="y"),C1)



Regards,

Peo Sjoblom



"Maya" wrote:

> I am trying to get information from Cell A and Cell B and then sum Cell C. I
> cannot seem to link conditions and need help please

I have
=if(and(a1="1",b1="y"),c1)
and all I get is "FALSE"
what am I doing wrong

"Peo Sjoblom" wrote:

> =IF(AND(A1="x",B1="y"),C1)
>
>
>
> Regards,
>
> Peo Sjoblom
>
>
>
> "Maya" wrote:
>
> > I am trying to get information from Cell A and Cell B and then sum Cell C. I
> > cannot seem to link conditions and need help please

If the 1 in A1 is a number, remove the quotes from around the 1 in your
formula:

=IF(AND(A1=1,B1="y"),C1

Art

"Maya" <[email protected]> wrote in message
news:[email protected]...
>I have
> =if(and(a1="1",b1="y"),c1)
> and all I get is "FALSE"
> what am I doing wrong
>
> "Peo Sjoblom" wrote:
>
>> =IF(AND(A1="x",B1="y"),C1)
>>
>>
>>
>> Regards,
>>
>> Peo Sjoblom
>>
>>
>>
>> "Maya" wrote:
>>
>> > I am trying to get information from Cell A and Cell B and then sum Cell
>> > C. I
>> > cannot seem to link conditions and need help please