View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jzamilpa3@yahoo.com is offline
external usenet poster
 
Posts: 48
Default number set input, specific number output

i have 2 columns one column can be a number between 1 and 200,
depending on the number inserted there has to be a number between 1
and 20 outputted on the left

column 1 column 2
1 1-10
2 11-20
3 21-30
4 31-40
5 41-50

and so on if a number between 1 and 10 is inputted a 1 should appear
to the right