How to Calculate GST Amount in Microsoft Excel ? CGST, SGST, IGST. #accountancy #gst #dataanalysis

In this video, learn how to calculate GST at 18% in Excel with a simple formula. Follow these steps:

1. Open Excel and enter your Amount in a cell, for example, cell A2.
2. To calculate GST at 18%, type this formula in another cell, like B2:

=A2 * 18%
3. Explanation:

The formula =A2 * 18% calculates 18% of the amount in cell A2.

This gives you the GST amount separately, making it easy to see how much GST you're paying on any given amount.
4. If you want the total including GST:

Type the following formula in a new cell (e.g., C2):

=A2 + (A2 * 18%)

This formula adds 18% GST to the original amount, giving the GST-inclusive total.
With these simple formulas, you can quickly calculate GST on any amount in Excel. This method is especially useful for businesses, students, or anyone handling finances with GST calculations!
--To calculate GST at 12% in Excel, here’s a quick method:

1. Enter the Amount in cell A2.
2. Calculate GST (12%):

In cell B2, type:

=A2 * 12%
This gives you the GST amount.
3. Calculate Total Including GST:

In cell C2, type:

=A2 + (A2 * 12%)
This will show the amount with 12% GST included.

Thank you #educationalvideo #accountancy #teaching #technology #dataanalysis #education #youtube #excelformula #excel

Видео How to Calculate GST Amount in Microsoft Excel ? CGST, SGST, IGST. #accountancy #gst #dataanalysis канала Learn Accounts & Excel By Varsha