How do I make specific calculations based on numerous criteria?

**Harmse** · 04-25-2013, 06:09 AM

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,

**acerrhod** · 04-25-2013, 06:15 AM

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

**Jacc** · 04-25-2013, 06:24 AM

Here is another option using VLOOKUP.

**Harmse** · 04-25-2013, 06:29 AM

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?