Check this out..

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