I need to write a forumla that calculates the following:
- if the value of cell B6 is greater than 0 but less than 1,000 = 2.6
- if the value of cell B6 is greater than 1,000 but less than 2,000 = 2.4
- if the value of cell B6 is greater than 2,000 but less than 5,000 = 2.0

If you can give me help in writing this formula, it will be greatly appreciated.

Thank you