Modify formula to replace value needed to reach 1st or 2nd place and return win by value

I have 4 values, a value of 15.00 on cell L29, a value of 14.43 in cell T29, a value of 18.00 in cell L49 and a value of 14.43 in cell T49.

I have a value of 15.00 on cell L29 (2nd highest value) and i'm using this formula on cell J15 =IF(L29=LARGE((L29,T29,L49,T49),1),LARGE((L29,T29,L49,T49),1)-LARGE((L29,T29,L49,T49),2),IF(L29=LARGE((L29,T29,L49,T49),2),LARGE((L29,T29,L49,T49),1)-L29 + 0.01)) returning 3.01, i need to modify this formula to return 18.01 wich is the value needed to be in 1st.

I have a value of 14.43 on cell T29 (3rd highest value tied wth value on cell T49)and on cell R15 i have this formula (same formula) =IF(T29=LARGE((L29,T29,L49,T49),1),LARGE((L29,T29,L49,T49),1)-LARGE((L29,T29,L49,T49),2),IF(T29=LARGE((L29,T29,L49,T49),2),LARGE((L29,T29,L49,T49),1)-T29 + 0.01)) returnig FALSE, i need to return 15.01 wich is the value needed to be in 2nd.

I have a value of 18.00 on cell L49 and on cell J35 have this formula (same formula) =IF(L49=LARGE((L29,T29,L49,T49),1),LARGE((L29,T29,L49,T49),1)-LARGE((L29,T29,L49,T49),2),IF(L49=LARGE((L29,T29,L49,T49),2),LARGE((L29,T29,L49,T49),1)-L49 + 0.01)) returning 3.00 wich is the value that is winning over the 2nd value, here is returning the desire number.

Thanks in advance for any help, i been trying for endless time to get the results needed with no success.

Hello,

Have tried to simplify the formulas, the enclosed sheet shows the new formulas.

Book1.xlsx

Hi score. I'm not sure what you mean. The formulas shown will change as the values in L29, T29, L49,T49 do.
They will show the a] value needed to be first(J15) b] value needed to be 2nd(R15) c] difference between the 2(J35)

Can you provide a sheet with an example of what you want. Just fill in 2 shhets with examples, and I'll have a look.
What formulas are showing in I15, Q15,I35,Q35? as you could just type the text out as the values in J15, R15, J35 always show the 1st, 2nd & difference.

If you can show me what you need I'm sure we can get there.

Hi millino,file attached with the results i will like to have, what i need is to modify the formula that is on J14,R14,J34,R34, These formulas make reference to the value on cells G14,O14, G34,O34 (yellow color)and does exactly what i need.
What i need is the same formula on J15,R15,J35,R35 (blue color)but to modify it to make reference to the values on cells L29,T29,L49,T49, hope this help, thanks very much!!

Hi score. I hope this is what you require.
I have referenced the cells you wanted.

2014_12_15_Score Board example millimo copy.xls

Hi millimo, thanks a lot, we are almost there, In R15 should return 15.01 because is the score needed to be replaced for L29 (to get 1st place), in J35 should return 14.44 because is the score needed to reach 2nd place, in R35 should return 14.44 because is the score needed to get 2nd place, IN R35 should return 14.44 because is the value needed to be in 2nd place, let see if this do it., thanks.

This should do it score
2014_12_15_Score Board example millimo copy.xls

Cheers millimo, seems to work, thank you very much!!!

No problem. Please mark the thread as solved if you're happy with it.