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
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