+ Reply to Thread
Results 1 to 3 of 3

Data Validation Custom Formula

  1. #1
    Registered User
    Join Date
    01-12-2019
    Location
    Boston MA
    MS-Off Ver
    365
    Posts
    2

    Data Validation Custom Formula

    Hi,
    I am trying to use Data Validation to allow only the number 1 if specific items are chosen from another cells drop down list, otherwise allow any number.

    The drop down list in one column is were they choose the event. The other column is were they enter number of attendees. For specific events we only want to allow 1 because we want to only count the event not the number of attendees.

    This is want I put together, but not working.
    =IF(OR(D2="Traffic Safety Coalitions",D2="Task Forces",D2="Commissions",D2="Police Chiefs Associations",D2="Safety Officers Leagues",D2="Branch Events"),1)

    Any help is much appreciated

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Data Validation Custom Formula

    Please try Custom Data Validation at A1

    =IF(OR(D2="Traffic Safety Coalitions",D2="Task Forces",D2="Commissions",D2="Police Chiefs Associations",D2="Safety Officers Leagues",D2="Branch Events"),(A1=1),ISNUMBER(A1))

    You may change A1 to another cell.

  3. #3
    Registered User
    Join Date
    01-12-2019
    Location
    Boston MA
    MS-Off Ver
    365
    Posts
    2

    Re: Data Validation Custom Formula

    Bo,
    Awesome job. Thanks so much for your help, and especially how quick it was. Much appreciated!

+ 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] Need Formula in Data Validation Custom
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-22-2016, 12:45 AM
  2. Custom Data Validation formula
    By KellyAustralia in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-17-2015, 08:27 PM
  3. [SOLVED] Formula for custom data validation
    By Butcher1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-07-2015, 04:53 PM
  4. [SOLVED] Data Validation Custom Formula
    By dmartinet in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-11-2014, 03:33 PM
  5. Data Validation Custom Formula
    By turist in forum Excel General
    Replies: 3
    Last Post: 04-09-2014, 04:18 PM
  6. Custom data validation formula
    By Stan5582 in forum Excel General
    Replies: 12
    Last Post: 03-24-2014, 02:32 PM
  7. Data Validation Custom with Formula
    By bacalhoun in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-28-2007, 03:38 PM

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