General How to create a formula for sales discountNovember 7, 20133Comments 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 November 8, 2013 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. Log in to Reply Chris Chia November 8, 2013 Hi Benne, Thanks so much for the help. Cheers 🙂 Log in to Reply BenneTan November 8, 2013 you’re very welcome =) Log in to Reply Leave a Reply Cancel ReplyYou must be logged in to post a comment.