Hi I am trying to work out what the VAT would be in excel formatt. I have the following at the moment but i cannot seem to change it to 20%

J17-SUM(J17/1.175)

i AM TRYING TO CHANGE TO 20% ?? help please

Hi I am trying to work out what the VAT would be in excel formatt. I have the following at the moment but i cannot seem to change it to 20%

J17-SUM(J17/1.175)

i AM TRYING TO CHANGE TO 20% ?? help please

Hi

Try this post about VAT…. http://www.excelgeek.co.uk/2011/01/calculate-vat-paid-in-a-total-cost/

Let’s assume you have £50 entered in cell B2. In cell C2 enter the following formula to work out the VAT and then add this to the cost for a total price including VAT.

`=B2/100*20+(B2)`

C2 should then display £60.

Hope this helps.

Thanks for writing.

I need to work out the total cost, but first I need to work out 20% to do so.

Can anyone help please?

Code Description Hours Rate Cost

SET01 Changing settings on a PC 2 £12.50 £25.00

SET03 Installing software 1 £12.00 £12.00

SUP03 Providing home tuition 2.5 £12.50 £31.25

£68.25

VAT at 20%

Total

Hello Shannon

For my working the £68.25 is in cell J20. Just adjust the formula to your cell reference. In the cell where you want the VAT to appear, type this….

`=J20*0.2`

Remember, to adjust the J20 to whatever cell it is you want to calculate the VAT to be added.

Like!! I blog frequently and I really thank you for your content. The article has truly peaked my interest.