Excel Multi Level If Than with Greater Than and Less Than needs

[dsami0122]

We have two tables that shows titles and what the range of salary is for that specific title it has MIN, MID, MAX range,

What I am trying to calculate is what the compa-ratio is for the level first then I have to calculate a multiple level If statement to pull over the Merit increase from this table

First one is if Performance Rating from First Table F Column is Equal to the Second Table A Column, And the Ration from first table column N meet the criteria of any the columns in the second table it will pull over the correct percentage.

So in the SAMPLE CASE it would pull over the below 80% and Equal to 4.5 performance rating and increase would be 4.55%

Does this make sense?

 

[Cubist]

It's a rounding issue other people have mentioned. In table 2, select the 3.5 and show more decimals. It should show you that whatever is in table is not exactly 3.50.

 

[dsami0122]

@Cubist
Sorry to bother again on this one last issue

this formula still is working right if you see line two the performance rate is 3.80 and the compa-ration is 92.77 therefor the merit increase should be 3.65% and it pulling in 3.25%

Help is appreciated

 

[Cubist]

Table 2 is using decimals e.g. 90% = 0.9. The Compat-Ratio is off by 2 decimal places.