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:

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

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).

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.