UK VAT question

[lez]

Can anyone tell me the formula to work the nett figure from a gross which
included vat @ 17.5%

TIA

 

[Guest]

Net * 1.175 = Gross
Net = Gross / 1.175

 

[lez]

Cheers thanks for that

Net * 1.175 = Gross
Net = Gross / 1.175

 

[Stan Brown]

Sun, 29 Apr 2007 17:00:53 +0100 from lez

Can anyone tell me the formula to work the nett figure from a gross which
included vat @ 17.5%

If A1 contains gross, then A1 is 117.5% of net. To find net, divide:
=A1/1.175

 

[Nick Hodge]

lez

=IncVAT*.851

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/