From your post, it seems like you could build a table of your pricing tiers
and us a VLOOKUP function to return what you're looking for. See if that
works for you. Let us know if you need more help.

--
Regards,
Ron