Excel calculation for percentage discount on total price including tax Solved

Question

Hello, for invoicing, I need to insert a formula that allows me to calculate the price after applying the discount (expressed as a percentage). This discount is variable depending on the products, and that's exactly what is causing me trouble. Example: line 1: price including tax  line 2: % discount  line 3: price including tax after discount Thank you for your help

Sloubi76 · Accepted Answer

Good evening,  Proposed formula: Price including tax - (Price including tax * % discount) that is, if the data is in column A Put in A3 = A1 - (A1*A2), A2 expressed as a percentage  @ + -- We need to blanch the mushrooms!!!

Anonymous user · Answer

A1 = 1000 B1 = 10 C1 = =A3/100*B3-(A3)  -- Nothing has been invented better than stupidity to believe oneself intelligent. Best regards, Jacqus93

Rom190686 · Answer

Thank you very much, it's perfect!

marie · Answer

Hello, I'm actually bad at math so the statement is: a confectioner receives an order for caramels amounting to 120.40 euros. To keep his customer loyal, he decides to grant a 20 percent discount the question is: calculate the amount of the invoice after the discount?  HERE, THANK YOU IN ADVANCE

Sloubi76 · Answer

Good evening,  Based on the principle previously stated, initial amount - (initial amount*discount) 120.40 - (120.40*0.20) or simpler: 120.40*0.80 0.80 represents the 20% discount (100-20)  Good evening.

Excel calculation for percentage discount on total price including tax

5 answers

The black swift flies for 10 months in a row without interruption

My pc won’t charge anymore and runs super slowly

Laptop: password forgotten

My second pc monitor

My computer stays connected for very little time

Unable to open xsl and xslx files

Pixma ts printer is broken

No internet connection possible

Print a page in the right orientation under windows 11

Change a contact’s ringtone