Pat,

with the amount owed in A1 try this

=SUMPRODUCT(--(A1{0;100;500;2000;10000}), (A1-{0;100;500;2000;10000}),
{0.125;-0.085;-0.015;-0.015;-0.0075})


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Pat Convey" wrote:

Hello everyone,

I would like to create a formula that would calculate a different levy
charge dependent on the amount.

The example is below and any help would be really appreciated.

In circumstances where amounts owed do not exceed £100 or $100 12.5% charge
will apply, 4% on the next £400 or $400, 2.5% on the next £1500 or $1500, 1%
on the next £8000 or $8000 and 0.25% on any additional sum.

In short different %'s will apply at different levels depending on monies
mowed.

I'm sure that there will be use of If/And but I'm not sure on the structure
of the formula.

I hope I haven't confused you all.

Many thanks in advance,

Pat Convey.