Skip to main content

Determine net price based on gross price in Excel

The net price formula is composed of the gross price divided by 119 (19%) VAT multiplied by 100. The whole we round to a maximum of 4 decimal places:

=ROUND([@Price]/119*100;4)

Example:

  1. For this purpose, we create a new column next to the price column called "Net price".

  2. Now we switch to the first cell where we want to enter the formula (don't forget: set the cell format to standard so that the formula is calculated).

  3. Using the formula bar we enter the formula =Round([@Price]/119*100;4). Then we copy the formula to the lower cell.

Now you can immediately see the corresponding net price for each price.