Hello, My question is almost exactly the same as Pauline - rockstars on,
6/27/2007, it concerns price breaks, i.e $100 for orders of 1 - 100, $90 for
orders of 101 - 200 etc etc, however, I have 12 volume price breaks, and
apparently can't use more than 7 'if' commands, can anyone think of a way?


EG. 1-100 units = $1000 per unit
101 - 150 = $950 per unit
151 - 200 = $900 per unit
201 - 250 = $850 per unit

I have 12 breaks!!

Please help

Thanks
Jamie