I have a running total from E2:E52. I'll input small numbers but they start to add up. I have two tiers or scenarios or arguments that I'm trying to do.

Everything in the RANGE of $15,000 to $19,999.99 is multiplied by 2%.

IF it starts totalling up $20,000 or more I want it multiplied by 3%.

I figured out so far I can't do this with just one formula/cell. So whatever I have in E53 or in my Total Cell; will have to be with two different arguments or in seperate cells.

I've searched the forums with those key words but I'm realizing I have a case by case function to figure out.

If I don't make myself clear, my apologies and if there is a similar post as mine here; I'll look at it. Just let me know.

Thanks in advance.