excel formula for discount to different category

%3CLINGO-SUB%20id%3D%22lingo-sub-1842187%22%20slang%3D%22en-US%22%3Eexcel%20formula%20for%20discount%20to%20different%20category%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1842187%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%20can%20please%20help%20me%20for%20formula%20for%20discount%20to%20different%20customers%20at%20different%20rates%20on%20different%20products%20i.e%20i%20have%20business%20of%20distribution%20i%20have%2052%20outltes%20and%2010%20products%26nbsp%3B%20each%20product%20has%20differnt%20rate%20of%20discount%20to%20different%20outlets%20also%20i%20also%20attached%20a%20excel%20file%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1842187%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1842612%22%20slang%3D%22de-DE%22%3ESubject%3A%20excel%20formula%20for%20discount%20to%20different%20category%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1842612%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F853451%22%20target%3D%22_blank%22%3E%40jagdishsavvana%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EExample%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI%20would%20like%20to%20deduct%205%25%20discount%2C%202%25%20cash%20discount%20from%20a%20total%20total%20in%20Excel%20plus%207.6%25%20VAT%20on%20the%20net%20total.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3ECan%20you%20kindly%20help%20me%20out%20how%20to%20define%20or%20program%20the%20cell%20format%20so%20that%20these%20deductions%20or%20surcharges%20are%20displayed%20correctly%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3ELet%20us%20assume%20that%20cell%20C1%20in%20your%20Excel%20table%20contains%20the%20total%2C%20in%20our%20example%20100%2C%20then%20the%20following%20picture%20would%20result%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3ETotal%20total%3A%20CHF%20100.00.%3C%2FSPAN%3E%3CBR%20%2F%3E%20%3CSPAN%3Eless%205%25%3A%2095.00%20sFr.%3C%2FSPAN%3E%20%3CSPAN%3EFormula%20in%20this%20cell%3A%20%3D%20C1-%20(C1%20%2F%20100%20*%205)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eless%202%25%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E(from%2095%20Fr.)%3A%2093.10%20sFr.%3C%2FSPAN%3E%20%3CSPAN%3EFormula%20in%20this%20cell%3A%20%3D%20C3-%20(C3%20%2F%20100%20*%202)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Eplus%207.6%25%3A%20100.18%20sFr.%3C%2FSPAN%3E%20%3CSPAN%3EFormula%20in%20this%20cell%3A%20%3D%20C6%20%2B%20(C6%20*%207.6%25)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EIn%20our%20example%2C%20cell%20C3%20contains%2095%20francs%2C%20cell%20C6%20contains%2093.10%20francs%20(net%20total).%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CP%3E%3CFONT%20size%3D%224%22%3ECalculate%20percentages%3C%2FFONT%3E%3C%2FP%3E%3C%2FDIV%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcalculate-percentages-6b5506e9-125a-4aba-a638-d6b40e603981%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcalculate-percentages-6b5506e9-125a-4aba-a638-d6b40e603981%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%224%22%3EMultiply%20by%20a%20percentage%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fmultiply-by-a-percentage-b7485923-00c1-4d2c-b567-d74d568c4e8f%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fmultiply-by-a-percentage-b7485923-00c1-4d2c-b567-d74d568c4e8f%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 has differnt rate of discount to different outlets also i also attached a excel file 

1 Reply

@jagdishsavvana 

 

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

Calculate percentages

https://support.microsoft.com/en-us/office/calculate-percentages-6b5506e9-125a-4aba-a638-d6b40e60398...

Multiply by a percentage

https://support.microsoft.com/en-us/office/multiply-by-a-percentage-b7485923-00c1-4d2c-b567-d74d568c...

 

Hope I was able to help you.

 

 

Nikolino

I know I don't know anything (Socrates)