v a t
 

how do you enter a formula for 17.5 % v a t

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

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