I have a totals column that I am wanting to multiply by various % amounts based on progressive totals... < 30,000 multiply by .20.... >= 30,000 x .35.. etc..

i.e.

column A column B

5000 5000 x .20
10000 10000 x .20
15000 15000 x .35 .................. total 30,000



I currently have the following formula...


=IF(AND([difference]>0([difference]<=150000),[@Difference]*0.35, IF(AND([@Difference]>150000,[@Difference]<=250000),[@Difference]*0.4, IF(AND([@Difference]>250000,[@Difference]<=350000),[@Difference]*0.45, IF([@Difference]>350000,[@Difference]*0.5,""))))

any help would be appreciated