v a t

  • Thread starter Thread starter Guest
  • Start date Start date
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)
 
Nel post *hay eddie* ha scritto:
how do you enter a formula for 17.5 % v a t
Click to expand...

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
 
Back
Top