Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statement using multiple conditions | Excel Worksheet Functions | |||
One cell takes multiple inputs | Excel Discussion (Misc queries) | |||
Double-Clicking a cell for Multiple Options | Excel Discussion (Misc queries) | |||
counting Multiple answers in 1 cell + column | Excel Discussion (Misc queries) | |||
counting Multiple answers in 1 cell + column | Excel Discussion (Misc queries) |