Data Validation If Then

[Closed]
Report
-
Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
-
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.


1 reply

Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,914
So Bank Of America can make more money?