This would be better using a VLOOKUP formula on the worksheet, using the
True last parameter

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

"impression" <impression@discussions.microsoft.com> wrote in message
news:C21EA00E-4E00-496A-AA67-1F4832D513C0@microsoft.com...
>I want to set up a postage rate system. Someone puts in orders, my
> spreadsheet calculates the weight and then there is a shipping cell which
> tells them how much it is to ship it to that address. e.g. Weight equals
> 126lbs. I want an If weight is greater than 125lbs but less than 130lbs
> shipping cell equals $80. BUt this needs to be a long string which allows
> me
> to put in approximately 50 possibilities. e.g. Weight could be 150,
> 1250,
> 836 and all of these need to have corresponding and different shipping
> weights. I can write it for one possibility but I can't get multiple
> possibilities to be accepted. Thanks for your time.