View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] afranklin@gmail.com is offline
external usenet poster
 
Posts: 2
Default Tiering Macro, Should be easy?

Hi I need to write a macro that I believe is pretty easy but I'm a
little rusty on my programming. Any help would be greatly appreciated.

I have a list like this:
name1 25
name2 50
name3 70
etc

I need to go down the numbers column (column B). If the number is
between 20 and 30, I want to insert ".1" in a third column on the
right. If the number is between 30 and 100, I want to insert ".2".
else, I want to insert "5".

Thanks in advance!