If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. . |
#4
|
|||
|
|||
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. . |
Thread Tools | |
Display Modes | |
|
|