Good point Martin


Gord

On Sat, 2 Feb 2008 09:21:38 +1000, "MartinW" wrote:

Hi,

It's not actually the way you stated it, but did you
mean for the split to go like this?

Sales of 23000 would be paid like follows
10000 at 8% plus 10000 at 6% plus 3000 at 4%

If that is the case take a look at John McGimpsey's site
http://www.mcgimpsey.com/excel/variablerate.html

HTH
Martin



" wrote in
message ...
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 ?