+ Reply to Thread
Results 1 to 7 of 7

Vmarkup help

  1. #1
    Registered User
    Join Date
    10-14-2009
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Vmarkup help

    I have a table, as part of an assesment task i am doing, with dates, and a course fee.
    Part of the assesment task is to write a formula, to work out how many days in advance the customer paid, and then apply the needed discount.

    I found a previous thread but cant seem to get that formula to work.

    I have attached what i have so far

    Thanks heeps
    Attached Files Attached Files

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Vmarkup help

    Welcome to the Board.

    Unfortunately there's very little to go on with your sample file - you don't specify what the discounts should be and on what basis they're applied nor do you specify where you intend to display the results.

    Might be an idea to provide a more detailed sample file outlining clearly all requirements and expected output based on sample data.

  3. #3
    Registered User
    Join Date
    10-14-2009
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Vmarkup help

    Sorry New to forums and not very good with excell
    thanks for looking.

    Use a VLOOKUP function in your template to determine the discount rate to be used for the calculation of the Discount. Your template should include a separate discount table containing the following information about the discount received:
    • If students pay the course fee less than 7 days prior to the course commencing then they receive no discount.
    • If students pay the course fee 7 to 13 days prior to the course commencing then they receive a discount of 5%.
    • If students pay the course fee 14 to 20 days prior to the course commencing then they receive a discount of 8%.
    • If students pay the course fee 21 days or more prior to the course commencing then they receive a discount of 10%.
    Format the document appropriately. Save it as a template called CourseFeesPaid in the Drafts folder.
    Use the template you created to enter the following data for Term 3:
    Student Name
    Course Code
    Course Name
    Date Course Commences
    Date Paid
    Course Fee
    Joseph Lee
    40748
    Bookkeeping
    9 Sep
    1 Sep
    $395
    Erica Taverner
    43255
    Time Management
    12 Sep
    11 Sep
    $250
    Wing Su
    40847
    Office/Reception Skills
    15 Sep
    31 Aug
    $300
    Sam Abboud
    40288
    Workplace Assessment
    1 Sep
    5 Aug
    $690
    Jess Brown
    40748
    Bookkeeping
    9 Sep
    31 Aug
    $395
    Derek Chan
    40847
    Office/Reception Skills
    15 Sep
    20 Aug
    $300

  4. #4
    Registered User
    Join Date
    10-14-2009
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Vmarkup help

    I have no leaning matirial and cant get my head around it

  5. #5
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Vmarkup help

    Given this is homework I'm providing you with one solution which is not what's asked for in the question, eg:

    H2: =F2*(1-LOOKUP(MAX(0,D2-E2),{0,7,14,21},{0,0.05,0.08,0.1}))
    copied down

    you need to convert the above LOOKUP into a VLOOKUP (use of a table) - the two are very similar - see XL Help for more info. on VLOOKUP.

  6. #6
    Registered User
    Join Date
    10-14-2009
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Vmarkup help

    i will display the resuts in "h"

  7. #7
    Registered User
    Join Date
    10-14-2009
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Vmarkup help

    Thank you very much a great help "I Think" Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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