----A---- ----B---- ---C---- ---D--- ---E----
  1   Unit Cost Unit Sell VAT Rate VAT Amt Unit Net
  2       $1.50    $10.00    17.5%   $1.49    $7.01
  3       $1.50    $10.00    20.0%   $1.67    $6.83
The formula in D2 is =B2*C2/(1+C2)

In E2, =B2-A2-D2