Results 1 to 3 of 3

Thread: calculating VAT

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Oct 2002
    Location
    Propped up at a PC near you...
    Posts
    194

    calculating VAT

    I need to write a formula for excel that will work out VAT ( and I'm rubbish at maths) :

    if A1 = VAT rate

    A2 = price b4 VAT

    A3 = Price Inc. VAt Then ...

    In A3 I write the formula:
    =SUM( A2 + A1)
    ? Doesn't work - PLEASE, where am I going wrong?

  2. #2
    Frenzied Member axion_sa's Avatar
    Join Date
    Jan 2002
    Location
    Joburg, RSA
    Posts
    1,724
    A3 = ((A1 + 100) / 100) * A2

    e.g.
    Price Before VAT = 50.
    VAT = 14%
    Therefore Price inc. VAT = 50 * ((14 + 100) / 100)

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Oct 2002
    Location
    Propped up at a PC near you...
    Posts
    194
    many thanks

Posting Permissions

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



Click Here to Expand Forum to Full Width