+ 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
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel365
    Posts
    2,224

    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)

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