Nesting IF OR statements

**cara13xxi** · 04-22-2013, 05:56 PM

Here is the formula that I tried to use:
IF((OR(LARGE(EF5:EF95,2)=EE184,LARGE(EF5:EF95,2)=EE188,LARGE(EF5:EF95,2)=EE189)),LARGE(EF5:EF95,3),(IF((OR(LARGE(EF5:EF95,3)=EE184,LARGE(EF5:EF95,3)=EE188,LARGE(EF5:EF95,3)=EE189),LARGE(EF5:EF95,4),LARGE(EF5:EF95,2)))

It didn't work....

What I am trying to say is:
IF EE185 (the second highest number in range EF5:EF95) is the same as EE184, EE188, or EE189 then EE185 needs to be the third highest number in range EF5:EF95.
IF EE185 is the same as EE184, EE188 or EE189 then EE185 needs to be the fourth highest number in range EF5:EF95

Any help?

Thank you!

**Special-K** · 04-22-2013, 06:12 PM

IF EE185 (the second highest number in range EF5:EF95) is the same as EE184, EE188, or EE189 then EE185 needs to be the third highest number in range EF5:EF95.
IF EE185 is the same as EE184, EE188 or EE189 then EE185 needs to be the fourth highest number in range EF5:EF95

Is this a typo, first you say you want it to be the THIRD highest, then you say you want it to be the FOURTH highest.
It cant be both, you need to specify clearly what you want.
Further, I dont even see EE185 mentioned in your original formula.
Please elaborate.

**FDibbins** · 04-22-2013, 11:17 PM

If a certain cell contains the 2nd highest value in a range, without changing anything, how would you want it to become the 3rd...or 4th...value in that same range?

**cara13xxi** · 04-23-2013, 04:34 AM

Maybe if I explain the entire issue it will help:
I need to place players in order of highest points earned. Range EF5:EF95 being the list of points earned.
1st place in bracket A (EE184)
1st place in bracket B (EE188)
1st place in bracket C (EE189)
Wildcard (EE185)

EE185 is where I was trying to use the afore mentioned formula. The wildcard is the next highest points in all brackets combined once the 1st place players have been placed.

So EE185 needs to be the next highest points in range EF5:EF95 but cannont be the same as the ones listed in cells EE184, EE188 or EE189.