How to create a formula for sales discount


November 7th, 2013 by Chris Chia Chris Chia

SUB TOTAL: 3,897.25
FREIGHT: 0.00
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:
    =B1*15%

    if you need it rounded to 2 decimal places:
    =ROUND(B1*15%,2)

    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.

s2Member®