Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

conditional validation

0

i have 2 cells A1 AND A2, A1 is a drop down box with two options YES/NO. Now my requirement is if I select YES in A1, A2 should be 0(Zero) by default and if A1 is NO, then i could enter my desired value.

Is there any such formulae in Excel?

Kindly tell me.

exceldata-validation
MS Office Version: 2010
posted by: Kiran on Fri Apr 7, 2017 at 1:29 pm
Answer
Discuss

Discussion

Please don't forget to select the answer that worked best for you! Just click the Select Answer button at the bottom of the desired answer.
cappymer1 (rep: 120) Apr 10, '17 at 12:18 pm
Add to Discussion

Answers

0

Try this as a custom validation formula:

=IF(A1="no",TRUE,IF(A1="yes",A2=0))

However, the user will have to enter 0 into cell A2 or leave it blank. With fomulas, this can't happen automatically.

posted by: don (rep: 1989) on Sun Apr 9, 2017 at 8:13 am
Discuss

Discussion

Hi Thnx for your reply, i have applied this formula in custom validation, but it is not working. When i select "YES" in A1 cell, the A2 it is not showing 0.
Kiran Apr 10, '17 at 10:45 pm
Did you read that last sentence in my answer?

If you want 0 to automatically populate, try out Kevin UK's answer.
don (rep: 1989) Apr 12, '17 at 5:48 am
Add to Discussion
0

What if you use C1 for your default value?

=IF(A1="YES",0,C1)

posted by: Kevin UK on Sun Apr 9, 2017 at 12:23 pm
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login