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.

In Excel If then with multiple possibilities
 

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

--
Regards,
Tom Ogilvy

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

In Excel If then with multiple possibilities
 

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

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

In Excel If then with multiple possibilities
 

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
HIS

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