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.

	A	B	C	D
1	Work Item	Number of Days to Complete	Points
2	XYZ	21	?
3	ABC	3	?
4

<tbody>
</tbody>

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))