The formula in D2 is =B2*C2/(1+C2)![]()
----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
In E2, =B2-A2-D2
The formula in D2 is =B2*C2/(1+C2)![]()
----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
In E2, =B2-A2-D2
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks