stellarblue11 wrote:
I am trying to calculate points for a sales program based
on YOY % change with the following criteria:
2 - 4.99% - 2 pts
5 - 9.99% - 5 pts
10 +% - 10 pts

If A1 contains the YOY%:

=(A1=2%)*2 + (A1=5%)*3 + (A1=10%)*5