Excel formula for gst - australia

One of the most frequent requests I receive is to explain how to calculate GST (Goods and Services Tax) using Excel formulas.

If you want to calculate GST quickly and accurately, you’re in the right place!

In this tutorial, I’ll show you how to use Excel formulas to add and remove GST, calculate the GST-inclusive total, and remove the GST amount from a total.

Skill Level: Beginner

Excel Practice Files

Calculate GST for NZ, Australia and Other Countries

I’m based in New Zealand, where the GST rate is 15%, represented as 0.15 in decimal form.

If you’re in a country with a different tax rate, adjust the formulas by substituting 15% (0.15) with your local rate. For example:

• In Australia, where GST is 10%, substitute 0.15 with 0.1 or 15% with 10%.
• In India, where GST can be 18%, substitute 0.15 with 0.18 or 15% with 18%.
• In Canada, where some regions have a GST rate of 5%, substitute 0.15 with 0.05 or 15% with 5%.
• In the United Kingdom, where VAT is 20%, substitute 0.15 with 0.2 or 15% with 20%.

This way, the formulas will work correctly with y

how to use gst formula in excel

how to calculate gst in excel