How do I make specific calculations based on numerous criteria?

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,

try this
=IF(A1>2.99,A1*1,IF(A1>2.79,A1*0.75,IF(A1>1.99,A1*0.5,A1*0)))

If A1 is the rating cell

Hi,

thanks but the answer comes to more than 100%. Depending on the input in the rating cell, it should look at the criteria mentioned and then make the corresponding calculation. I am rating staff. I want to calculate costs if we give 12% increases this year. If the person is rated 2.72, then looking at the mentioned criteria, it should calculate the 12*0.5

Sounds clear as mud doesn't it?