Calculate VAT in Excel

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

3 thoughts on “Calculate VAT in Excel

  1. shannon

    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

  2. andrew walker Post author

    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.

Leave a Reply

Your email address will not be published. Required fields are marked *