Multiple 4 values based on small, mid and large

[hayfish78]

Hello

Looking for some assistance, I have 4 values that i need to multiple by different values, working from smallest to largest gets 25,20,15,10%. The formula for 3 was easy enough as i can use the small, mid and large but the introduction of a 4 value has lost me, Did think you could use rank

 

[Fluff]

Is this what you mean

+Fluff 1.xlsm
	M	N
1
2	1	25
3	6	90
4	10	100
5	4	80
Lists

Cell Formulas
Range	Formula
N2:N5	N2	=M2*(5+RANK.EQ(M2,$M$2:$M$5)*5)