In Excel If then with multiple possibilities

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.

This is usually done with tables. Look in Excel help at the VLookup
worksheet function.

--
Regards,
Tom Ogilvy

"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.

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.

Sorry

To explain that further you set up the table of postage rates elsewhere on
the sheet or on another sheet

--
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.