FAO Mike H - Formula Answer provided

  • Thread starter Thread starter Pat Convey
  • Start date Start date
P

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.
 
Hello Biff,

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

How do you guy's know this stuff??

Cheers,

Pat Convey.
 
You're welcome!
How do you guy's know this stuff??
Click to expand...

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