# IF OR Help

#### ihmunro

##### Board Regular
Afternoon

I am trying to do the followign for 4 items without success.

=IF(OR(A153="8 Double Acting Hyd/Mech Drilling Jar - 411",E139,A153="6 1/2 Double Acting Hyd/Mech Drilling Jar - 428",E140,A153="8 Double Acting Drilling Intensifier - 434",E142,A153="6 1/2 Double Acting Drilling Intensifier - 478",E143),"")

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

#### GlennUK

##### Well-known Member
Please tell us what your logic is supposed to be. For all we know you may have left out things, or made mistakes in the formula, so taking that as a starting point is not a good idea.

#### texasalynn

##### Well-known Member
I'm not sure what you are trying but it looks like maybe the OR part isn't right. You can check by using the dialog box to go thru the statement. Click on the formula bar = to open the dialog box, then click on the OR in the formula bar to change the dialog box.

#### ihmunro

##### Board Regular
Update

Hi Glen

I have a field that when it is populated with one of 4 options, it will display a corresponding value associated with that option.

Does this help

Iain

#### GlennUK

##### Well-known Member

That's not what your formula does at all. And I wouldn't have guessed that logic from the formula.
Code:
``=IF(A153="8 Double Acting Hyd/Mech Drilling Jar - 411",E139,IF(A153="6 1/2 Double Acting Hyd/Mech Drilling Jar - 428",E140,IF(A153="8 Double Acting Drilling Intensifier - 434",E142,IF(A153="6 1/2 Double Acting Drilling Intensifier - 478",E143,""))))``

#### texasalynn

##### Well-known Member
That's not what your formula does at all. And I wouldn't have guessed that logic from the formula.

Phew! Me either

#### ihmunro

##### Board Regular
Many Thanks

Hi Glenn

Many Thanks for the help.

I was not sure if they needed to be separated or not.

Thanks again.

Iain

My pleasure.

Replies
1
Views
151
Replies
1
Views
72
Replies
7
Views
416
Replies
10
Views
159
Replies
0
Views
261

1,137,204
Messages
5,680,166
Members
419,887
Latest member
Vasokir

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