Combine 2 IF OR statements

[Wheelie686]

I'm not sure if this is possible of if it's just that I can't seem to wrap my brain around what is wrong with the way I'm trying to write a formula.
1. =IF(OR(F2=D2,F2=E2),"APPLE"," ") - works fine
2. =IF(OR(G2=D2,G2=E2),"ORANGE","") - works fine

Is it possible to combine the two? Right now Column H has formula 1 and Column I has formula 2 but ideally if I could just put a formula in Column H that would give me results of either 1 or 2, that would be great.

- Wheelie686

[BadlySpelledBuoy]

Please Login or Register  to view this content.

BSB

[Wheelie686]

Thanks for the quick reply BadlySpelledBuoy. I wrote a little too quickly myself. I actually have 3 formulas across 3 columns. The 3rd basically tells me if I both results are true.
1. =IF(OR(F2=D2,F2=E2),"APPLE"," ") - works fine
2. =IF(OR(G2=D2,G2=E2),"ORANGE","") - works fine
3. =IF(AND(OR(F2=D2,E2),G2=D2,E2),"Y","") - works fine

[BadlySpelledBuoy]

If you want to combine all three then this would work. Note formula 3 is the first one as you need that to fire before the other two.

Please Login or Register  to view this content.

Without the context of your workbook I'm not really sure what you're trying to do with formula 3.

BSB

[Wheelie686]

Does this help explain what I'm trying to accomplish? I explained columns H,I,J but in reality, I want to combine them all into what would be column K

[BadlySpelledBuoy]

Does this do what you need?

Please Login or Register  to view this content.

BSB

[Wheelie686]

No the "Both" argument is definitely resulting in "Fast" no matter what.
You also referenced H2 but column H shouldn't be referenced. Column H won't really exist because I'm trying to eliminate/combine H,I,J. When I get that to work, it'll actually replace H and nothing else will exist after H.

[mehmetcik]

Formula for K2

Please Login or Register  to view this content.

[Wheelie686]

That did the trick! Thanks!