Using formulas to calculate VAT??

Question

Level 1

0 points

Using formulas to calculate VAT??

On my invoices i'd like to be able to type in the net amount and get pages to calculate the VAT (17.5%) and the gross figure.
I'm new to formulas so make it simple please.

quad xeon, Mac OS X (10.4.9)

Posted on Jun 1, 2007 3:48 AM

Reply

Answer 1

Jun 2, 2007 1:09 AM in response to GGGilbert

Just create 3 cells nett vat and total. To give you an example place 100 in the nett cell. Next in the vat cell press = this will bring up the formula editor click on the 100 cell to give you the cell name,then command asterisk and .175 (no gaps) press return his wil give you 17.5. Next click on the total cell press = to bring up the formula editor click on 100 cell followed by 17.5 cell press return and this should give you a total of 117.50

macbook

Reply