How to Remove GST from Total Amount in Excel (With Easy Steps)

To explain the steps clearly, we’ll use a simple dataset to calculate taxes on an individual item. We have formatted cells C4, C6, and C7 as Accounting data. Also, we have applied the Percentage format in cell C5.

how to remove gst from total amount in excel


  • Go to cell C4 and insert the Total Amount in dollars.

Entering the Total Amount Including GST

  • Go to cell C5 and insert the GST rate as a percentage.

Entering GST Percentages of Total Amount

  • Double-click on cell C6 and enter this formula:

GST Amount Formula

  • Press the Enter key and it will calculate the GST Amount in dollars.

GST Amount Result

  • Double-click on cell C7 and copy in the following formula:

Original Price Formula

  • Press the Enter key to get the final result.

Original Price Result

Calculate GST for Multiple Products Using VLOOKUP in Excel

Let’s expand the dataset to show how to use variable GST rates for a group of products.

Calculate GST for Multiple Products Using VLOOKUP in Excel to Find Total Amount


  • Go to cell G5 and insert the following formula:

Entering the VLOOKUP function Referencing GST to Find Total Amount

  • Press the Enter key.

  • Drag the Fill Handle to copy the formula to all the cells below.
  • You will get the Total price of all the products which includes the GST.

Things to Remember

  • Remember to format the cells that have monetary values as Accounting.
  • Format the cells that have the GST rates as Percentages.
  • Add the $ sign in the second parameter inside the VLOOKUP function to use absolute references.

Download the Practice Workbook

You can download the practice workbook from here.

<< Go Back to GST | Formula List | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Nazmul Hossain Shovon
Nazmul Hossain Shovon

Nazmul Hossain Shovon, a BUET graduate in Naval Architecture and Marine Engineering, embarked on his career with 8 months dedicated to the Exceldemy project's triumph. Transitioning into a Software Developer role, he specialized in web add-in development. At Exceldemy, he authored about 125 blog articles and solved many visitors’ problems, refining his writing skills and delving into Excel-related topics. With a primary passion for programming and software development, Shovon continually explores new horizons, fostering professional growth in his... Read Full Bio

  1. Hi Nazmul Hossain,

    Unfortunately your deduction is not correct. This can be proven by calculating the 9% tax on $318.50, which is $28.67 rather than the $31.50 you took off.
    The correct formula would be =C5/(C5+1)*C4, which gives a total of $28.90 for tax and $321.10 for the untaxed value. 9% of $321.10 is also $28.90.

    • Reply Avatar photo
      Nazmul Hossain Shovon Nov 14, 2022 at 10:59 AM

      Hi James,
      Thanks for your correction. To add, you can also calculate the GST amount using this formula:
      GST Amount = (C4*C5)/(1+C5)
      Then we can deduct this value of cell C6 from C4 to get the original price in cell C7.

  2. GST Amount = (C4*C5)/(1+C5)
    not work

    Formula =C5/(C5+1)*C4 working

    pls Any other simplify formula

    • Reply Nafis Soumik
      Md. Nafis Soumik Jul 2, 2023 at 2:06 PM

      Hello Kumar,
      Both the formulas you mentioned work fine and generate same results. Try again. If it still does not work, please send us your Excel file at [email protected]
      And yes. There is a simpler formula to find out the original price directly without calculating the GST amount. Use this formula inside cell C7: Original price = C4/(1+C5)

      Thank you.

Leave a reply

Advanced Excel Exercises with Solutions PDF