In the CGST column, use a formula that checks if the transaction is local. Usually, you can simply divide the total tax by two: =(Base Price * GST Rate%) / 2 Step 3: Automate the Total
Label cells A1 through F1 as: . Step 2: Input the GST Logic gst calculator download excel
Explaining how to handle within your sheet. In the CGST column, use a formula that
The original value of the goods or services before tax. GST Rate: The applicable slab (0%, 5%, 12%, 18%, or 28%). Tax Components: In the CGST column