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

 

[Joe4]

If you have a set-up like this:

Use this formula in cell E2 to get the result:

=(A2-B2)/(D2-C2)

and format that cell as a percent.

 

[Cubist]

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

Why 45%? I would expect the salary to be 142,825 or roughly 143,000 to be 45%.

 

[Joe4]

Yeah, I am not sure how exactly they got Mid Salary, as I would think that would just be the mid-point of the Min and Max values, but it is not in the example given.
The mid-point of the two in the example given is 145750, not the 146000 shown.

If they want to do something special with Mid Salary, then I think they would need to explain in detail exactly how the logic should work.
I simply took the range from Min to Max, and then look at where they are exactly in that range, which is how I have always seen this done.

 

[dsami0122]

45% was just my sample - I need the true % which Joe helped with - thank you

 

[Joe4]

You are welcome.
Glad we were able to help!

 

[Cubist]

45% was just my sample - I need the true % which Joe helped with - thank you

Joe's formula doesn't make sense when it's over the mid salary threshold.

Book1
	A	B	C	D	E	F
1	Current Salary	Min Salary	Mid Salary	Max Salary
2	150000	116500	146000	175000		116%
3	160000	116500	146000	175000		150%
4	175000	116500	146000	175000		202%
Sheet2

Cell Formulas
Range	Formula
F2:F4	F2	=(A2-B2)/(D2-C2)

 

[Joe4]

Joe's formula doesn't make sense when it's over the mid salary threshold.

Book1
	A	B	C	D	E	F
1	Current Salary	Min Salary	Mid Salary	Max Salary
2	150000	116500	146000	175000		116%
3	160000	116500	146000	175000		150%
4	175000	116500	146000	175000		202%
Sheet2

Cell Formulas
Range	Formula
F2:F4	F2	=(A2-B2)/(D2-C2)

Shoot!

I had a typo in my formula. It should be:

=(A2-B2)/(D2-B2)

 

[Cubist]

Shoot!

I had a typo in my formula. It should be:

=(A2-B2)/(D2-B2)

With that the result for 130,000 is 23% - far from what the OP is expecting but makes more sense. So not sure what s/he's trying to accomplish.

 

[Joe4]

With that the result for 130,000 is 23% - far from what the OP is expecting but makes more sense. So not sure what s/he's trying to accomplish.

Yeah, that is what threw me originally; that my formula, wrong as it was, was pretty close the to the value they used as the example.
However, it sounds like maybe they were just tossing numbers out there that might not really reflect what was shown in the example.