I wrote previously:
If A1 contains the YOY%:
=(A1=2%)*2 + (A1=5%)*3 + (A1=10%)*5

stellarblue11 wrote:
Will this also return the the desired point total for all the
possible percentage totals between the 2% and 4.99%,
for example?

Yes. The formula will result in 0 if A1 is less than 2%, 2 if A1
is 2% or more but less than 5%, 5 if A1 is 5% or more but less
than 10%, and 10 if A1 is 10% or more. You can verify this
yourself by putting that formula into a cell, then putting various
values into A1 to be sure that it behaves as you want it to.

To understand the formula, note that "(A1=2%)" is 0 when
A1 is less than 2%, and 1 when A1 is 2% or more. Likewise,
"(A1=5%)" is 0 when A1 is less than 5%, and 1 when A1 is
5% or more. Thus, if A1 is between 2-5%, the formula is
effectively 1*2 + 0*3 + 0*5, resulting in 2. If A1 is between
5-10%, the formula is effectively 1*2 + 1*3 + 0*5, resulting in
5. If A1 is 10% or more, the formula is effectively 1*2 + 1*3 + 1*5,
resulting in 10.