Percentage Weightings

[28creation]

Hi all,

I'm trying to get cell P11 to gauge a percentage from a figure typed into cell O11. O11 = a percentage, to 2 decimal points.

There are five ranges that O11 will fall into: <35%, 35%-45%, 45%-55%, 55%-65%, 65%+

There are weightings attached to these ranges: 1.5%, 3%, 4.5%, 6%, 7.5%, which will appear in P11.

So, if, for example, I type 63% into cell O11, 6% will appear in P11.

Or, if I type 37.6% into O11, 3% will appear in P11.

How can I achieve this?

Any help would be much appreciated.

Thanks in advance.

 

[sheetspread]

The lookup function will do this:

Excel 2010
	L	M	N	O	P
2	0	0.015		0.63	0.06
3	0.35	0.03
4	0.45	0.045
5	0.55	0.06
6	0.65	0.075
Sheet3

Cell Formulas
Range	Formula
P2	=LOOKUP(O2,$L$2:$L$6,$M$2:$M$6)

 

[28creation]

Thank you so much, this is brilliant, really taught me a lot with this. Thanks!!