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%


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

    VAT at 20%

  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….
    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 *