Freight formula

T

tanjal

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
 
J

jim

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<45.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
 
Top