calculate %

[wackyjack]

Hi
I need a formula to calculate different percentages for different values as below
if figure is 275 it would be 275 * 2%
but if figure is 320 it would be 300 * 2% (=6) plus 20 * 1% (=0.2) = 6.2
200-300 * 2%
from 300-350 add 1%
from 350-400 1%
500 and over *4%

Thanks

 

[joeu2004]

200-300 * 2%
from 300-350 add 1%
from 350-400 1%
500 and over *4%

Your table is unclear and inconsistent. Let's structure it like a (US) tax table. Maybe:

  0-200 0%
200-300 2% for the amount over 200
300-350 3% for the amount over 300
350-400 4%(?) for the amount over 350
400+    5%(?) for the amount over 500

Note that I made some corrections(?).

The last range should start where the second to last range ends. You wrote 350-400 and 500+; there is a gap. It should be either 350-400 and 400+, or 350-500 and 500+. Which one?

And the percentages for the last two ranges are unclear. You wrote 1% and *4%. But for 300-350 range, your wrote "add 1%". So for the 350-400 range, should that also be "add 1%", as I interpreted it? If not, what?

But that would be 4% for the 350-400 range, which seems to be the percentage for the 400+ range. So I assumed that you want +1% in all cases. That would be 5% for the 400+ range. Right? If not, what?

 

[joeu2004]

if figure is 320 it would be 300 * 2% (=6) plus 20 * 1% (=0.2) = 6.2

  0-200 0%
200-300 2% for the amount over 200
300-350 3% for the amount over 300
350-400 4%(?) for the amount over 350
400+    5%(?) for the amount over 500

That does not jibe with your example. Personally, I find your example a little incredulous, and I wonder if you misunderstood the calculations.

But if I did, please ignore my previous response.