Re: Shipping Formula %

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47487
interpreted = N
texte = on 2/5/03 6:03 PM, Sales at sales@superiorshelving.com so noted...> So how would you write a formula using a floating discount schedule > like this? > > Example: > if subTotal is between $0.00 and $499.99, then shipCost = subTotal * > 20%, > if not then if subTotal is between $500 and $999.99, then shipCost = > subTotal * 18%, > if not then if subTotal is between $1000 and $1499.99, then shipCost = > subTotal * 16%, > otherwise shipCost = subTotal * 12%shipCost [math show=f]theShipCost=[subTotal]*.12[/math] [showif [subTotal ]<1500] [math show=f]theShipCost=[subTotal]*.16[/math] [/showif] [showif [subTotal ]<1000] [math show=f]theShipCost=[subTotal]*.18[/math] [/showif] [showif [subTotal ]<500] [math show=f]theShipCost=[subTotal]*.20[/math] [/showif] [theShipCost]Code on one line and conversion to ::shudder:: XML syntax necessary. : ) Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Shipping Formula % (Marko Bernyk 2003)
  2. Re: Shipping Formula % (Rob Marquardt 2003)
  3. Re: Shipping Formula % (Donovan Brooke 2003)
  4. Re: Shipping Formula % (Sales 2003)
  5. Re: Shipping Formula % (Marko Bernyk 2003)
  6. Shipping Formula % (Sales 2003)
on 2/5/03 6:03 PM, Sales at sales@superiorshelving.com so noted...> So how would you write a formula using a floating discount schedule > like this? > > Example: > if subTotal is between $0.00 and $499.99, then shipCost = subTotal * > 20%, > if not then if subTotal is between $500 and $999.99, then shipCost = > subTotal * 18%, > if not then if subTotal is between $1000 and $1499.99, then shipCost = > subTotal * 16%, > otherwise shipCost = subTotal * 12%shipCost [math show=f]theShipCost=[subTotal]*.12[/math] [showif [subTotal ]<1500] [math show=f]theShipCost=[subTotal]*.16[/math] [/showif] [showif [subTotal ]<1000] [math show=f]theShipCost=[subTotal]*.18[/math] [/showif] [showif [subTotal ]<500] [math show=f]theShipCost=[subTotal]*.20[/math] [/showif] [theShipCost]Code on one line and conversion to ::shudder:: XML syntax necessary. : ) Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Rob Marquardt

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

More on the email templates (1997) Country & Ship-to address & other fields ? (1997) autosensing lanague selection (1997) Forumulas.db & Variables (2002) html being uncooperative (2000) 2 easy questions re: [showif] and [sendmail] (1997) Security Hole - NetCloak Update (1998) notification solutions (1997) Shipcost formula (2004) FIXED: Showing Results Alphabetically in Columns (top tobottom) (2002) New Command prefs ... (1997) Re:Part 2 - [showif] if variable exists (1998) New Guestbook Source (1997) [founditems][replacefounditems] (2003) Searching for (field1 OR field2) AND field3 (2000) Missing Cart Information (2003) show all problem (1997) Math, Multiple Equasions and Show/Hide (1998) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Secure server question (1997)