Can anyone tell me the formula to work the nett figure from a gross which included vat @ 17.5% TIA
L lez Apr 29, 2007 #1 Can anyone tell me the formula to work the nett figure from a gross which included vat @ 17.5% TIA
L lez Apr 29, 2007 #3 Cheers thanks for that Barb Reinhardt said: Net * 1.175 = Gross Net = Gross / 1.175 Click to expand...
Cheers thanks for that Barb Reinhardt said: Net * 1.175 = Gross Net = Gross / 1.175 Click to expand...
S Stan Brown Apr 29, 2007 #4 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% Click to expand... If A1 contains gross, then A1 is 117.5% of net. To find net, divide: =A1/1.175
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% Click to expand... If A1 contains gross, then A1 is 117.5% of net. To find net, divide: =A1/1.175
N Nick Hodge May 5, 2007 #5 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/
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/