one for Eric?

[gazm]

Morning Chaps

I've been pulling my hair out trying to work out the formula in excel that can give me a figure net of VAT. I have a function on my caculator that does it but I dont know how it does it!

can anyone help - please!!

Cheers
Gaz

[Plotloss]

=cellref/117.5%

[gazm]

Plotloss said:

=cellref/117.5%

thanks plotloss. I've been going mad trying to work that out!!

[Eric Mc]

The VAT fraction si also easy to remember - 7/47.