Process to remove VAT before applying it
When you need to calculate VAT before adding it to the base cost, as a subtotal, you start with the base cost without the tax. Here it is in cell B3.
Set your VAT rate (in decimals or percentage) in the following cell. Here it was B4.
First you need to calculate the VAT on the base cost, multiplying the two previous cells. The formula then becomes =(B3*B4).
To obtain our total with VAT, you add the colombia phone data base cost (B3) to the VAT you just obtained in the previous step (B5) to the final cost. The formula for this calculation is =(B3+B5).
Tip: Did you notice that the VAT rate was marked as a percentage and not as a decimal? In case it's easier for you to do it this way, you need to change the property of the number, and you can do this in the numbers tab at the top left of the Excel toolbar or by entering the number directly followed by the '%' symbol.
Calculation of VAT on base cost in border area
Procedure for calculating VAT in Excel in border areas
Just like in the first example, you need to enter the base cost (before taxes) in a cell. Here the value is in B3.
Next, set the VAT rate you want to apply. For border areas, it corresponds to 8% in Colombia and Mexico, that is, the VAT corresponds to 1.08 in decimals, as shown in cell B4.
Finish by applying the formula to multiply the two previous cells. The formula would be =(B3*B4) to obtain your total with border zone VAT applied.