Calculating Net Price from Gross Price
To calculate the Net price when you only have the Gross figure, you can use the following formula:
Net Price = Gross Price / 1.175
Calculating Gross Price from Net Price
To reverse the calculation and find the Gross Price when you only have the Net Price, you can use the following formula:
Gross Price = Net Price * 1.175
Using the Formulas in Excel
To use these formulas in Excel, simply enter the formula into a cell and replace "Gross Price" or "Net Price" with the appropriate cell reference. For example, if your Gross Price is in cell A1, you would enter the following formula in another cell to calculate the Net Price:
- =A1/1.175
And if your Net Price is in cell B1, you would enter the following formula in another cell to calculate the Gross Price:
- =B1*1.175