Forum Discussion
excel formula for discount to different category
hello can please help me for formula for discount to different customers at different rates on different products i.e i have business of distribution i have 52 outltes and 10 products each product h...
Example:
I would like to deduct 5% discount, 2% cash discount from a total total in Excel plus 7.6% VAT on the net total. Can you kindly help me out how to define or program the cell format so that these deductions or surcharges are displayed correctly?
Let us assume that cell C1 in your Excel table contains the total total, in our example 100, then the following picture would result:
Total total: CHF 100.00.
less 5%: 95.00 sFr. Formula in this cell: = C1- (C1 / 100 * 5)
less 2%
(from 95 Fr.): 93.10 sFr. Formula in this cell: = C3- (C3 / 100 * 2)
plus 7.6%: 100.18 sFr. Formula in this cell: = C6 + (C6 * 7.6%)
In our example, cell C3 contains 95 francs, cell C6 contains 93.10 francs (net total).
I would like to deduct 5% discount, 2% cash discount from a total total in Excel plus 7.6% VAT on the net total. Can you kindly help me out how to define or program the cell format so that these deductions or surcharges are displayed correctly?
Let us assume that cell C1 in your Excel table contains the total total, in our example 100, then the following picture would result:
Total total: CHF 100.00.
less 5%: 95.00 sFr. Formula in this cell: = C1- (C1 / 100 * 5)
less 2%
(from 95 Fr.): 93.10 sFr. Formula in this cell: = C3- (C3 / 100 * 2)
plus 7.6%: 100.18 sFr. Formula in this cell: = C6 + (C6 * 7.6%)
In our example, cell C3 contains 95 francs, cell C6 contains 93.10 francs (net total).
Calculate percentages
Multiply by a percentage
Hope I was able to help you.
Nikolino
I know I don't know anything (Socrates)