Results 1 to 2 of 2

Thread: Drop down list with automatic computation for the input

  1. #1

    Drop down list with automatic computation for the input



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

    Hi to all. I just want to ask if its possible for this to happen. I wanted to make a drop down list with these choices "Transportation, Miscellanneus, Meals, Repairs".

    Let's say I chose Transportation and in the next cell I manually input 5$. Also in the next cell, all inputs that i chose on transpo will add up and also for the misc, meals and repairs.

    Also if possible, because I use this daily, all the dates will automatically sort from Jan 1 to Jan 30 for example.

    Thank you and God Bless!

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    885
    Articles
    0
    Excel Version
    Excel 2013
    If you add a file attachment with the expected results and your attempt at calculating, perhaps someone help you because it will be clearer
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Posting Permissions

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