Tue 18 Sep 2007, 10:19Delegate Cat said...
Cat has attended:
Excel Intermediate course
Formulas - VAT
How do I create a formula so that I can calculate VAT in a Purchase Order form?
Mon 1 Oct 2007, 14:11Trainer Amanda said...
RE: formulas - VAT
Hi Cat
Thank you for your question.
You will need to use a multiplication
=amount*17.5%
If you wish you can enter the 17.5 % into a cell on the spreadsheet and then use that cell in the formula rather than entering 17.5% directly into the formula.
I hope this helps.
Amanda
