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