+ Reply to Thread
Results 1 to 2 of 2

Assistance with IT coursework

  1. #1
    Registered User
    Join Date
    11-24-2007
    Posts
    1

    Assistance with IT coursework

    I am a beginner in excel and am doing my GCSE coursework.
    For this, I am making a smoothie calculator. Basically the idea is the customer says 'I want an apple and banana and err orange smoothie' and then the shopkeeper figures out the price using this calculator. So on my calculator I have the names of the fruits in one column , and in the cell next to the fruit name I have a a dropdown thing. what I want to do is to have a list of the prices of each fruit somewhere else invisible on the page, and the shop keeper use's the drop down list to select, say, 2 oranges. So the number 2 will appear in the cell next to the cell saying orange. It (excel) automatically calculates the price of 2 oranges and adds to a different cell at the bottom, where the whole smoothie price is calculated. This cell will also have to automatically add on the price of ice and any other fruits that have been added by the shop keeper.
    How do I this? can I do this on excel? Tell me if I need to explain more
    also once this is done I have another question

    Also after reading the rules I have realised I've cross-posted. However it is not on a excel help forum nor one based on computers and I have posted basically the exact same thing so I do not see the reason to post the URL?
    no-one has replied anyway and are not as expert as you guys. any help appreciated

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    A good starting point would be to look at data-validation-list to get your drop downs.

    The multiplications and additions can be handled with simple formulas.

    One neat way of making the price look ups invisible but still convenient (maybe adjacent to the fruit names) is to format their font to white.

    Hopefully this will get you started.
    Martin

+ 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