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

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

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.