How to calculate GST Price for Bills using Excel formulas

0 7


Formula for calculating the total including GST

There are times when you only want to calculate the Total figure including the GST. So let’s now have a look at calculating the total including GST.  

This time we multiply the total by 115% or by 1.15.

In the example below cell B12, which is the figure without GST (exclusive figure) is being multiplied by 1.15 to calculate the Total including GST. The same result would have been found if you had used 115% instead of the 1.15.