Hello! I am trying to find out if there is a function in Excel which allows
you to do the following:

I have a list of approximately 50 numbers. I need to fit these numbers into
a percentile range of 2% to 4% (to make it more understandable, I have a list
of "scores" for employees in an office, and need to fit them into a range of
2%-4% to figure out their annual salary increase). Is there any way to make
Excel assign a percentage to each number in the range, with the lowest number
in the range equalling 2% and the highest number equalling 4% with the rest
of the numbers calculated somewhere in between?

Thanks in advance for any assistance :)

In A1 enter 2%
In A2 enter:
=A1+0.000408163265306121
and copy down to see in A1 thru A50:

2.00%
2.04%
2.08%
2.12%
2.16%
2.20%
2.24%
2.29%
2.33%
2.37%
2.41%
2.45%
2.49%
2.53%
2.57%
2.61%
2.65%
2.69%
2.73%
2.78%
2.82%
2.86%
2.90%
2.94%
2.98%
3.02%
3.06%
3.10%
3.14%
3.18%
3.22%
3.27%
3.31%
3.35%
3.39%
3.43%
3.47%
3.51%
3.55%
3.59%
3.63%
3.67%
3.71%
3.76%
3.80%
3.84%
3.88%
3.92%
3.96%
4.00%


--
Gary''s Student - gsnu200789


"geisha666" wrote:

Hello! I am trying to find out if there is a function in Excel which allows
you to do the following:

I have a list of approximately 50 numbers. I need to fit these numbers into
a percentile range of 2% to 4% (to make it more understandable, I have a list
of "scores" for employees in an office, and need to fit them into a range of
2%-4% to figure out their annual salary increase). Is there any way to make
Excel assign a percentage to each number in the range, with the lowest number
in the range equalling 2% and the highest number equalling 4% with the rest
of the numbers calculated somewhere in between?

Thanks in advance for any assistance :)