+ Reply to Thread
Results 1 to 9 of 9

Help With Calculating Percentages & relating numeric values to letters

  1. #1
    Registered User
    Join Date
    08-30-2016
    Location
    UK
    MS-Off Ver
    Excel for MAC
    Posts
    23

    Cool Help With Calculating Percentages & relating numeric values to letters

    Im trying to create a Purchase order form, amongst other problems I'm facing, the one I'm trying to tackle at the moment is as follows,

    I'm trying to use letters as 'code' for Tax percentages, take a look at the following

    Screen Shot 2016-08-30 at 21.13.15.png

    so after i have entered the quantity and the unit price, the 'amount' column will populate with a simple
    '=[unit price]*[quantity]' when i then enter 'S' into the 'TAX' Column i want it to add 20% onto the 'amount' column

    but just to make it that bit trickier i have about three different letters representing different tax percentages

    I'm pretty much a noob to excel, I'm pretty literate and capable but simple explanations would help haha

    many thanks
    Last edited by dannyjok1990; 08-30-2016 at 04:52 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: [help]

    Please read and adhere to these simple rules!

    1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    after that.

    1. It would help to see the workbook.

    You get better help on your question if you add a small excel file, without confidential information.

    Please also add manualy the expected result in your file.

    To Attach a File:

    1. Scroll down to the window below your post Additional Options
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    08-30-2016
    Location
    UK
    MS-Off Ver
    Excel for MAC
    Posts
    23

    Re: [help]

    Hi, I do sincerely apologise and i will make sure in future i do not make that mistake again, if there is a way i can change the thread title i will do so. I'm fairly new to this!

    I have attached a copy of the spreadsheet, it has some company info in it but i do not feel it is sensitive as its readily available in the public domain anyway.

    Maybe it will make it easier for people to understand what I'm trying to do

    eventually i want to make this so i have
    the total VAT
    sequential P.O Numbers that automatically pick up where the last one left off
    a button that will automatically save the PO as a pdf
    Last edited by dannyjok1990; 08-30-2016 at 07:23 PM.

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,575

    Re: [help]

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: [help]

    I think i can be done, if you edit the first question. (the edit button is on the right side hand).

  6. #6
    Registered User
    Join Date
    08-30-2016
    Location
    UK
    MS-Off Ver
    Excel for MAC
    Posts
    23

    Re: [help]

    I got it, thanks everyone!

  7. #7
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Help With Calculating Percentages & relating numeric values to letters

    What are the letters and their associated tax rates?
    Entia non sunt multiplicanda sine necessitate

  8. #8
    Registered User
    Join Date
    08-30-2016
    Location
    UK
    MS-Off Ver
    Excel for MAC
    Posts
    23

    Re: Help With Calculating Percentages & relating numeric values to letters

    Somebody helped me solve it, thanks anyway

    =IF(D19="",(C19*B19),((C19*B19)/100)*VLOOKUP(D19,TaxCODES,2)+(C19*B19))

  9. #9
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Help With Calculating Percentages & relating numeric values to letters

    Good job !

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1