Scribd
Upload
41 views2 pages

DISCOUNT

The document outlines a discount policy where a 5% discount is applied to total amounts exceeding ₹40,000. It includes a table with seller codes, names, product names, quantities, rates, total amounts, discounts, and final prices. The calculations demonstrate how the discount affects the final price for various transactions.

Uploaded by

dibyadyutimajumder1
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
41 views2 pages

DISCOUNT

The document outlines a discount policy where a 5% discount is applied to total amounts exceeding ₹40,000. It includes a table with seller codes, names, product names, quantities, rates, total amounts, discounts, and final prices. The calculations demonstrate how the discount affects the final price for various transactions.

Uploaded by

dibyadyutimajumder1
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

IF TOTAL AMOUNT EXCEEDS 40000 THEN DISCOUNT AMOUNT WILL BE 5% OF TO

CREAT THIS-

SALLER CODE
NAME
PRODUCT NAME
QUANTITY
RATE(₹)
TOTAL(₹)
101 A V 80 500 40000
102 B W 50 1100 55000
103 C X 40 750 30000
104 D Y 70 600 42000
105 E Z 20 1000 20000
WILL BE 5% OF TOTAL AMOUNT. LET'S

DISCOUNT
FINAL PRICE(₹)
2000 42000
2750 57750
0 30000
2100 44100
0 20000

[=IF(F2>=40000
,F2*5%,0)]

You might also like