Hello this is my first post, I have found this forum a great help.

I have an input value and I need to categorise it into one of six categories.
I am unsure how to address the range of each row.
If Input value is between zero and 160,000 then display Size 1 and so on for all six ranges.
Your assistance is greatly appreciated.

Input Minimum Value Maximum Value Response
87,343 160,000 399,999 Size 1
400,000 800,000 Size 2
800,001 2,200,000 Size 3
2,200,001 6,00,000 Size 4
6,000,001 54,999,999 Size 5
55,000,000 Size 6