GST stands for Goods and Services Tax. Calculating GST is going to be made easy, with these simple steps. We are going to calculate it together.

You should first layout the price before the GST.


Click on the column beside GST amount, and decide how many percentage you would like the GST to be. We are going with 15%, and therefore writing =B1*0.15


Note: the GST amount has to be in form of percentage, and use only between 0.0 to 1.

Click on the column beside amount with GST, and type in =B1+B2 to get the answer.


This is how to calculate GST in Excel. You can download free GST calculator template here