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

    3 replies to "How to create a formula for sales discount"

    • BenneTan

      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.

    • Chris Chia

      Hi Benne,

      Thanks so much for the help. Cheers 🙂

    • BenneTan

      you’re very welcome
      =)

Leave a Reply