View Single Post
  #1   Report Post  
jennifer
 
Posts: n/a
Default Assigning ranges for values (e.g., $1,005 the range is ">$1K to 5K

Can you help please?

I am looking to assign ranges for values in a column, I want to assign a
range that based on that number in the adjoining column as follows.

100,001K plus
10,001 to 100K
5,001 to 10K
1,001 to 5K
0 to 1K