SUB TOTAL: 3,897.25
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:

      if you need it rounded to 2 decimal places:

      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