FAO Mike H - Formula Answer provided
 

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.

FAO Mike H - Formula Answer provided
 

The technique is described he

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

--
Biff
Microsoft Excel MVP


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

FAO Mike H - Formula Answer provided
 

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" wrote:

The technique is described he

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

--
Biff
Microsoft Excel MVP


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


.

FAO Mike H - Formula Answer provided
 

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!

--
Biff
Microsoft Excel MVP


"Pat Convey" wrote in message
...
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" wrote:

The technique is described he

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

--
Biff
Microsoft Excel MVP


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


.