How can I find a value, when if doesnt allow more than 13 arguments.

Question

My challenge is as follow:

In competition we have "repechage" Meaning the competitors who loose his fight against the finalist have a chance to come back to get a bronze medal.

Now, how can I find the competitors that lost against the finalist if I cant enter more than 13 ifs?

=IF(N23=B8;B10;B8;IF(N23=B12;B14;IF(N23=B14;B12;IF(N23=B16;B18;IF(N23=B18;B16;IF(N23=B20;B22;IF(N23=B22;B20);IF(N23=B24;B26;IF(N23=B26;B24;IF(N23=B28;B30;IF(N23=B30;B28))))))))))))

I hope this is clear and somebody smart can help me.

Answer 1

I'll admit I didn't read this closely, but have you considered calculating an intermediate value (or values)? You don't have to do everything in a single equation in a single cell.