=INT(A1/100)+1
and fill down??

"ITilerate" wrote in message
...
I am having a problem writing an IF function and was wondering if there is
a
easy way to accoplish my task as follows: a range of 20 different values
in a
column and I want to assign a different value in the column next to those
values based on the range in the first column ie: if value in rows 1 to 20
of
column a is 100 to 2000 respectfully and the values I want to show in the
next column are 1 to 20 ?? This is an example of what I am trying to do
if(a1<=100,1,if(a1100<=200,2,if(a1=200<300,3))) but it doesn't return
the
answer I look for when the value is between the whole numbers as in 1.2 or
1.5 as an example......
--
ITilerate