Hi all,

Basically I have a number (in this case $345,612.19) and it has percentages applied depending on the amount. In this case if it hits--which it does--the $100000-$249999 range, 3% is applied to $249999 (equaling $7,499.97) and then the remaining amount hits our next tier ($250000-$499999) where 4% is applied, equaling $3,824.53 and totaling to $11,324.50.

What I want is a cell encapsulating this formula that looks at the $345k and sums the percentages together for the ranges and coming out to the $11k amount. Greatly appreciate any help!