View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
milos
 
Posts: n/a
Default Fill the values regardnig the condition

Hi, I have a table with norms:
a b

1 10 over65
2 9 65
3 8 58
4 7 50
5 6 43
6 5 36
7 4 29
8 3 22
92 14
101 7

And I have a table of results
c d
1 35 x1
2 15 x2
3 13 x3
4 23 x4
5 32 x5
6 35 x6
etc.
x1-x6 should be filled automatically with the proper category - if first
result is 35, then the category (x1) should be 5 (it's more then 29, but less
then 36). x2 should be 3, x3 - 2 etc. how can i write conditions for this.
thanx