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
Bookmarks