I am looking to apply different rates to different balances within a running
total. For example, let's say I want to pay incentives at a rate of .5 for
the first $10, from $10.01 to $49.99 to receive a rate of .55 and anything
above $50 to receive .6. The total for the sales is $100. So, the
calculation would be ($10*.5)+(39.99*.55)+($50*.6). How would I do this in
Excel so that as entries were made, the incentives would be automatically
calculated based on the cumulative total?