Combine IF statement with validation list
Closed
DJS
-
Aug 17, 2011 at 08:10 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 18, 2011 at 06:00 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 18, 2011 at 06:00 PM
Related:
- Multiple if statements in excel data validation
- How many if statements can you nest - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Excel data validation list from table multiple columns - Guide
- If then statements in excel - Guide
- Number to words in excel - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Aug 18, 2011 at 10:15 AM
Aug 18, 2011 at 10:15 AM
Hi DJS,
What do you mean by "combine this with option 1"?
A1: Contains drop down list.
B1: Contains IF formula to display either "Not applicable" or "".
B2: Contains drop down list based on value in A1.
Could you explain in a different or more detailed way?
Best regards,
Trowa
What do you mean by "combine this with option 1"?
A1: Contains drop down list.
B1: Contains IF formula to display either "Not applicable" or "".
B2: Contains drop down list based on value in A1.
Could you explain in a different or more detailed way?
Best regards,
Trowa
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 18, 2011 at 06:00 PM
Aug 18, 2011 at 06:00 PM
why not have another list with just one value of ""Not applicable" ?
