IF OR Help

[ihmunro]

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

 

[GlennUK]

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]

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]

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]

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

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

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

Phew! Me either

 

[ihmunro]

Many Thanks

Hi Glenn

Many Thanks for the help.

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

Thanks again.

Iain

 

[GlennUK]

My pleasure.