Calculating shipping costs

[Allegheny]

My goal with this calculation is simple: shipping charges are accrued based upon the subtotal of the purchase. Unfortunately I've spent too much time working on this one to be able to see my mistake. Here are two ways I tried:

If(One Subtotal <= 40, "6", If(One Subtotal > 40 and One Subtotal <= 75, "8.50", If(One Subtotal > 75 and One Subtotal <= 100, "10.50", If(One Subtotal > 100 and One Subtotal <= 150, "13",If(One Subtotal > 150 and One Subtotal <= 200, "15",If(One Subtotal > 200 and One Subtotal <= 10000, "17", "200"))))))

Case(One Subtotal >= 40, "6", One Subtotal >= 41 >= 75, "8.5", One Subtotal >= 76 >= 100, "10.5", One Subtotal >= 101 >= 150, "13", One Subtotal >= 151 >= 200, "15", One Subtotal >= 200, "17","")

Anyone out there able to see my errors? What am I overlooking?

Allegheny

[Gerd Muller]

Try this:

code:

---

Case(One Subtotal <= 40, 6,

One Subtotal >= 41 AND One Subtotal <= 75, 8.5,

One Subtotal >= 46 AND One Subtotal <= 100, 10.5,

One Subtotal >= 101 AND One Subtotal <= 150, 13,

One Subtotal >= 151 AND One Subtotal <= 200, 15,

One Subtotal >200, 17, "")

---

Result should be set to value.

Have fun

Gerd

[Allegheny]

Thanks! I didn't realize it doesn't matter if there's a carriage return in the middle of the calculation.

Allegheny

[LiveOak]

I only leave them out when I want the customer to be in total awe of the complexity of the calculation .

-bd