ExcelBanter - Multiple Conditions in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Multiple Conditions in a cell (https://www.excelbanter.com/excel-worksheet-functions/30245-multiple-conditions-cell.html)

Maya

Multiple Conditions in a cell

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

Peo Sjoblom

=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

Maya

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

Art

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" wrote in message
...
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

All times are GMT +1. The time now is 01:52 AM.