Thread: Excel - working out net and vat?
View Single Post
Old 09-01-2011, 15:14   #20
progers
Pete
 
Join Date: Jan 2004
Location: Nuneaton
Services: Broadband Up to 100Mb ~ TV Mix & TiVo 1Tb ~ Phone: Talk More Anytime
Posts: 1,057
progers is just so famous around these partsprogers is just so famous around these partsprogers is just so famous around these partsprogers is just so famous around these partsprogers is just so famous around these partsprogers is just so famous around these partsprogers is just so famous around these partsprogers is just so famous around these partsprogers is just so famous around these partsprogers is just so famous around these partsprogers is just so famous around these partsprogers is just so famous around these partsprogers is just so famous around these partsprogers is just so famous around these partsprogers is just so famous around these parts
Re: Excel - working out net and vat?
A price including VAT (before it went up) is equivalent to 1.175 times the nett price so the nett price is the price with VAT divided by 1.175 and the VAT is the price with VAT minus the nett price
progers is offline   Reply With Quote