Results 1 to 9 of 9

Help With Calculating Percentages & relating numeric values to letters

Threaded View

  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.

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