Learn how to calculate the price excluding GST in Excel with simple formulas and practical examples. Find the original taxable value from GST-inclusive prices using different GST rates, including 5%, 12%, 18%, and 28%.
How to Calculate Price Excluding GST in Excel (Formula & Examples)
When you purchase a product or provide a service, the price you see on an invoice may already include Goods and Services Tax (GST). But what if you want to find the original price before GST was added?
For example, suppose a product costs ₹1,180, including 18% GST. How much is the actual product price, and how much of that amount is tax?
Calculating this manually is easy for one or two transactions, but it becomes time-consuming when you have multiple products or invoices to process. Microsoft Excel makes the job much easier with a simple formula.
In this guide, you will learn how to calculate the price excluding GST in Excel using practical examples, step-by-step formulas, and an easy-to-understand table.
What Does Price Excluding GST Mean?
Price excluding GST refers to the original price of a product or service before adding Goods and Services Tax.
It is also known as the base price, taxable value, or pre-tax amount.
For example, if a product costs ₹1,180 after adding 18% GST, the amount is divided into two parts:
Original product price: ₹1,000
GST amount: ₹180
Final price including GST: ₹1,180
This means the price excluding GST is ₹1,000.
Understanding this calculation is useful for business owners, shopkeepers, accountants, freelancers, and anyone who prepares GST invoices.
Formula to Calculate Price Excluding GST in Excel
To find the original price when the total amount already includes GST, you need to divide the GST-inclusive price by 1 plus the GST rate.
Basic Formula:
Price Excluding GST = Price Including GST / (1 + GST Rate)
For example, if the total price is ₹1,180 and the GST rate is 18%:
=1180/(1+18%)
The result is ₹1,000.
This formula works for different GST rates, including 5%, 12%, 18%, and 28%.
How to Calculate Price Excluding GST in Excel
Let's understand the calculation with a practical Excel example.
Suppose you sell a product for ₹2,360, including 18% GST. You want to calculate its original price before tax.
Follow these steps:
Step 1: Enter the Product Details
Open Microsoft Excel and create the following columns:
| Cell | Description | Value |
|---|---|---|
| A2 | Product Name | Laptop |
| B2 | Price Including GST | 2360 |
| C2 | GST Rate | 18% |
| D2 | Price Excluding GST | ? |
Step 2: Enter the Excel Formula
Click cell D2 and enter this formula:
=B2/(1+C2)
Step 3: Press Enter
Excel will automatically calculate the original price before GST.
The result will be:
Price including GST: ₹2,360
GST rate: 18%
Price excluding GST: ₹2,000
That's it! You have successfully calculated the price excluding GST in Excel.
Excel Formula to Calculate Price Excluding GST for Different Rates
If you regularly work with different GST rates, you can use the same formula for every transaction.
Here is an example showing how the formula works with different prices and tax rates.
| Product | Price Including GST | GST Rate | Price Excluding GST |
|---|---|---|---|
| Notebook | ₹105 | 5% | ₹100 |
| Shoes | ₹1,120 | 12% | ₹1,000 |
| Mobile | ₹11,800 | 18% | ₹10,000 |
| Furniture | ₹12,800 | 28% | ₹10,000 |
| Headphones | ₹2,360 | 18% | ₹2,000 |
If your Excel sheet uses the following columns:
Column B: Price Including GST
Column C: GST Rate
Column D: Price Excluding GST
Enter this formula in cell D2:
=B2/(1+C2)
Then drag the formula down to calculate the remaining product prices automatically.
Tip: Format the GST Rate column as Percentage. For example, enter 18% instead of 18. Otherwise, Excel may calculate the result incorrectly.
How to Calculate GST Amount Separately in Excel
Sometimes, you may need both the original product price and the GST amount for your accounting records.
You can calculate these values using separate Excel formulas.
Suppose:
B2 = Price Including GST
C2 = GST Rate
D2 = Price Excluding GST
E2 = GST Amount
Formula to Calculate Price Excluding GST:
=B2/(1+C2)
Formula to Calculate GST Amount:
=B2-D2
For example, if the final price is ₹5,900 and the GST rate is 18%:
| Description | Amount |
|---|---|
| Price Including GST | ₹5,900 |
| GST Rate | 18% |
| Price Excluding GST | ₹5,000 |
| GST Amount | ₹900 |
This method is particularly useful when preparing sales reports, purchase records, and GST calculations.
How to Calculate Price Excluding GST Using ROUND in Excel
Excel may sometimes display several decimal places in the calculated amount. If you want to display the result with only two decimal places, use the ROUND function.
Formula:
=ROUND(B2/(1+C2),2)
For example:
If the price including GST is ₹1,499 and the GST rate is 18%, Excel will calculate the original price and round the result to two decimal places.
The ROUND function is useful when preparing invoices, financial reports, and accounting spreadsheets where consistent decimal formatting matters.
Remember that rounding should follow your accounting or invoicing requirements.
Common Mistakes to Avoid When Calculating Price Excluding GST
Although the formula is simple, a few common mistakes can lead to incorrect results.
Using the Wrong Formula
Do not simply subtract 18% from the GST-inclusive price. GST is calculated on the original taxable value, not on the final price.
For example, subtracting 18% from ₹1,180 gives ₹967.60, which is incorrect. The correct calculation is ₹1,180 / 1.18 = ₹1,000.
Entering GST as a Whole Number
If you enter 18 instead of 18% in a percentage-formatted calculation, the result will be incorrect.
Use 18% or 0.18 in your Excel formula.
Forgetting to Check the GST Rate
Different products and services may have different applicable GST rates. Always verify the correct rate before calculating the taxable value.
Ignoring Decimal Places
Some calculations produce decimal values. Apply suitable number formatting or the ROUND function when required.
Frequently Asked Questions (FAQs)
1. What is the Excel formula to calculate price excluding GST?
Use =B2/(1+C2), where B2 contains the GST-inclusive price and C2 contains the GST rate.
2. How do I remove 18% GST from a price in Excel?
Divide the GST-inclusive amount by 1.18. For example, =1180/1.18 gives ₹1,000.
3. Can I calculate the price excluding 5%, 12%, 18%, and 28% GST?
Yes. Use the same formula for all GST rates: =B2/(1+C2).
4. How do I calculate GST separately from the total price?
First calculate the original price using =B2/(1+C2). Then subtract it from the total using =B2-D2.
5. How do I calculate the price excluding GST for multiple products?
Enter the GST-inclusive prices and GST rates in separate columns. Apply the formula in the first row and drag it down to calculate all remaining products.
Final Words
Calculating the price excluding GST in Excel is simple once you understand the correct formula. Instead of manually calculating the taxable value for every product, you can use =B2/(1+C2) to get accurate results automatically.
Whether you manage a small shop, prepare business invoices, maintain purchase records, or handle accounting work, this Excel formula can save time and reduce calculation errors.
For better record-keeping, maintain separate columns for the GST-inclusive price, GST rate, taxable value, and GST amount. This will make your financial reports easier to understand and manage.

COMMENTS