To remove GST from a total amount in Excel, divide the total price by ( 1 + GST Rate Percentage ) ( 1 + G S T R a t e P e r c e n t a g e ) (e.g., divide by 1.18 1 . 1 8 for 18 % 1 8 % ). The formula is: =Total_Amount / (1 + GST_Rate%). For example, if a total including 18 % 1 8 % GST is in cell A1, the formula to find the base price is =A1 / 1.18.
Removing GST with Constant Rate from the Total Amount
The price with GST includes both the price and the GST. If the GST rate is 10%, the price we have now is 110% of the original price. That is why we need to divide the price with GST in D2 cell by 110, and then multiply the result by 100 to get the price without GST.
Net price = Original cost – GST
For example, if the cost of a product after GST of 18% is Rs. 118, its original cost is 118 – [100/(100 + 18%)}], which equates to Rs. 100.
Subtracting GST:
To calculate how much GST is included in a price, just divide by 11. To calculate how much the price was before GST, just divide by 1.1.
How do you remove GST?
How much is 20 percent off?
To keep it simple, I would enter =A2/1.2 in C2 giving you the net. And then in B2 =A2-C2 to calculate the VAT.
Understanding GST Rate Reduction
Starting September 22, 2025, the GST Council reduced the number of tax slabs from four to two main rates: 5% merit rate for essential and priority items and 18% standard rate for most other goods and services. There is also a special 40% rate for luxury and sin goods.
If you need to take GST off a total price, use the formula = Price / (1 + GST rate). For example, if the total price is ₹118, you'd type = 118 / 1.18 to find the original price before GST.
The Excel sales tax decalculator works by using a formula that takes the following steps:
Then, subtract the GST percentage from 100 to determine the base price percentage. For example, if the GST rate is 18%, subtract 18 from 100, leaving 82%. Divide the MRP by 118 and multiply the result by 100 to find the base price. The difference between the MRP and the base price gives you the GST amount.
If you only have G.S.T, which is 7%, then you would calculate the price after taxes by multiplying by 1.07. So a $200 item would cost 1.07 x $200 = $214 after G.S.T. To calculate how much G.S.T. was paid on a $214 item, simply reverse the calculation by dividing by 1.07, as $214/1.07=$200.
The different slabs for GST are 5%, 12%, 18% and 28%. GST calculation can be explained by a simple illustration : If a goods or services is sold at Rs. 1,000 and the GST rate applicable is 18%, then the net price calculated will be = 1,000+ (1,000X(18/100)) = 1,000+180 = Rs. 1,180.
To determine how much she should pay, the 20% discount should be first converted to decimal (20/100=0.2) before being multiplied by the original price ($295*0.2=$59). The discount will be then deducted from the original price ($295-$59=$236), yielding the discounted price.
Tip: You can also multiply the column to subtract a percentage. To subtract 15%, add a negative sign in front of the percentage, and subtract the percentage from 1, using the formula =1-n%, where n is the percentage. So to subtract 15% use =1-15% as the formula.
The basic formula for calculating a percentage is =part/total. Say you want to reduce a particular amount by 25%, like when you're trying to apply a discount. Here, the formula will be =Price*1-Discount %.
Apply the GST Formula Use a formula like = B2 - B2 / 1.15 for a 15% tax rate to calculate the GST amount. Adjust as needed for different tax rates. (This approach works similarly for other tax rates—just replace 1.15 with 1 + (GST Rate/100). For example, if the GST rate is 18%, use 1.18 instead.)