IF Formula

[umarraza]

[TABLE="width: 644"]
<tbody>[TR]
[TD]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. [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]% Resolved[/TD]
[TD]% Unresolved [/TD]
[TD]Points
[/TD]
[/TR]
[TR]
[TD]27%[/TD]
[TD]0%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
The point scoring system is as follows:
[TABLE="width: 133"]
<tbody>[TR]
[TD]%
Resolved[/TD]
[TD]Points[/TD]
[/TR]
[TR]
[TD]Up to 10[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Up to 20[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Up to 40[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Up to 60[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Up to 80[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Up to 100[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]What formula would i need to put in the points section for it receive 2 points?[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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