Hi,

1st time user.

I have a simple calculation I want to make but in lieu of the volume that needs to be done (142 times) it's like a mountain in front of me and will take forever. I have 4 different criterias that need to be take into account with every calculation. If the rating is:
0 - 2 then = rating cell * 0
2 - 2.79 then = rating cell * 0.5
2.8 - 2.99 then = rating cell * 0.75
3 then = rating cell * 1

I hope that makes sense!

Kind regards,