Results 1 to 16 of 16

IF condition in Data Validation

Threaded View

e4excel IF condition in Data... 02-28-2011, 11:12 AM
JBeaucaire Re: Is it possible to combine... 02-28-2011, 11:36 AM
e4excel Re: Is it possible to combine... 02-28-2011, 02:04 PM
JBeaucaire Re: Is it possible to combine... 02-28-2011, 04:22 PM
e4excel Re: Is it possible to combine... 02-28-2011, 10:41 PM
JBeaucaire Re: Is it possible to combine... 03-01-2011, 03:39 AM
e4excel Re: Is it possible to combine... 03-01-2011, 09:19 AM
JBeaucaire Re: Is it possible to combine... 03-01-2011, 11:34 AM
e4excel Re: Is it possible to combine... 03-01-2011, 01:04 PM
e4excel Re: Is it possible to combine... 03-03-2011, 07:18 AM
JBeaucaire Re: Is it possible to combine... 03-03-2011, 02:06 PM
e4excel Re: Is it possible to combine... 03-03-2011, 02:43 PM
JBeaucaire Re: Is it possible to combine... 03-03-2011, 09:23 PM
e4excel Re: Is it possible to combine... 03-04-2011, 03:32 AM
JBeaucaire Re: Is it possible to combine... 03-04-2011, 11:24 AM
e4excel Re: Is it possible to combine... 03-04-2011, 01:26 PM
  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,522

    IF condition in Data Validation

    Is it possible to combine an IF condition in Data Validation?

    Dear Forum,

    I am trying to combine the Functionality of a List in Data validation and an Independent Single value if a particular condition's not met..

    It goes like this...?

    I have three Options of Investment :
    1. Option_I
    2. Option_II
    3. Option_III


    I want 2 conditions working based on the three selections, like if the USER selects the Option_I then it should display "Actual Dates" and for anything other than "Option_I" it should provide a list as below:

    1. 12 MOnths
    2. 13 MOnths
    3. 14 MOnths
    4. 15 MOnths
    5. 16 MOnths
    6. 17 MOnths
    7. 18 MOnths. --This LIst is Name Defined as AdvancePlanning

    Actually, I tried using the formula but in vain:

    [ = if($B$12="Option_I","Fixed Dates",AdvancePlanning)  ]
    It does not work...

    Am I making a mistake somewhere? or its not possible?

    Warm Regards
    e4excel
    Last edited by e4excel; 03-04-2011 at 02:14 PM.

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