Return 1 if between 0 and 4 and 2 if between 5 and 9.

[serge]

Need help with a formula that would return 1 if the number is between 0 and 4 and 2 if the number is between 5 and 9.

1 in column C and 2 in column D.

Thank you.

Excel Workbook
	A	B	C	D	E
1			0-4	5-9
2
3	0		1
4	8			2
5	4		1
6	6			2
7	5			2
8	1		1
9	7			2
10	2		1
11
Sheet1

 

[tigeravatar]

serge,

Cell C3 formula:
=IF(AND(A3<>"",A3>=0,A3<=4),1,"")

Cell D3 formula:
=IF(AND(A3<>"",A3>=5,A3<=9),2,"")

Then copy down

Hope that helps,
~tigeravatar

 

[ganeshpoojary05]

Try the below formula

Column C: =IF(AND($A1<=4,A1>0),1,"")
Column D: =IF(AND($A1<=9,A1>4),2,"")

 

[serge]

Thanks to both of you that's what I needed.
Serge.