I am trying to create a work sheet that can do the following;


C29 is $245,000.00 Purchas price.

A 32 0- $5,000 take B32 25 % C32 $
1,250.
A33 $5001. to $50,000 take B33 10% C33 $ 5,000
A 34 $50,001 to 1,000,000. Take B34 5 % C34 $ 9,500
Total
C 35 15,750.00
..


Each time I take a % i I need to deduct the Maxium range amount from the
245,000.00.
Purchase Price until there is nothing to deduct.
Example

$ 245,000.00
-5,000.00 Max B32 25% C32 $1,200 (need
Formula)
-50,000.00 Max B33 10% C33 $5,000 (need
Formula
-190,000.00 MAX (that is left ) B34 5% C34 $9,500(need Formula

Does anyone know how to write this formula. I have been working on this for
hours I know I am missing a step.

I need a formula for C32_ C35
I am not sure if I need another cell to calculate the deducations.from the
Purchas price.

Thank you