Hello guys,
I'm stuck with a simple problem and couldn't find solutions online (it's hard to explain it without an example).
Say we have the following table:
<tbody>
</tbody>
Is there a formula (not vb) that would return the Rank based on an arbitrary Level? Examples:
f(2) = Rookie
f(10) = Soldier
f(99) = Soldier
f(5000) = General
I'm sorry if the solution is simple - I did a lot of googling, but couldn't find the answer.
Thank you!
I'm stuck with a simple problem and couldn't find solutions online (it's hard to explain it without an example).
Say we have the following table:
Rank | Min Level |
Rookie | 0 |
Soldier | 10 |
General | 100 |
<tbody>
</tbody>
Is there a formula (not vb) that would return the Rank based on an arbitrary Level? Examples:
f(2) = Rookie
f(10) = Soldier
f(99) = Soldier
f(5000) = General
I'm sorry if the solution is simple - I did a lot of googling, but couldn't find the answer.
Thank you!