Sum ranges of numbers that have hit tiered percentages

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!

Hmm, no that won't work for me because if the number was say 150k the answer comes up as zero. I haven't mentioned, but there are also other ranges above the 500k range that apply 5% and 6% which I'd have to incorporate as well, but figured if I had two of them down properly I could apply the rest. Thanks for trying though!

just wanted to say after looking at yours further it helped me out and ended up doing:

=IF(AND(A1<=249999,A1>=100000),A1*0.03,IF(AND(A1<=499999,A1>=250000),(249999*0.03)+((A1-249999)*0.04)))

thanks again!