AnsweredAssumed Answered

Shipping calculations in Filemaker Pro 8

Question asked by MurielleRoy on Nov 17, 2011
Latest reply on Nov 17, 2011 by philmodjunk

Title

Shipping calculations in Filemaker Pro 8

Post

 We need help updating our invoice shipping calculation before January 2012.
This is what we have now:
If(AIR & Invoice ID=Invoice ID;If(Subtotal = 99.99;9.95;If(Subtotal = 100 and Subtotal = 499.99;(.0995 * Subtotal);If(Subtotal = 500;(.05 * Subtotal);"")));0)


Need to be:
$7.95 shipping cost for up to $19.99,
then $10.95 from $20.00 up to $99.99
9.95% from $100.00 up to $499.99
5% $500.00 and up

thank you

Outcomes