+ Reply to Thread
Results 1 to 7 of 7

need to add another value in the dropbox

  1. #1
    Registered User
    Join Date
    09-30-2014
    Location
    germany
    MS-Off Ver
    ms 2010
    Posts
    4

    need to add another value in the dropbox

    RFI-Log- HICON GE ODT 14-09 V4.xlsxRFI-Log- HICON GE ODT 14-09 V4.xlsx

    I have this form and I need to add one more value to select from 4 in my due day

    =IF(B15="CRITICAL",C15+0.25,IF(B15="EXPEDITE",C15+0.5,C15+1))

    thank in advance

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: need to add another value in the dropbox

    Quote Originally Posted by rolosa View Post
    I have this form and I need to add one more value to select from 4 in my due day
    Not sure what you are trying to convey by way of the above statement

    Please make it clear for our better understanding


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    09-30-2014
    Location
    Netherlands
    MS-Off Ver
    Windows 7
    Posts
    13

    Re: need to add another value in the dropbox

    Maybe a different dropdown menu?

    Select the cells you want the dropdown menu in

    and do the following solution.jpg

    (; might be , because of a different language in excel??)

  4. #4
    Registered User
    Join Date
    09-30-2014
    Location
    Netherlands
    MS-Off Ver
    Windows 7
    Posts
    13

    Re: need to add another value in the dropbox

    solution.jpg right picture now i hope

    Dont know why picture doesnt work...

    Data --> Data validation --> List --> At variables (seperate with ; or if that doesnt work ,)

  5. #5
    Registered User
    Join Date
    09-27-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    86

    Re: need to add another value in the dropbox

    Use Data Validation as suggested above or the linked cell of the drop downs are in K15, k16... Change your formula referencing to Column 'k' instead of 'b'

    Regards,
    lokicl

  6. #6
    Registered User
    Join Date
    09-30-2014
    Location
    germany
    MS-Off Ver
    ms 2010
    Posts
    4

    Re: need to add another value in the dropbox

    Thank for your reply, but what I looking for is the capability went I put the priority request and add the date received have in due date the responte time + 3hrs, immediate +6, priority +12 and routine +24 whit the form I put only work until priority I need to add routine that I don no who

    thank

  7. #7
    Registered User
    Join Date
    09-30-2014
    Location
    germany
    MS-Off Ver
    ms 2010
    Posts
    4

    Re: need to add another value in the dropbox

    Thank for your reply, but what I looking for is the capability went I put the priority request and add the date received have in due date the responte time + 3hrs, immediate +6, priority +12 and routine +24 whit the form I put only work until priority I need to add routine that I don no who

    thank

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. DropBox Problem
    By john.ob in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-24-2014, 07:59 AM
  2. Excel VBA Code to upload a file to Dropbox using the Dropbox API
    By gb# in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2014, 03:41 PM
  3. Macros & Dropbox
    By dmoblay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2013, 09:27 AM
  4. [SOLVED] How to get sum value of dropbox values
    By isixes27ce in forum Excel General
    Replies: 3
    Last Post: 11-11-2012, 10:51 PM
  5. Excel Dropbox Help
    By systematic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2005, 01:15 PM

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