Create a table of value pairs

500 x%
1000 Y%
etc

and use

=VLOOKUP(val,A1:B10,2,TRUE)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MINI MART" wrote in message
...
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