+ Reply to Thread
Results 1 to 2 of 2

Using IF statements with Data Validation lists

Hybrid View

  1. #1
    Registered User
    Join Date
    07-10-2015
    Location
    Cardiff, UK
    MS-Off Ver
    2013
    Posts
    1

    Using IF statements with Data Validation lists

    In column A I have a Data Validation list. There's only three things on the list, lets call them option A, option B and option C.

    Column B is dependent on column A. If option A is selected from the data validation list, I want column B to remain blank. But if option B or option C is selected from the data validation list, I'd like the text "N/A" to appear in column B. Is this possible? I've tried using an IF statement but it doesn't seem to be working.

    I'm using Excel 2013.

    Thanks in advance for your help

    P.S my apologies if I have posted this in the wrong area

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Using IF statements with Data Validation lists

    welcome to the forum, aledc. well, if it's just 3 options, maybe:
    =IF(OR(A1={"","option A"}),"","N/A")

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

+ 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. [SOLVED] If Then Statements Linked to Data Validation Lists on Different Sheet
    By moosetales in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-14-2014, 01:43 AM
  2. Excel 2007 : Data Validation Lists with IF statements
    By bradley2012 in forum Excel General
    Replies: 1
    Last Post: 05-01-2009, 08:52 AM
  3. [SOLVED] If statements with validation lists
    By Tony Houston in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  4. [SOLVED] If statements with validation lists
    By Tony Houston in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] If statements with validation lists
    By Tony Houston in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM

Tags for this Thread

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