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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freight formula
It looks like you might be over thinking it with the not-equals (<).
Try this: =IF(A2<15.01,7,IF(A2<25.01,8,IF(A2<35.01,9,IF(A2<4 5.01,10,0)))) This checks to see if it's less than the bottom of the second tier. If so, it's the lowest. If not, it checks against the next and so on until it's out of options. At that point it's reached it's highest mark, no charge for me! I hard coded the freight charges, but you could just as easily reference another cell. Jim tanjal wrote: 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 |
Reply |
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 |