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:
- Data validation with if statement
- Fenix internet on bank statement - Guide
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- Application for bank statement sbi - Guide
- Gta 5 data download for pc - Download - Action and adventure
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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" ?
