Pattern search using awk

Hi All,

I am trying to find numbers with balance greater than 1 and less than equal 2 from the below file using awk

Input file
num ,bal
100199,1.708
100225,0
100226,0
100228,0.771166
100232,2

output file

100199,1.708
100232,2

I am using the following command for this

awk -F"," '{if (($2>1) || ($2 <=2)) print $1","$2}' filename

Please help

You used || when you should have &&

$ echo 100,2.4 | awk -F"," '{if ($2>1 && $2<2) print $1","$2}'


$ echo 100,1.4 | awk -F"," '{if ($2>1 && $2<2) print $1","$2}'
100,1.4

Thanks .... its working now ....