Results 1 to 5 of 5

Thread: Tax Percentage

  1. #1
    Neophyte steve23's Avatar
    Join Date
    Apr 2015
    Location
    U.K.
    Posts
    1
    Articles
    0

    Tax Percentage



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Trying to get percentages to work.

    Columns added up to =SUM(C3:I3) want to add 20% tax and then total.

    Any help please.

  2. #2
    =sum(c3:i3)*1.2

  3. #3
    so what is 1.2 instead of 20 what if you want 30....

  4. #4
    Quote Originally Posted by tp55 View Post
    so what is 1.2 instead of 20 what if you want 30....
    This might help you

    =SUM(C3:I3)*(1+20%)

    1 because you need to include the original amount, and .2 is 20%

  5. #5
    ok... 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
  •