Good Morning all!

Question for the smart people. I have a table of ranges (100 - 1000, 1000 - 2,000, 2,000 - 3,000, 3,000 - 4,000, 4,000 - 5,000, 5,000 - UP) Id like to type a number in cell K5 that multiplies any number typed in K5 that falls between 100 - 1000 to subract that entered number by 45%; 1000 - 2000 to subtract that entered number by 40%; 2000 - 3000 to subtract that number by 35%; 3000 - 4000 to subtract that number by 30%; 4000 - 5000 to subtract that number by 25%; 5000 and above to subtract that number by 20%.

Hope this makes sense.