One more to ponder.

=LOOKUP(A1,{0,10002,20002},{0.08,0.06,0.04})*A1


Gord Dibben MS Excel MVP

On Fri, 1 Feb 2008 10:48:00 -0800,
wrote:

I need the formula to multiply by 3 diferent rates base on the following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can
anyone help ?