To calculate 18% GST in Excel, multiply the base price by 0.18 0 . 1 8 (=BasePrice*0.18) to find the tax amount, or multiply by 1.18 1 . 1 8 (=BasePrice*1.18) to get the total price including GST. For reverse calculation (removing GST from the total), use =TotalAmount/1.18.
Apply the GST Formula Use a formula like = B2 - B2 / 1.15 for a 15% tax rate to calculate the GST amount. Adjust as needed for different tax rates. (This approach works similarly for other tax rates—just replace 1.15 with 1 + (GST Rate/100). For example, if the GST rate is 18%, use 1.18 instead.)
The different slabs for GST are 5%, 12%, 18% and 28%. GST calculation can be explained by a simple illustration : If a goods or services is sold at Rs. 1,000 and the GST rate applicable is 18%, then the net price calculated will be = 1,000+ (1,000X(18/100)) = 1,000+180 = Rs. 1,180.
Calculation: Base Price: ₹50,000. GST Amount: ₹50,000 × 18% = ₹9,000. Total Amount: ₹50,000 + ₹9,000 = ₹59,000.
The formula for calculating GST is to multiply the net price (exclusive of GST) by 1.1 or divide the price including GST by 11 to determine the GST component.
Reverse Charge Mechanism & Calculation
Let's find out. If you have a GST-inclusive sales price and wish to calculate the 15% GST component of the total price, you can either divide it by 1.15 or follow this formula: Multiply the total sales price by 3. Divide the result by 23.
To calculate a percentage, divide the "part" by the "whole" and then multiply the result by 100; the formula is (Part / Whole) x 100. For example, to find what percentage 20 is of 50, you'd do (20 / 50) x 100, which equals 40%.
To calculate 18 percent of a number, you can multiply the number by 0.18 (which is the decimal equivalent of 18%). The result will be 18% of the original number.
To subtract a percentage in Excel, use a formula like =OriginalValue * (1 - PercentageToSubtract) or =(FinalValue - OriginalValue) / OriginalValue and format the cell as a percentage (Home > % button or Ctrl+Shift+%) to see the result as a percentage, which effectively shows the negative change or decrease. For example, to reduce 100 by 10%, use =100*(1-10%), and to find the % decrease from 100 to 90, use =(90-100)/100 then format.
To calculate the percentage of a total, divide the part (the specific amount) by the whole (the total amount) and then multiply the result by 100 to get the percentage. The simple formula is: (Part / Whole) × 100 = Percentage (%). For example, if 10 dogs are in a group of 40 animals (10 / 40 = 0.25), then 0.25 * 100 equals 25%, so 25% of the animals are dogs.
To work out the cost including GST, you multiply the amount exclusive of GST by 1.1. You divide a GST inclusive cost by 11 to work out the GST component. A taxable sale must be: for payment of some kind.
As an example, if you entered a sales amount of $100 in cell A2 and the tax rate is set at 7% in cell B2, the formula =A2*B2 will generate the sales tax once you press Enter.
For adding GST, the following formula is used. For example, if a product or service costs Rs. 100 and the GST levied on that is 18%, the GST amount will be 100 x 18% = Rs. 18. The net amount you'd have to pay would be Rs. 118.
GST Amount = (Selling Price x GST Rate) / 100. Here, the Selling Price is determined by adding the Cost Price and Profit Amount. The calculator factors in the Selling Price, representing the total value of goods or services subject to GST, and the GST rate, which fluctuates based on the nature of the goods or services.
With the free GST calculator, you can calculate the tax amount in three simple steps. The tool provides you with three fields that have to be filled, and it calculates GST automatically based on what you fill in. Enter the price of the goods or services in the Amount field.
For example, if the total price is ₹118 with an 18% GST, the person would type =118 / 1.18' in Excel to find the original price of ₹100. Extract GST Amount: After finding the base price, they can calculate the GST amount by subtracting the base price from the total price. For example, ₹118 - ₹100 = ₹18.
18% GST on ₹2,000 is ₹360. So, ₹2,000 includes ₹305.08 as GST. Yes, a GST calculator app helps you instantly calculate CGST, SGST, IGST, and total amounts without manual formulas.
Understanding GST Rate Reduction
Starting September 22, 2025, the GST Council reduced the number of tax slabs from four to two main rates: 5% merit rate for essential and priority items and 18% standard rate for most other goods and services. There is also a special 40% rate for luxury and sin goods.
Example
How can I calculate Reverse GST using Excel? In Excel, you can calculate the base price using: =Total Price / (1 + GST Rate/100) . To get the GST amount, subtract the base price from the total price. Create columns for GST rate, total price, base price, and GST amount to automate the process.
How to calculate taxable income – Step by Step