Need help - Multiple if function

It does make sense. Though it is not exactly what I am trying to accomplish. This is for a private school attendance tracker. They accept students from different districts and here is what I am trying to do: Lets say, I have student X on my roster. In his row, A1 is "Wright School District" and A2 is "P" as in present. There is another tab for invoicing where I want to only populate the attendance of the students from this specific district. The formula I am trying to write is this: If student's school district is "wright", copy A2 (which is P) to cell B2 (which is in another tab) So I want P to populate, not the count. Does that make sense?

Originally Posted by Sambo kid

If then statements have the elements of IF this condition is true do this, if not do that. So what are you trying to accomplish with if A1=x, then do what with C1 or B1? is this an if AND statement? =IF(A1="x",C1,B1) would be that if A1 equals x then you put the value in C1 somewhere, otherwise you put the value in B1 somewhere. or =IF(AND(A1="x",C1=B1),then do this, otherwise do that)
Does that make sense?

It does make sense. Though it is not exactly what I am trying to accomplish. This is for a private school attendance tracker. They accept students from different districts and here is what I am trying to do: Lets say, I have student X on my roster. In his row, A1 is "Wright School District" and A2 is "P" as in present. There is another tab for invoicing where I want to only populate the attendance of the students from this specific district. The formula I am trying to write is this: If student's school district is "wright", copy A2 (which is P) to cell B2 (which is in another tab) So I want P to populate, not the count. Does that make sense?