Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Vat at 15% (Excel 2007)

    Hi

    Excuse my ignorances but if you arrive at 17.5% by dividing a sum by 47 and then multiply by 7 what would the formula be for 15%

    example C9 contains 117.5 D9 contains formula =C9/47*7 E9 results in 100

    what would this formula =C9/47*7 be for 15%

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vat at 15% (Excel 2007)

    I always did /117.5*17.5, which I found easier on the brain......

    C10 = 115
    D10 = =C10/115*15 Results in 15.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Vat at 15% (Excel 2007)

    Hi Nathan

    Thanks for the prompt reply, must admit that's new to me.


    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Vat at 15% (Excel 2007)

    You could put 15% (the VAT percentage) in a cell, say in H1.

    You can then use the formula

    =C9/(100%+$H$1)*$H$1

    Because the reference to H1 is absolute, you can fill down the formula and it will still refer to H1.
    And if the VAT percentage changes again, you only have to edit the value in cell H1 instead of updating all formulas.

  5. #5
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vat at 15% (Excel 2007)

    Plenty of information at HMRC.gov.uk, including the fractions - 7/47 > 3/23.

  6. #6
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Vat at 15% (Excel 2007)

    Hi Hans

    Thanks for the reply and thanks to all replied.

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •