Formulas based on cell content

Taz1pop

New Member
Joined
Mar 5, 2014
Messages
43
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
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

bbott

Well-known Member
Joined
Feb 5, 2010
Messages
2,350
Try:

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

Taz1pop

New Member
Joined
Mar 5, 2014
Messages
43
Fantastic that works amazingly thank you so much its really appreciated
 

Watch MrExcel Video

Forum statistics

Threads
1,109,550
Messages
5,529,472
Members
409,884
Latest member
Msinmath
Top