FAO Mike H - Formula Answer provided

[Pat Convey]

Hello Mike,

Apologies for the delay in responding to your answer you gave below

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

If you remember I asked how I could calculate different Levy's.

Could I ask a final question Mike in relation to the % used in your reply.

Your use of decimal % confused me. Are the following figures in your
formula percentages? {0.125;-0.085;-0.015;-0.015;-0.0075}).
If so, They don't appear to be % in decimal format. The first is 12.5%
(0.125) but the others don't appear to be the %'s I wish to use (4%, 2.5%, 1%
and 0.25%). However having tested the formula manually the % you provided
are correct (How do you know this stuff??)

Any way, if i chose to change the %, do I need to write them down
differently than I would if doing so in decimal?

This is so long winded and I apologise and hope I haven't confused you.

Many thanks again Mike for all your assistance with this excellent solution
to my problem.

Pat Convey.

 

[T. Valko]

The technique is described here:

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

 

[Pat Convey]

Hello Biff,

Many thanks for this. The link is very useful indeed.

How do you guy's know this stuff??

Cheers,

Pat Convey.

 

[T. Valko]

You're welcome!

How do you guy's know this stuff??

By learning from others like J.E. McGimpsey, years of experience and lots of
trial and error experimentation!