Data Validation If Then

Question

Data Validation If Then

[Closed]

Report

Chris - Aug 25, 2015 at 01:49 PM
xpcman

Posts: 19532
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.

Data Validation If Then
Combine if statement and data validation - Forum - Excel
Excel data validation list from table multiple columns - How-To - Excel
Multiple if statements in excel data validation ✓ - Forum - Excel
Excel IF statement with Data Validation - Forum - Excel
Excel - Data validation formula - How-To - Excel

1 reply

Ask a question

xpcman · Answer 1 · 2015-08-25T13:52:52-0400

Answer 1 / 1

xpcman

Posts: 19532
Registration date: Wednesday October 8, 2008
Status: Contributor
Last seen: June 15, 2019

1,914
Aug 25, 2015 at 01:52 PM

So Bank Of America can make more money?

Data Validation If Then

1 reply

Your reply

Subscribe To Our Newsletter!