Formulas based on cell content

[Taz1pop]

Hi all

I hope someone can help, ill try and explain the best I can,

I have at the moment 2 IF formulas, to decide which formula to use depends on the content of another cell. I have tried many different versions of an IF formula but nothing seems to work. Does anyone know of a way to do this.

Example

If A2 = "test" then I want to use this formula IF(J11="E",1,0)
If A2 = "test1" then I want to use this formula IF(J11="1.1.2",1,0)

at the moment its just 2 but may need to have 3 or 4 options please can anyone help with this, its driving me insane

Thank you in advanced

 

[bbott]

Try:

=IF(OR(AND(A2="test",J11="E"),AND(A2="test1",J11="1.1.2")),1,0)

 

[Taz1pop]

Fantastic that works amazingly thank you so much its really appreciated

 

[bbott]

Fantastic that works amazingly thank you so much its really appreciated

You're welcome.