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
Bookmarks