VAT

Resolved · High Priority · Version 2003

Tue 15 Jul 2008, 16:52 Delegate Mona said...

Mona has attended:
Excel Intermediate course

VAT

How do you calculate VAT and what is the formula sign for divide

Wed 16 Jul 2008, 08:49 Edited on Wed 16 Jul 2008, 08:50 Trainer Pete said...

RE: VAT

Hi Mona,

Welcome to the forum, I hope you enjoyed your course. In response to your post:

Divide = / (the forward slash)

Don

Mon 28 Aug 2023, 16:07 Trainer Rich said...

RE: VAT

Hi Mona,

To calculate VAT, you multiply the ex-vat value by 0.20 (assuming VAT rate is 20%)

In Excel, if the ex-vat price is in cell A1, then to calculate the VAT you could use a formula such as =A1*0.20

To have a variable VAT rate, you could have 0.20 in another cell, such as B1, and then use a formula such as =A1*B1 to work out VAT.

If you then want the total inc. vat price, you can have another cell with =A1+A2 to work out the total (Assuming your VAT calculation was in A2).

Hope that helps.
Regards, Rich

Excel tip:

How to select certain data in an Excel 2010 workbook

If you want to select the correct data set in a page full of data, the most accurate and efficient way of doing this is to use the ''Shift and Click'' technique.

For example: If you want to select all data in cells A2 to E10, then click on cell A2, hold down the Shift key and click on cell E10 and all the data you want to see is highlighted.

Keep holding down the Shift key and you can move from cell E10 to any other cell in the spreadsheet.

View all Excel hints and tips

VAT

VAT

RE: VAT

RE: VAT

Excel articles

Excel tip:

How to select certain data in an Excel 2010 workbook