I wonder if anyone knows how to extract VAT from an amount in a cell. Can you set up a formulae, which if you place an amount in a cell it then asks you for the VAT amount within that figure?
Basically I am trying to do book keeping and have downloaded a chart from Microsoft. I list everything in Gross amounts, I am now wondering if I can show a better picture by also having one vAT column at the end, but that I can automatically get that figure there by being asked a question at each cell input.
Sorry if im not making much sense, I am relatively new to Excel and only have a limited knowledge of what exactly can be performed.
http://www.excelforum.com/images/smilies/confused.gif