Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
v a t
how do you enter a formula for 17.5 % v a t
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
v a t
Hi
It depends what you are after. With A1 containing 17.5% (or containing 0.175) With B1 containing the Net of VAT value Vat to charge =B1*A1 Gross figure including VAT =B1*(1+A1) To convert from Gross figure to Net of VAT figure, if Gross value is in C1 Net = C1/(1+A1) -- Regards Roger Govier "hay eddie" <hay wrote in message ... how do you enter a formula for 17.5 % v a t |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
v a t
Nel post
*hay eddie* ha scritto: how do you enter a formula for 17.5 % v a t In A1 the value you want to calculate vat for: In A2: =A1*(1+.175) or =A1*(1+17.5%) -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|