Formula for the sum of percentages of different stages of an amoun

[Jay]

Can you please give me the formula for getting the sum of 5% of the value between and including 25,000 & 49,999 plus 6% of value between and including 50,000 & 74,999 plus 7% of value between 75,000 & 99,999 plus 8% of value over 100,000. Decimal places can be deleted. To be sure I've presented this correctly, here are examples:
Column A Column B (Formula will calculate these figures using column A entry)
15,000 0
30,000 250
60,000 1850
90,000 4800
120,000 6100

Thanks

 

[Peo Sjoblom]

You should be able to create a formula following these instructions

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


here's an example

http://tinyurl.com/36fy6

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

Can you please give me the formula for getting the sum of 5% of the value

between and including 25,000 & 49,999 plus 6% of value between and including
50,000 & 74,999 plus 7% of value between 75,000 & 99,999 plus 8% of value
over 100,000. Decimal places can be deleted. To be sure I've presented this
correctly, here are examples:

 

[Jay]

That should do it.....I'll try it.

Thanks!

 

[Jay]

=SUMPRODUCT("--(A6>{24999; 49999; 74999; 99999})", "(A6-{24999; 49999; 74999; 99999})", "(0.05; 0.01; 0.01; 0.01)")

This is the formula I created trying to follow the guidelines suggested .....Please Help!!!! What am I doing wrong?
Thanks,

 

[Jay]

Here is the formula I created

=SUMPRODUCT("--(A6>{24999; 49999; 74999; 99999})", "(A6-{24999; 49999; 74999; 99999})", "(0.05; 0.01; 0.01; 0.01)")

HELP please!!! What am I doing wrong?

Thanks

 

[Gord Dibben]

Jay

Remove all the double quote marks (")

How did they get inserted?

John's formulas do not include the quote marks.

Gord Dibben Excel MVP

 

[Peo Sjoblom]

Try




=SUMPRODUCT(--(A6>{24999;49999;74999;999999}),
(A6-{24999;49999;74999;999999}), {0.05;0.01;0.01;0.01})

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

Here is the formula I created

=SUMPRODUCT("--(A6>{24999; 49999; 74999; 99999})", "(A6-{24999; 49999;

74999; 99999})", "(0.05; 0.01; 0.01; 0.01)")

 

[Jay]

Program is inserting the quote marks ....... still problem after deleting them ..... I relized the last array had the wrong parentheses ....... fixed that & all is ok

Thanks......

 

[Jay]

I finally realized that was the problem!

Thank you very much!