IF Formula

[umarraza]

Hi, I have a table below of issues that have been resolved and not resolved. I want to create a criteria to allocate points if it falls within a certain percentile.
% Resolved	% Unresolved	Points
27%	0%

<tbody>
</tbody>

The point scoring system is as follows:

% Resolved	Points
Up to 10	0
Up to 20	1
Up to 40	2
Up to 60	3
Up to 80	4
Up to 100	5
What formula would i need to put in the points section for it receive 2 points?

<tbody>
</tbody>

Thanks in advance.

 

[bosco_yip]

Column C (Points) , C2 formula copy down :

=LOOKUP(A2,{0;0.11;0.21;0.41;0.61;0.81},{0;1;2;3;4;5})

Regards