what is the formula to work out gst in excel?
To do this you simply multiply the value, excluding GST by 15% or by 0.15. To find the total including GST simply add the two values together. In the example below B5 has been multiplied by 0.15, which is the same as 15%. You can type either value into the formula and Excel will give you the correct answer.