Does anyone have a solution to this following problem.
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.
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.