Charged amount upto $50 @ 10%

Between $50 & $200 @ 5%

Between $200 & $1000 @ 2%

Over $1000 @ 1%

Example: If i charged an amount for $500 I would like a formula that calculates the first $50 @ 10%

the next $150 @ 5%

the last $300 @ 2%

I guess i'll need a formula that calculates 3 different rates for 1 value.

Being a newbie, any help would be greatfull.

Thanks Chris Davison for solving my previous problem, vlookup worked great.