Take a look at John McGimpsey's site, here:

http://www.mcgimpsey.com/excel/variablerate.html

Hope this helps.

Pete