Discount Calculation ka matlab hai kisi product ya service ki Original Price (Marked Price) par given discount percentage ke according discount amount aur Final/Selling Price calculate karna.
Simple words mein, jab kisi product par 10%, 20%, 30% ya koi other discount diya jata hai, to Excel ki help se discount amount aur customer ko pay karne wali final price calculate ki ja sakti hai.
Short Definition:
Original price par given discount percentage ke basis par discount amount aur final price calculate karna Discount Calculation kehlata hai.
| Term | Meaning |
|---|---|
| Original Price | Product ki actual/marked price |
| Discount % | Diya gaya discount percentage |
| Discount Amount | Price mein se reduce hone wali amount |
| Selling Price | Discount ke baad final price |
| Net Price | Customer ko pay karni wali amount |
=Original Price*Discount %Example:
Original Price = ₹10,000
Discount = 20%
=10000*20%Discount Amount = ₹2,000
Discount ke baad final price:
=Original Price-Discount AmountExample:
Original Price = ₹10,000
Discount Amount = ₹2,000
Final Price = ₹8,000
Discount amount calculate karke alag column banane ke bajay final price directly bhi calculate kar sakte hain:
=Original Price*(1-Discount %)Example:
=10000*(1-20%)Final Price = ₹8,000
| Product | Original Price | Discount % | Discount Amount | Final Price |
|---|---|---|---|---|
| Laptop | ₹50,000 | 10% | ₹5,000 | ₹45,000 |
| Mobile | ₹30,000 | 15% | ₹4,500 | ₹25,500 |
| Tablet | ₹20,000 | 20% | ₹4,000 | ₹16,000 |
| Printer | ₹15,000 | 10% | ₹1,500 | ₹13,500 |
Agar:
B2C2D2E2Discount Amount:
=B2*C2Final Price:
=B2-D2Business mein different products par different discount ho sakta hai.
Example:
Excel mein Discount % ko separate column mein rakhne se calculation automatically ki ja sakti hai.
Kabhi-kabhi product par two successive discounts diye jate hain.
Example:
Original Price = ₹10,000
First Discount = 10%
Second Discount = 5%
=10000*10%₹1,000
Price after first discount:
₹9,000
=9000*5%₹450
Final Price:
₹8,550
Important: 10% + 5% ko simply 15% discount maan lena correct nahi hota jab discounts successively apply kiye ja rahe hon.
Real business billing mein discount ke baad tax bhi calculate kiya ja sakta hai.
Example:
Original Price = ₹10,000
Discount = 10%
Discount:
₹1,000
Price after discount:
₹9,000
Agar GST 18% applicable ho:
=9000*18%Tax = ₹1,620
Final Amount:
=9000+1620₹10,620
Tax rules product/service aur applicable law ke according vary karte hain, isliye actual billing mein applicable tax rate use karna chahiye.
Agar Original Price aur Discount Amount diya ho, to Discount % calculate kiya ja sakta hai.
=Discount Amount/Original Price*100Example:
Original Price = ₹20,000
Discount Amount = ₹3,000
=3000/20000*100Discount = 15%
Large product data mein MAX() aur MIN() ka use karke highest aur lowest discount identify kiya ja sakta hai.
=MAX(C2:C20)=MIN(C2:C20)Average Discount:
=AVERAGE(C2:C20)Discount values ko highlight karne ke liye Conditional Formatting use ki ja sakti hai.
Example:
Isse promotional offers ko quickly identify kiya ja sakta hai.
Discount Calculation ka use:
✅ Discount amount quickly calculate hota hai
✅ Final selling price easily find hoti hai
✅ Different products ke discounts compare kiye ja sakte hain
✅ Billing calculation fast hoti hai
✅ Manual calculation errors kam hote hain
✅ Large product lists par formulas apply kiye ja sakte hain
✅ Discount reports easily prepare ki ja sakti hain
Leave a Reply