Microsoft Excel 2010: Help making a Formula to up Values by a repeating pattern

I have a Spreadsheet, and inside this sheet con开发者_运维技巧tains a column with numbers, I want to make a formula that will go down that Column and do basically this.. Values: 1 will be 9.50. 2 will be 9.75. 3 will be 10.00. Ect going up to Value of 100? Is that possible for a Formula? I keep playing with it but can't really seem to get it down. Any help would be appreciated.

Column A: 1
1
1
1
1
2
2
2
2
2
2
2
2
2
3
3
3
3

There is not a set amount to how many values are in there.

---

this should do it supposing that column A has these values 1, 2 ...etc that your computing will be based on

=MIN(9.25+A1*0.25;100)*COUNT(A1)

---

In A2, enter the formula

=A1 + (9.5-A1)

then in the cell just below it (A3), enter

=A2+0.25

Assuming A1 is the top left. Copy the formula in A3, select the next 399 cells and paste. Then select A2 - A364 and copy. Then select B2 -xx364 and paste. xx is the last column with data. If you want, set the height of your first column to 0 to hide it.

---

=(A1-1)*0.25+9.5 where A1 contains any number you want