V look up formula or if statement

[umarraza]

Hi,

I am trying to solve a scenario on excel but not sure what formula to use.

What I am trying to achieve is if a work item is completed within 7 days they receive 5 points, if within 14 days then 3 points and if more than 14+ days than 1 point.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Work Item
[/TD]
[TD]Number of Days to Complete
[/TD]
[TD]Points
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]XYZ
[/TD]
[TD]21
[/TD]
[TD]?
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]ABC
[/TD]
[TD]3
[/TD]
[TD]?
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What formula would I use in cell C2 and C3.

Thank you in advance.

 

[Comfy]

Here you go:

Excel 2010
	A	B	C
1	Work Item	Number of Days to Complete	Points
2	XYZ	21	1
3	ABC	3	5
4	DEF	7	5
5	GHI	8	3
6	AAA	14	3
7	BBB	15	1
Sheet1

Cell Formulas
Range	Formula
C2	=INDEX({5,3,1},MATCH(1,FREQUENCY(B2,{7,14}),0))