Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freight formula
Hell all, please help.
I am trying to create a formula to calculate freight charges based on the dollar amount of the order. Example If the order is 0 to $15.00 freight = $7.00 if order is $15.01 to $25.00 = $8.00, if $25.01 to $35.00 = $9.00, if $35.01 to $45.00 = $10.00, if $45.01 and over it is free. below is how i have started the formula but it doesn't seem to work. =IF(N53<15.01,R56,IF(N53<15.01:25,R57,IF(N53<25. 01:35,R58))) Thank you in advance, Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |