Formula for calculating a Percentage

[dsami0122]

I have a report with 4 columns
Current Sal

Current Salary	Min Salary	Mid Salary	Max Salary
130000.00	116500	146000	175000

Calculate where this salary is in the range by percentage - if this range this person is currently at 45% of their classification range

 

[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?

 

[Joe4]

That follow-up question, while related to the original question is very different from the original question (especially with the introduction of the new table and lookup).
As such, it would be best to post this new question to a new thread of its own. That way it shows up as a new unanswered question, and will appear on the "Unanswered threads" listing that many people use to look for new questions to answer.

 

[dsami0122]

Reposted hope someone can help