| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to calculate shipping costs based on subtotal
why not try vlookup witht the first column being the minimum value in each category and the second column being the shipping amount The values need sorting asending 0 3 10.01 4 20.01 5 if the above is a range a1:b3 and the value you want ot look up is in c4 vlookup(c4,a1:b3) regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=539845 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate a value based on dates? | Excel Discussion (Misc queries) | |||
| How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
| How do I calculate charges based on elasped time(H:MM) & rate($)? | Excel Discussion (Misc queries) | |||
| How do I calculate sum based on 3 conditions? | Excel Worksheet Functions | |||
| How do I calculate interest and deduct late fees based on date pa. | New Users to Excel | |||
Threaded Mode
