# Formulas based on cell content

#### Taz1pop

##### Board Regular
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

### Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Try:

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

Fantastic that works amazingly thank you so much its really appreciated

Fantastic that works amazingly thank you so much its really appreciated

You're welcome.

Replies
2
Views
300
Replies
6
Views
82
Replies
1
Views
218
Replies
6
Views
269
Replies
9
Views
254

1,212,046
Messages
6,105,582
Members
447,972
Latest member
carrieann

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back