IF OR Help

ihmunro

Board Regular
Joined
Oct 11, 2002
Messages
74
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
Joined
Jul 8, 2002
Messages
11,547
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
Joined
May 19, 2002
Messages
8,458
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
Joined
Oct 11, 2002
Messages
74
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
Joined
Jul 8, 2002
Messages
11,547

ADVERTISEMENT

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,""))))
 

ihmunro

Board Regular
Joined
Oct 11, 2002
Messages
74
Many Thanks

Hi Glenn

Many Thanks for the help.

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

Thanks again.

Iain
 

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top