HOW DO I SHOW VAT CONTENT

J

josudare

trying to set up a spreadsheet and final column must show vat content but
can't work it out
 
P

Peo Sjoblom

Assuming you have the total price in D2 then you can use


=D2-D2/(1+17.5%)

to get the VAT

Since we are dealing with money you might want to add ROUND to it

=ROUND(D2-D2/(1+17.5%),2)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WordPad blocked content 2
entering VAT rate 2
Office JS api to handle redo/undo , delete event for content control class 0
Working out VAT owed 1
Vat formulas 3
Can't save my Office documents (after computer rebuild and reauthorization) 0
Variable VAT by product and customer 2
VAT on Report 5

Top