How to create a formula for sales discount

November 7th, 2013 by Chris Chia Chris Chia

SUB TOTAL: 3,897.25
Less 15% bulk discount: 584.59
GST 7% : 231.88
AMOUNT PAYABLE : $3,544.54

3 Responses to “How to create a formula for sales discount”

  1. BenneTan BenneTan Says:

    hi Chris. you mean the bulk discount? say if Sub Total in B1, then:

    if you need it rounded to 2 decimal places:

    to roundup or rounddown, change ROUND to ROUNDUP or ROUNDDOWN.

  2. Chris Chia Says:

    Hi Benne,

    Thanks so much for the help. Cheers 🙂

  3. BenneTan BenneTan Says:

    you’re very welcome

Leave a Reply

You must be logged in to post a comment.