What is the formula for removing GST in Excel?

Editorial team Published on

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.

How to remove GST amount in Excel?

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.

How to remove 18% GST from total amount?

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.

What is the formula to remove GST?

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 to take GST off a total amount?

How do you remove GST?

  1. First, take the GST-inclusive price and multiply that by 3.
  2. Then, divide the result by 23 and round that number to the nearest two decimal points.
  3. Finally subtract that from the GST-inclusive price:

How to Calculate GST in Microsoft Excel | GST Calculator in Excel

44 related questions found

How do I remove 20% from a price?

How much is 20 percent off?

  1. Take the original number and divide it by 10.
  2. Double your new number.
  3. Subtract your doubled number from the original number.
  4. You have taken 20 percent off!

What is the formula for deducting 20 VAT in Excel?

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.

Is 18% GST completely removed?

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.

How to deduct 18 GST from total amount in Excel?

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.

How do I remove tax from a total in Excel?

The Excel sales tax decalculator works by using a formula that takes the following steps:

  1. Step 1: take the total price and divide it by one plus the tax rate.
  2. Step 2: multiply the result from step one by the tax rate to get the dollars of tax.
  3. Step 3: subtract the dollars of tax from step 2 from the total price.

How to remove 18 GST from a price?

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.

What is the Formula to take GST out of total 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.

What is the Formula for GST 18%?

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.

How to quickly calculate 20% off?

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.

What is the formula for percentage deduction in Excel?

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.

How to take 25% off in Excel?

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

How to calculate 18% tax in Excel?

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