I am trying write a formula to include variable tax percents applied to
specifc ranges as in this example:

If greater than 500 but less than 1000, then X%
if greater than 1000, but less than 1500, then Y%
if greater than 1500 but less than 2000 then Z% and so on for 6 ranges