L
lez
Can anyone tell me the formula to work the nett figure from a gross which
included vat @ 17.5%
TIA
included vat @ 17.5%
TIA
G
Guest
Net * 1.175 = Gross
Net = Gross / 1.175
Net = Gross / 1.175
L
lez
Cheers thanks for that 
Barb Reinhardt said:
S
Stan Brown
Sun, 29 Apr 2007 17:00:53 +0100 from lez
If A1 contains gross, then A1 is 117.5% of net. To find net, divide:
=A1/1.175
If A1 contains gross, then A1 is 117.5% of net. To find net, divide:
=A1/1.175
N
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/
=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/