How to Calculate GST in Excel
Excel makes it easy to calculate GST with just a few formulas. Here's how:
Scenario 1: Price Without GST
=A2 * 0.18
Scenario 2: Price Includes GST
=A2 - (A2 / 1.18)
Breakdown:
- CGST = A2 * 0.09
- SGST = A2 * 0.09
Use the ROUND function to keep decimals clean.
Comments
Post a Comment