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:

1. =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:

1. =B1*1.175