How to create a formula for sales discount

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

3 thoughts on “How to create a formula for sales discount”

  1. 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.

Leave a Reply