Respected Experts, Range Chart.xlsx

Kindly help me in creating macro for below problem.

I want to convert column values given in number to a particular range. I have shown that range chart in my excel attachment.

Example value in column -
15 convert to 1-500
318 convert to 1-500
580 convert to 500-1000
5875 convert to 5000-10000
780 convert to 500-1000

Thanks,
Harman