How To Calculate GST In Excel

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.

data

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

formula

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.

calculated

This is how to calculate GST in Excel.

Template

You can download the Template here – Download
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell