Bob,

Instead of......... {1000,950,900,850}), can I reference a cell on the same
sheet??

"Bob Phillips" wrote:

=num_units*LOOKUP(A1,{0,101,151,201},{1000,950,900 ,850})

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jamie" wrote in message
...
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