Data Validation If Then
Closed
Chris
-
Aug 25, 2015 at 01:49 PM
xpcman Posts 19528 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 - Aug 25, 2015 at 01:52 PM
xpcman Posts 19528 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 - Aug 25, 2015 at 01:52 PM
Hello,
I have a "Yes" or "No" data validation list in cell C1 and manual input cells in D1, E1 etc. I would like to create a code that says (If C1= "No" then E1 = 0 and if C1 = "Yes" then E1 can just be a manual input.
Can you please assist.
I have a "Yes" or "No" data validation list in cell C1 and manual input cells in D1, E1 etc. I would like to create a code that says (If C1= "No" then E1 = 0 and if C1 = "Yes" then E1 can just be a manual input.
Can you please assist.
Related:
- Data Validation If Then
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Digital data transmission - Guide
- Data transmission cable - Guide
1 response
xpcman
Posts
19528
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,824
Aug 25, 2015 at 01:52 PM
Aug 25, 2015 at 01:52 PM
So Bank Of America can make more money?