Hi
this technique is described at http://www.mcgimpsey.com/excel/variablerate1.html