R
RFJ
Thanks to all who replied to my initial post (the solutions did work <G>).
However, the test data I provided was more simplistic than the real thing so
I'm having to repost
I'm wanting to establish a formula that gives me the position of a person's
salary in their range - ie bottom quarter, second, third or fourth quarter.
So, in the data below I want to be able to look up the grade (Col A), check
where the person's salary is, and report the relevant value in the first
row.
TIA again !
Rob
eg Grade = 4 salary = £45,000, would return the value Q2
Grade Min Q1 Q2 Q3 Q4
6 £90,000 £92,500 £95,000 £97,500 £100,000
5 £57,000 £60,563 £64,125 £67,688 £71,250
4 £41,290 £44,645 £48,000 £51,355 £54,710
3 £30,000 £33,000 £36,000 £39,000 £42,000
However, the test data I provided was more simplistic than the real thing so
I'm having to repost
I'm wanting to establish a formula that gives me the position of a person's
salary in their range - ie bottom quarter, second, third or fourth quarter.
So, in the data below I want to be able to look up the grade (Col A), check
where the person's salary is, and report the relevant value in the first
row.
TIA again !
Rob
eg Grade = 4 salary = £45,000, would return the value Q2
Grade Min Q1 Q2 Q3 Q4
6 £90,000 £92,500 £95,000 £97,500 £100,000
5 £57,000 £60,563 £64,125 £67,688 £71,250
4 £41,290 £44,645 £48,000 £51,355 £54,710
3 £30,000 £33,000 £36,000 £39,000 £42,000