Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Lookup Possibilities | Excel Discussion (Misc queries) | |||
Thousands of possibilities | Excel Discussion (Misc queries) | |||
Conditional w/ three possibilities | Excel Discussion (Misc queries) | |||
Brackets [] possibilities ? | Excel Programming | |||
find the possibilities | Excel Programming |